Mysql root用户无法本地登录 mysqllocalhostAccess denied
程序员文章站
2022-06-19 23:34:55
...
用root用户登录mysql,发现客户端工具可以正常连接,但在本地控制台却无法登录。
提示如下错误:
在客户端查询mysql.user表发现:
SELECT USER,HOST,PASSWORD FROM USER WHERE USER='root';
发现,root用户只有“%”、“admin05”和“127.0.0.1”三条主机,并没有“localhost”的主机。手动添加后问题解决。
Database changed
mysql> SELECT USER,HOST,PASSWORD FROM USER WHERE USER='root';
+------+-----------+-------------------------------------------+
| USER | HOST | PASSWORD |
+------+-----------+-------------------------------------------+
| root | % | *49034D5239CD46EB55F11360A500C135B9BA40BC |
| root | admin05 | *49034D5239CD46EB55F11360A500C135B9BA40BC |
| root | 127.0.0.1 | *49034D5239CD46EB55F11360A500C135B9BA40BC |
| root | localhost | *49034D5239CD46EB55F11360A500C135B9BA40BC |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql>
提示如下错误:
[root@admin05 bakmysql]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
在客户端查询mysql.user表发现:
SELECT USER,HOST,PASSWORD FROM USER WHERE USER='root';
发现,root用户只有“%”、“admin05”和“127.0.0.1”三条主机,并没有“localhost”的主机。手动添加后问题解决。
Database changed
mysql> SELECT USER,HOST,PASSWORD FROM USER WHERE USER='root';
+------+-----------+-------------------------------------------+
| USER | HOST | PASSWORD |
+------+-----------+-------------------------------------------+
| root | % | *49034D5239CD46EB55F11360A500C135B9BA40BC |
| root | admin05 | *49034D5239CD46EB55F11360A500C135B9BA40BC |
| root | 127.0.0.1 | *49034D5239CD46EB55F11360A500C135B9BA40BC |
| root | localhost | *49034D5239CD46EB55F11360A500C135B9BA40BC |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql>
推荐阅读
-
MySQL密码正确却无法本地登录-1045 Access denied for user 'root'@'localhost' (using password:YES
-
MySQL无法登录问题-"ERROR 1045 (28000): Access denied for user 'root'@'localhost'"-之解决方法-密码重置
-
ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using password: YES) MYSQL 新建用户 无法登录 问题解决方法
-
Mysql root用户无法本地登录 mysqllocalhostAccess denied
-
mac mysql 无法登录root用户 急!! 求神人指点
-
MySQL密码正确却无法本地登录-1045 Access denied for user 'root'@'localhost' (using password:YES
-
MySQl使用-------如何修改root密码&&解决本地无法登录问题_MySQL
-
MySQl使用-------如何修改root密码&&解决本地无法登录问题_MySQL
-
ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using password: YES) MYSQL 新建用户 无法登录 问题解决方法
-
mysql新建用户本地无法登录_MySQL