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

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -