cant login as mysql user root from normal user account in ubuntu 18.04

So in order to to change the plugin back to mysql_native_password: Login with sudo: sudo mysql -u root 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") ...

View More
  Dibaca 196 kali