SQL
SELECT plugin from mysql.user where User='root';
+-----------------------+
| plugin |
+-----------------------+
| auth_socket |
+-----------------------+SQL
UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('yourpassword') WHERE User = 'root';SQL
FLUSH PRIVILEGES;
