ubantu linux下安装新版mysql,登录时必须sudo mysql -u root -p,因为安装时root用户的密码是随机的,直接mysql -u root -p则无法登录,报错:
ERROR 1698 (28000): Access denied for user 'root'@'localhost
解决方案:
步骤一:登录mysql
sudo mysql -u root -p
步骤二:查看user表:
select user, plugin from mysql.user;
结果如下:
mysql> select user, plugin from mysql.user;
+-----------+-----------------------+
| user | plugin |
+-----------+-----------------------+
| root | auth_socket |
| mysql.sys | mysql_native_password |
| dev | mysql_native_password |
+-----------+-----------------------+
3 rows in set (0.01 sec)
发现root的plugin并不是本地密码,因此需要修改它,但由于MySQL5.6.6版本之后增加了