Dreaming in Code

mysql workbench `root`@`localhost` user getting denied access


$ mysql
mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ service mysql restart

lingchitao_admin

,

Leave a Reply

Your email address will not be published. Required fields are marked *