系统 ubuntu
软件 mysql-workbench
出现错误 Access denied for user @ localhost
解决步骤:
方法:设置root用户的plugin为my_native_password
$ sudo mysql -u root -p # I had to use "sudo" since is new installation
mysql: USE mysql;
SELECT User, Host, plugin FROM mysql.user;
mysql:~ UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql:~ FLUSH PRIVILEGES;
mysql:~ exit;
$ service mysql restart