Can't set permissions on MySQL user -
I am trying to set the permissions for a MySQL user using the following command.
Allow all Joomla * To user @ localhost;
I have tried so many editions, but they all return: Error 1044 (42000): Users '' @ 'localhost' access denied for database 'Joomla 2'. >
It seems that the user name "user" is not being passed? I have tried several versions of the above command, I have to be aware of a few more things.
PS: My name is not really "user", just a person mentions that it is a reserved word or something similar.
Try taking a look into the privilege tables for example:
< Code> & gt; Use mysql; & Gt; * Select * with DB
This can signal to you what is going wrong.
You are connecting users @ '127.0.0.1' and H 127.0.0.1 flag (if you are using mysql CMD line client) instead of Unicode socket.
Did you try to specify a password using 'password' by the 'identity' of the GRANT statement?
Comments
Post a Comment