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.
sudo mysql -u root
[mysql] update user set plugin='mysql_native_password' where user='root';
[mysql] flush privileges;
You can read the detailed documentation at https://dev.mysql.com/doc/refman/5.7/en/native-authentication-plugin.html
Happy development 🙂