MySQL中登录报错_mysql登录报错 ERROR 1045 (28000) 短命女 2023-01-12 11:36 104阅读 0赞 1、现象: \[root@localhost ~\]\# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 2、原因:数据库中存在空用户所致 3、解决方式: 1)停用mysql服务:\# service mysql stop 2)输入命令:\# mysqld\_safe --user=mysql --skip-grant-tables --skip-networking & 3)登入数据库:\# mysql -u root mysql 4)mysql> use mysql; 5)mysql> select user,host,password from user; 结果例如以下: \+------+-----------------------+----------+ | user | host | password | \+------+-----------------------+----------+ | root | % | mima | | root | localhost.localdomain | mima | | root | 127.0.0.1 | mima | | | localhost | | | | localhost.localdomain | | \+------+-----------------------+----------+ 6)将上面查询出来的空用户删除:mysql> delete from user where user=''; 7)退出数据库:mysql> quit 8)启动mysql服务:\# service mysql start 9)又一次用命令‘mysql -u root -p’登录。OK。 或者: 1)找到mysql的配置文件。改动my.cnf。在当中增加skip-grant-tables 2)重新启动数据库service mysql restart 3)免password使用root登录,然后查看user表、删除空用户 4)推出数据库。改动my.cnf。去掉skip-grant-tables 5)重新启动数据库
还没有评论,来说两句吧...