Then run the select command again and you'll see it has changed : +-+-+-+-+ To allow connection with root and password, then update the values in the table with command : ALTER USER IDENTIFIED WITH mysql_native_password BY 'Current-Root-Password'
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | ssion | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost | | user | authentication_string | plugin | host | If you run sql : SELECT user,authentication_string,plugin,host FROM er If you have that same problem in MySql 5.7.+ : Access denied for user because MySql 5.7 by default allow to connect with socket, which means you just connect with sudo mysql.