MySQL密碼正確卻無法本地登錄-1045 Access denied for user 'root'@'localhost' (using password:YES
MySQL密碼正確卻無法本地登錄
報(bào)錯(cuò)如下:
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
解決方法:
1、在啟動(dòng)mysql的參數(shù)中加入跳過密碼問題方式,如下:
vim /etc/my.cnf
并在[mysql]下面加上skip-grant-tables,
這個(gè)用于跳過密碼問題,但是這并不能徹底解決。
2、重啟mysql服務(wù)
本人用的是Linux系統(tǒng)的Mysql,語句如下:
查看端口號:
ps aux|grep mysqld
查看狀態(tài):
systemctl status mysqld
重啟mysql服務(wù)
systemctl restart mysqld
嘗試連接:
mysql -uroot -p123456
輸入密碼,剛才已經(jīng)設(shè)置跳過密碼了可忽略
操作步驟如下:
[root@localhost ~]# mysql -uroot -p123456
mysql> use mysql
Database changed
mysql> select user,host,password from user where user='root';
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | % | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | localhost.localdomain | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | 127.0.0.1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | ::1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
+------+-----------------------+-------------------------------------------+
4 rows in set (0.02 sec)
mysql> update user set host='localhost' where user='root' and host='%';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
mysql> quit
Bye
OK,退出mysql,重啟mysql就解決問題了
前后對比一下:
[root@localhost ~]# mysql -uroot -p
mysql> use mysql;
Database changed
mysql> select user,host,password from user where user='root';
+------+-----------------------+-------------------------------------------+
| user | host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | localhost.localdomain | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | 127.0.0.1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
| root | ::1 | *00A51F3F48415C7D4E8908980D443C29C69B60C9 |
+------+-----------------------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql>
OK!
總結(jié)
以上所述是小編給大家介紹的MySQL密碼正確卻無法本地登錄-1045 Access denied for user ''root''@''localhost'' (using password:YES,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對腳本之家網(wǎng)站的支持!
如果你覺得本文對你有幫助,歡迎轉(zhuǎn)載,煩請注明出處,謝謝!
您可能感興趣的文章:- php+MySQL實(shí)現(xiàn)登錄時(shí)驗(yàn)證登錄名和密碼是否正確
- MySQL密碼正確卻無法本地登錄的解決方法
- MySql8.0以上版本正確修改ROOT密碼的方法