After updating Ubuntu 16.04 with new updates, my java app could not connect to mysql anymore.
I tried to connect manually via terminal, and with Mysql Workbench, same result :
Access denied for user 'root'@'localhost' (using password: NO)
Usually I log in with user root and no password.
After some searching, I found that that's something to do with
sudo mysql -u root use mysql; [mysql] update user set plugin='' where User='root'; [mysql] flush privileges;
But I didn't check my
mysql version beforehand, which is 5.7.17.
I know, I tried to do quick and I did stupid.
I Should have done :
[mysql] update user set plugin='mysql_native_password' where User='root';
So now, I can't even launch any
mysql prompt to correct my error.
I can't find if user "mysql" can connect via prompt ...
I can't remember if I have set other users: how can I verify this ?
Any idea somebody, please ?