hassan Posted April 2, 2018 Share Posted April 2, 2018 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 More sharing options...
hassan Posted April 2, 2018 Author Share Posted April 2, 2018 apologies, I was missing out -u root -p when connecting to the MySQL client Link to comment Share on other sites More sharing options...
Larry Posted April 2, 2018 Share Posted April 2, 2018 That happens! Kudos for figuring it out and thanks for sharing! Link to comment Share on other sites More sharing options...
Recommended Posts