mysql Access denied for user ‘root’@’localhost’ (using password: YES)解決方法
今天在啟動mysql時出現(xiàn)以下問題:
[root@www ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
網(wǎng)上的答案是各種各樣的,最終解決問題的方法總結(jié)為以下,好多都是沒有設(shè)置初始密碼造成此問題的。
解決方法如下:
[root@www ~]# service mysqld stop #先關(guān)閉mysql服務(wù) Stopping mysqld: [ OK ] [root@www ~]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@www ~]# mysql -u root -p #關(guān)閉服務(wù)后又出現(xiàn)如下問題 Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@www ~]# mysql -u root mysql #鍵入此命令進(jìn)入mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, 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> update user set password=password('123') where user='root' and host='localhost'; ---->修改root的密碼 Query OK, 1 row affected (0.04 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush priviledge; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priviledge' at line 1 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> \q Bye [root@www ~]# mysql -u root -p ------>重新進(jìn)入 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, 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> \q Bye
到此就完了?。?/p>
- MySQL8.0登錄時出現(xiàn)Access?denied?for?user?‘root‘@‘localhost‘?(using?password:?YES)?拒絕訪問的完美解決
- 解決MySQL登錄報錯1045-Access?denied?for?user?'root'@' '(using?password:YES)
- 解決Mysql:ERROR?1045?(28000):Access?denied?for?user?‘root‘@‘localhost‘?(using?password:?NO)的方法
- 解決mysql:ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: NO/YES)
- 解決mysql登錄錯誤:''Access denied for user ''root''@''localhost''
- ubuntu18.0.4安裝mysql并解決ERROR 1698 (28000): Access denied for user ''''root''''@''''localhost''''
- win10下MySQL 8.0登錄Access denied for user‘root’@‘localhost’ (using password: YES)問題的解決方法
- 解決mysql ERROR 1045 (28000)-- Access denied for user問題
- 解決mysql創(chuàng)建數(shù)據(jù)庫后出現(xiàn):Access denied for user ''root''@''%'' to database ''xxx''的問題
- MySQL登錄時出現(xiàn) Access denied for user ‘root‘@‘xxx.xxx.xxx.xxx‘ (using password: YES) 的原因及解決辦法
相關(guān)文章
MySQL中的SHOW FULL PROCESSLIST命令實(shí)現(xiàn)
SHOW FULL PROCESSLIST命令是MySQL中一個非常有用的工具,可以幫助我們理解和監(jiān)控MySQL服務(wù)器的狀態(tài),本文主要介紹了MySQL中的SHOW FULL PROCESSLIST命令,感興趣的可以了解一下2023-11-11FROM_UNIXTIME 格式化MYSQL時間戳函數(shù)
對MYSQL沒有進(jìn)行過深入的研究,基礎(chǔ)知識匱乏,一遇到問題只能手冊,看來要把MYSQL的學(xué)習(xí)安排進(jìn)時間表了。2011-04-04win2008 R2 WEB環(huán)境配置之MYSQL 5.6.22安裝版安裝配置方法
這篇文章主要介紹了win2008 R2 WEB環(huán)境配置之MYSQL 5.6.22安裝版安裝配置方法,需要的朋友可以參考下2016-06-06mysql制作外鍵出現(xiàn)duplicate?key?name錯誤問題及解決
這篇文章主要介紹了mysql制作外鍵出現(xiàn)duplicate?key?name錯誤問題及解決方案,具有很好的參考價值,希望對大家有所幫助。如有錯誤或未考慮完全的地方,望不吝賜教2023-02-02Mysql?5.7?新特性之?json?類型的增刪改查操作和用法
這篇文章主要介紹了Mysql?5.7?新特性之json?類型的增刪改查,主要通過代碼介紹mysql?json類型的增刪改查等基本操作的用法,需要的朋友可以參考下2022-09-09MySql中now()與sysdate()區(qū)別小結(jié)
本文主要介紹了MySql中now()與sysdate()區(qū)別小結(jié),文中通過示例代碼介紹的非常詳細(xì),對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2023-05-05