赞
踩
今天重新安装了mysql5.7,设置了密码发现只有在root权限下才能登录mysql,普通状态登录报错mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1698 (28000): Access denied for user 'root'@'localhost'
如下方法可以解决这个问题
mysql>use mysql
mysql>select User,Host,plugin from user;
mysql>update user set plugin='mysql_native_password';
mysql>flush privileges;
~$ /etc/init.d/mysql restart
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。