cant login as mysql user root from normal user account in ubuntu 18.04
  Admin   18 Agustus 2019   fix error

So in order to to change the plugin back to mysql_native_password:

  1. Login with sudo:

    sudo mysql -u root
    
  2. Change the plugin and set a password with a single command:

    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';
    

note test is your password

 

OR 

 

ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret")

Tags :

sql , mysql

Bagikan :