238，安装mysql出现Access denied for user 'root'@'localhost' (using password: YES)的问题

问题：Access denied for user 'root'@'localhost' (using password: YES)，使用root连接，权限不够，修改好后，还报了root密码过期。

解决方案：

1，先等了mysql 的服务

2，打开终端

LJS:~ JS$ sudo su

Password:

sh-3.2#>/usr/local/mysql-5.7.10-osx10.9-x86_64/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

sh-3.2#>/usr/local/mysql-5.7.10-osx10.9-x86_64/bin/mysql -u root mysql

mysql> select Host,User,authentication_string,password_expired from user;

+------------+--------------+--------------------------------------------------------------------------------+------------------------+

| Host        | User          | authentication_string                                                             | password_expired |

+------------+--------------+-------------------------------------------+--------------------------------------------------------------+

| localhost | root          | *6691484EA6B50DDDE1926A220DA01FA9E575C18A        | Y                            |

| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | N                           |

+------------+--------------+--------------------------------------------------------------------------------+-------------------------+

接下来就修改用户密码和将权限给root，并设置密码是否需要过期操作

mysql>update mysql.user set authentication_string = PASSWORD('12345678') where user = 'root';

mysql>update mysql.user set password_expired = 'N'  where user = 'root';

mysql> flush privileges;

mysql> select Host,User,authentication_string,password_expired from user;

+------------+--------------+--------------------------------------------------------------------------------+------------------------+

| Host        | User          | authentication_string                                                             | password_expired |

+------------+--------------+-------------------------------------------+--------------------------------------------------------------+

| localhost | root          |*84AAC12F54AB666ECFC2A83C676908C8BBC381B1        | N                            |

| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE  | N                           |

+------------+--------------+--------------------------------------------------------------------------------+-------------------------+

mysql> quit

最后，重启一下电脑，就可以连接成功了！