mysql> update user set authentication_string=password('root') where user='root' and host='localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1
在mac os上安装mysql5.7.11
安装好以后,登录mysql
bash-3.2$ mysql -u root -p
出现如下错误信息:
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
这是因为root密码问题,修改root密码,如下:
bash-3.2$ mysqladmin -u root password root
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
出现上面错误;
切换到mac os管理员账号;
bash-3.2$ su root
Password:
执行如下mysql指令,取消对mysql账号的安全验证;
sh-3.2# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 9569
sh-3.2# 2016-03-14T13:40:49.6NZ mysqld_safe Logging to '/usr/local/mysql/data/liguohuideMacBook-Pro.local.err'.
2016-03-14T13:40:49.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
sh-3.2# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.7.11 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
执行修改root用户密码指令:
mysql> update user set authentication_string=password('root') where user='root' and host='localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1
刷新权限:
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
退出mysql数据库;
mysql> quit
Bye
关闭所有mysqld的进程;
bash-3.2$ killall -TERM mysqld
启动mysql安全模式;
bash-3.2$ mysqld_safe &
重启mysql数据库,用账户root登录mysql
bash-3.2$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 195
Server version: 5.7.11
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>