Authentication issue with MySql 5.7 using root as a non-admin user in Linux

Recently I got with an issue after installing MySQL v5.7 on Ubuntu, whereas a sudo user I was able to login to MySQL but as a normal user, I was not.

I look around for help and found a very nice fix which I would like to share with all. Use the following commands to get through with MySQL authentication as non-admin user.

 

You can read the detailed documentation at https://dev.mysql.com/doc/refman/5.7/en/native-authentication-plugin.html

That’s it!!!

Happy development 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *