Jump to content
Larry Ullman's Book Forums

Changing Mysql Root Password

Recommended Posts



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


  • Create New...