Mac安装的Mysql5.7.10
执行mysql -u root -p
就要求输入密码,但是新安装是没密码的.然后就会报错。
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
百度Google很久才把问题解决,下面是解决方法:
1、关闭MySQL服务;
执行sudo /usr/local/mysql/support-files/mysql.server stop
或者在系统偏好设置中关闭MySQL服务。
2.进入安全模式cd /usr/local/mysql/bin/
sudo su
./mysqld_safe --skip-grant-tables &
3.新建一个终端,输入mysql -u root -p
4.修改root用户密码UPDATE mysql.user SET authentication_string=PASSWORD('123456') where User='root';
5.刷新权限,使配置生效flush privileges;
6.重启Mysql服务
7.重新登录后,操作会报错
ERROR 1820 (HY000) :You must reset your password using AlTER USER statement before executing this statement.
则需要重新设置密码。SET PASSWORD = PASSWORD('123456');
参考:
http://www.euryugasaki.com/archives/853
http://www.jb51.net/article/39187.htm
http://fgyong.cn/?p=81
http://blog.sina.com.cn/s/blog_63edc09f0101pnf3.html