今天连接mysql5.7的时候出现了如下的错误,连接不上:
[root@node113 ~/installs]#mysql -hlocalhost -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@node113 ~/installs]#mysql -hlocalhost -uroot -p
只有先配置mysql让mysql不对客户端进行密码校验,并修改密码,再登录就可以了,以下是步骤:
在/etc/my.cnf中的mysqld节点下加入
skip-grant-tables
重启mysql:
[root@node113 /etc]#service mysql restart Shutting down MySQL.. [ OK ] Starting MySQL. [ OK ]
登录mysql客户端,可以看到直接输入mysql就能进入客户端了:
[root@node113 /etc]#mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.17 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. mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed
5.修改user表中的密码:
mysql> update user set authentication_string=password('Abcde#789') where user='root'; Query OK, 2 rows affected, 1 warning (0.01 sec) Rows matched: 2 Changed: 2 Warnings: 1
在mysql5.7中user表的password字段改为了authentication_string,password('')是mysql的内置函数,用于对user表的密码进行加密。
6.刷新权限:
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
7.vi /etc/my.cnf在mysqld节点下去掉刚才加入的skip-grant-tables
8.service mysql resatrt
9.重新登录mysql客户端输入密码可以登入了: