Typically most hosts already provide phpMyAdmin to their customers so you might check with them.
Also review Installing WordPress for details on the database and database user.
Thread Starter
shuura
(@shuura)
Thank you! I found how how to access the phpMyadmin from my webhost, but when I try to use /wp-admin/install.php in my firefox browser nothing happens.
I created a mySQL database named “xyz” in the root directory because that was the only place I could put it. But the database “xyz” doesn’t show up when I connect to the webhost using filezilla. WordPress and all its contents are installed into a subdirectory under http://www.fourthewin.org/chuwei/ffxi/wordpress, when i put /wp-admin/install.php first a page with wordpress logo and very messy coding appeared along with a message saying wordpress is already installed, to clear database if i want to reinstall, then I attempted to open “www.fourthewin.org/chuwei/ffxi/wordpress/wp-admin/install.php” but nothing happens
also I am confused on how to access the dashboard ..
You won’t see the database when connecting via FTP–usually the database is kept somewhere else by your host–that’s why they give you phpMyAdmin and typically a method to create databases and database users.
Please talk to your host about creating databases and database user–then use that information to complete your wp-config.php. Again Installing WordPress is a good resource.
Thread Starter
shuura
(@shuura)
thank you for all your help so far, I have been using and following the Installing WordPress guide to the best of my ability but I unable to access the control panel that changes the privileges on the phpMyAdmin screen, the username, host name and MySQL database name and password etc have all been set up already and I’m confident I will be able to properly edit the /wp-config.php file later,
However: my webhost runs version 3.1.5 of phpMyAdmin, I think this is different from the version the WordPress installation guide because I cannot find any link to change privileges. I clicked on the Home icon and this is what it looks like. I tried clicking through all the possible links and tabs but did not find anything remotely similar to the description in the WordPress installation guide about usernames and checkboxes and setting global privileges. I am also not familiar with SQL queries so I don’t know how to change it manually via the MySQL client either.
I tried going to the MySQL tab and copy pasting the command
“mysql> GRANT ALL PRIVILEGES ON databasename.* TO “wordpressusername”@”hostname”
-> IDENTIFIED BY “password”;”
into the “Run SQL query/queries on server ” box by replacing the databasename and wordpressusername and password I created and using the localhost for the host name, but that didnt’ work either so I am running out of ideas on how to get past this granting user privilege step..
I was a bit confused, but got pass those steps.
Check your wp-config.php
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘XYZ’);
/** MySQL database username */
define(‘DB_USER’, ‘user of your database’);
/** MySQL database password */
define(‘DB_PASSWORD’, ‘password.’);
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);
Warning- localhost (127.0.0.1) may not be the correct hostname for your database. Consult your host and ask them what the hostname should be if localhost or 127.0.0.1 does not work.
phpMyAdmin is what you use to create or delete a database. You can use it to create a user and password for the database you created.
—–“mysql> GRANT ALL PRIVILEGES ON databasename.* TO “wordpressusername”@”hostname”
-> IDENTIFIED BY “password”;——
mysql> is the COMMAND LINE. This would be IF you owned or had direct access to the computer. Since the server is on your host, you likely will NOT have command line access.
1. So you would use PhpMyAdmin to create the MySQL database, user, and user password.
2. You would then put that information into wp-config.php
Thread Starter
shuura
(@shuura)
@esok I have already done all that :/ my problem is granting privileges to the username I created for the mySQL database.
My understanding is that you could use PhPMyAdmin to grant privileges to the MySQL database. Maybe you want to double check.
I have direct access to my own MySQL database, so I can go to the command line or use GUI tools.
