This is what my host says:
* Log in to phpmyadmin as "root"
* Select the "mysql" database from the drop-down list on the left
* Select the "User" table from the list on the left
* From the links along the top of the page, select
* For the username, enter your preferred username for wordpress (e.g. "wordpress")
* For the host entry, enter "localhost"
* For the password entry, enter your preferred password, *and* ensure
that the drop-down list immediately to the left of the password text field is set to "Password"
* Leave the remaining options as the default and confirm the addition.
* From the links at the top of the page, select "SQL"
* In the main text box now displayed, remove any data already in the box
and enter the command "flush privileges". Confirm this command by
clicking on the "Go" button.
The user should now be created. The next stage is to authorise access to
the "wordpress" database :-
* From the drop-down list on the left, select the "wordpress" database.
* From the links at the top of the page, select "SQL".
* Again, remove any text in the main SQL text box, and replace it with
the command "GRANT ALL PRIVILEGES ON
wordpress@localhost". *Please note* you should replace "wordpress" within "wordpress@localhost" with
the username you chose when creating the user. The
reference to "wordpress" in quotes (i.e. "
should be left unchanged.
Once this is completed, you should be able to access the SQL server with
the username and password you supplied, and you should have access to
make any changes to the "wordpress" database as that user, but you
should not be able to make changes to other SQL databases - you would
need to log in as root to gain full access again.
It still does not work, though.
Is the syntax correct here:
GRANT ALL PRIVILEGES ON /space / backquote / wordpress /
backquote / period / multiply / space / TO /
I have seen numerous google search results on this that
show: GRANT ALL PRIVILEGES ON *.* 'username'@'localhost'