Jump to content
Larry Ullman's Book Forums

Changing Mysql Root Password


Recommended Posts

Hi

 

I have tried to change the root password of MySQL after a fresh installation but have not been successful. 

 

I probably am missing something, but I have been following the installation instructions as given in the appendix. I also looked at Chapter 4 as well but I am not having any luck.

 

I get the following output:

 

MariaDB [(none)]> set password for 'root'@' localhost' = password('test123');
ERROR 1131 (42000): You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings
MariaDB [(none)]>

I don't understand how I have become anonymous user and how do I change that.

 

 

Link to comment
Share on other sites

 Share

×
×
  • Create New...