mysql登录报错ERROR 1045 (28000的解决方法
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql登录报错ERROR 1045 (28000的解决方法,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含10195字,纯文字阅读大概需要15分钟。
内容图文
![mysql登录报错ERROR 1045 (28000的解决方法](/upload/InfoBanner/zyjiaocheng/455/623e6c18351744e58e45f78e82b2eb91.jpg)
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for root@localhost;
+----------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘localhost‘ IDENTIFIED BY PASSWORD ‘*7CF1EF598B5B0FC97DAD7C8051A25DC0CE8A9AD9‘ |
| GRANT PROXY ON ‘‘@‘‘ TO ‘root‘@‘localhost‘ WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> flush PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
注意:赋权中的 PASSWORD ‘*7CF1EF598B5B0FC97DAD7C8051A25DC0CE8A9AD9‘ ; 是 root的密码加密后的字符串。 可以在 mysql库中的 user 表中查到。
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
mysql> select * from user;
问题分析:
通过 mysql -u root -p -h 127.0.0.1 可以登录,但是 mysql -u root -p 就报错。
查看information_schema 库的 USER_PRIVILEGES; 表,发现‘root‘@‘localhost‘ 没有权限。 执行
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘localhost‘ IDENTIFIED BY PASSWORD ‘*7CF1EF598B5B0FC97DAD7C8051A25DC0CE8A9AD9‘ ; 赋权后,
mysql> select * from USER_PRIVILEGES ;
+--------------------------------+---------------+-------------------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+--------------------------------+---------------+-------------------------+--------------+
| ‘root‘@‘localhost.localdomain‘ | def | SELECT | YES |
| ‘root‘@‘localhost.localdomain‘ | def | INSERT | YES |
| ‘root‘@‘localhost.localdomain‘ | def | UPDATE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | DELETE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | CREATE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | DROP | YES |
| ‘root‘@‘localhost.localdomain‘ | def | RELOAD | YES |
| ‘root‘@‘localhost.localdomain‘ | def | SHUTDOWN | YES |
| ‘root‘@‘localhost.localdomain‘ | def | PROCESS | YES |
| ‘root‘@‘localhost.localdomain‘ | def | FILE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | REFERENCES | YES |
| ‘root‘@‘localhost.localdomain‘ | def | INDEX | YES |
| ‘root‘@‘localhost.localdomain‘ | def | ALTER | YES |
| ‘root‘@‘localhost.localdomain‘ | def | SHOW DATABASES | YES |
| ‘root‘@‘localhost.localdomain‘ | def | SUPER | YES |
| ‘root‘@‘localhost.localdomain‘ | def | CREATE TEMPORARY TABLES | YES |
| ‘root‘@‘localhost.localdomain‘ | def | LOCK TABLES | YES |
| ‘root‘@‘localhost.localdomain‘ | def | EXECUTE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | REPLICATION SLAVE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | REPLICATION CLIENT | YES |
| ‘root‘@‘localhost.localdomain‘ | def | CREATE VIEW | YES |
| ‘root‘@‘localhost.localdomain‘ | def | SHOW VIEW | YES |
| ‘root‘@‘localhost.localdomain‘ | def | CREATE ROUTINE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | ALTER ROUTINE | YES |
| ‘root‘@‘localhost.localdomain‘ | def | CREATE USER | YES |
| ‘root‘@‘localhost.localdomain‘ | def | EVENT | YES |
| ‘root‘@‘localhost.localdomain‘ | def | TRIGGER | YES |
| ‘root‘@‘localhost.localdomain‘ | def | CREATE TABLESPACE | YES |
| ‘root‘@‘127.0.0.1‘ | def | SELECT | YES |
| ‘root‘@‘127.0.0.1‘ | def | INSERT | YES |
| ‘root‘@‘127.0.0.1‘ | def | UPDATE | YES |
| ‘root‘@‘127.0.0.1‘ | def | DELETE | YES |
| ‘root‘@‘127.0.0.1‘ | def | CREATE | YES |
| ‘root‘@‘127.0.0.1‘ | def | DROP | YES |
| ‘root‘@‘127.0.0.1‘ | def | RELOAD | YES |
| ‘root‘@‘127.0.0.1‘ | def | SHUTDOWN | YES |
| ‘root‘@‘127.0.0.1‘ | def | PROCESS | YES |
| ‘root‘@‘127.0.0.1‘ | def | FILE | YES |
| ‘root‘@‘127.0.0.1‘ | def | REFERENCES | YES |
| ‘root‘@‘127.0.0.1‘ | def | INDEX | YES |
| ‘root‘@‘127.0.0.1‘ | def | ALTER | YES |
| ‘root‘@‘127.0.0.1‘ | def | SHOW DATABASES | YES |
| ‘root‘@‘127.0.0.1‘ | def | SUPER | YES |
| ‘root‘@‘127.0.0.1‘ | def | CREATE TEMPORARY TABLES | YES |
| ‘root‘@‘127.0.0.1‘ | def | LOCK TABLES | YES |
| ‘root‘@‘127.0.0.1‘ | def | EXECUTE | YES |
| ‘root‘@‘127.0.0.1‘ | def | REPLICATION SLAVE | YES |
| ‘root‘@‘127.0.0.1‘ | def | REPLICATION CLIENT | YES |
| ‘root‘@‘127.0.0.1‘ | def | CREATE VIEW | YES |
| ‘root‘@‘127.0.0.1‘ | def | SHOW VIEW | YES |
| ‘root‘@‘127.0.0.1‘ | def | CREATE ROUTINE | YES |
| ‘root‘@‘127.0.0.1‘ | def | ALTER ROUTINE | YES |
| ‘root‘@‘127.0.0.1‘ | def | CREATE USER | YES |
| ‘root‘@‘127.0.0.1‘ | def | EVENT | YES |
| ‘root‘@‘127.0.0.1‘ | def | TRIGGER | YES |
| ‘root‘@‘127.0.0.1‘ | def | CREATE TABLESPACE | YES |
| ‘root‘@‘::1‘ | def | SELECT | YES |
| ‘root‘@‘::1‘ | def | INSERT | YES |
| ‘root‘@‘::1‘ | def | UPDATE | YES |
| ‘root‘@‘::1‘ | def | DELETE | YES |
| ‘root‘@‘::1‘ | def | CREATE | YES |
| ‘root‘@‘::1‘ | def | DROP | YES |
| ‘root‘@‘::1‘ | def | RELOAD | YES |
| ‘root‘@‘::1‘ | def | SHUTDOWN | YES |
| ‘root‘@‘::1‘ | def | PROCESS | YES |
| ‘root‘@‘::1‘ | def | FILE | YES |
| ‘root‘@‘::1‘ | def | REFERENCES | YES |
| ‘root‘@‘::1‘ | def | INDEX | YES |
| ‘root‘@‘::1‘ | def | ALTER | YES |
| ‘root‘@‘::1‘ | def | SHOW DATABASES | YES |
| ‘root‘@‘::1‘ | def | SUPER | YES |
| ‘root‘@‘::1‘ | def | CREATE TEMPORARY TABLES | YES |
| ‘root‘@‘::1‘ | def | LOCK TABLES | YES |
| ‘root‘@‘::1‘ | def | EXECUTE | YES |
| ‘root‘@‘::1‘ | def | REPLICATION SLAVE | YES |
| ‘root‘@‘::1‘ | def | REPLICATION CLIENT | YES |
| ‘root‘@‘::1‘ | def | CREATE VIEW | YES |
| ‘root‘@‘::1‘ | def | SHOW VIEW | YES |
| ‘root‘@‘::1‘ | def | CREATE ROUTINE | YES |
| ‘root‘@‘::1‘ | def | ALTER ROUTINE | YES |
| ‘root‘@‘::1‘ | def | CREATE USER | YES |
| ‘root‘@‘::1‘ | def | EVENT | YES |
| ‘root‘@‘::1‘ | def | TRIGGER | YES |
| ‘root‘@‘::1‘ | def | CREATE TABLESPACE | YES |
本文出自 “zhoudingzhao” 博客,请务必保留此出处http://360519549.blog.51cto.com/3564149/1681637
mysql登录报错ERROR 1045 (28000的解决方法
标签:mysql error 1045 (28000) access denied for user 'root'@'localhost'
本文系统来源:http://360519549.blog.51cto.com/3564149/1681637
内容总结
以上是互联网集市为您收集整理的mysql登录报错ERROR 1045 (28000的解决方法全部内容,希望文章能够帮你解决mysql登录报错ERROR 1045 (28000的解决方法所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。