MySQL忘記root密碼後的處理
在用root使用者登入mysql時發現密碼錯了
[root@gk ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user (using password: NO)
解決方法
1.停止mysqld服務
[root@gk ~]# service mysqld stop
停止 mysqld: [確定]
2.執行mysqld_safe --skip-grant-tables
[root@gk ~]# mysqld_safe --skip-grant-tables
140607 22:21:50 mysqld_safe Logging to '/var/log/mysqld.log'.
140607 22:21:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
3.登入mysql
[root@gk ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.71 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.
4.切換到mysql資料庫
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
5.更新密碼
mysql> update user set password=password('redhat')where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 3 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
6.重新啟動mysqld服務
[root@gk ~]# service mysqld restart
停止 mysqld: [確定]
正在啟動 mysqld: [確定]
7.用新密碼進行登入
[root@gk ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.71 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>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12082464/viewspace-1191210/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL5.7忘記root密碼處理MySql密碼
- mysql忘記密碼後處理MySql密碼
- 【問題處理】MySQL忘記root密碼的處理辦法MySql密碼
- Solaris10忘記root密碼後處理方法密碼
- CentOS7忘記mysql的root密碼_處理方法.CentOSMySql密碼
- mysql 8.0忘記root使用者密碼處理MySql密碼
- mysql忘記root密碼MySql密碼
- [Mysql]mysql忘記ROOT密碼MySql密碼
- mysql 5.7忘記root密碼MySql密碼
- mysql root 密碼忘記windowsMySql密碼Windows
- solaris11忘記root密碼的處理方法密碼
- MYSQL修改密碼和忘記ROOT密碼MySql密碼
- mysql忘記root密碼恢復MySql密碼
- MySQL 5.7修改忘記root密碼MySql密碼
- MySQL 忘記root密碼的解決方法MySql密碼
- MySQL_忘記Root密碼並找回MySql密碼
- MySQL8.0 忘記 root 密碼下如何修改密碼MySql密碼
- Window7下忘記MySQL ROOT密碼MySql密碼
- MySQL 5.7遺忘root密碼重置記錄MySql密碼
- Mysql 5.7忘記root密碼怎麼辦MySql密碼
- MySQL 忘記root密碼解決辦法MySql密碼
- Linux系統root使用者密碼忘記如何處理Linux密碼
- windows下mysql忘記root密碼的解決方法WindowsMySql密碼
- linux下mysql的root密碼忘記解決LinuxMySql密碼
- linux忘記mysql root密碼的解決方法LinuxMySql密碼
- MySql5.5忘記root密碼怎麼辦MySql密碼
- Linux伺服器---mysql忘記root密碼Linux伺服器MySql密碼
- MySQL5.6忘記root密碼(win平臺)MySql密碼
- Linux忘記root密碼Linux密碼
- aix下忘記root密碼AI密碼
- mysql中的root密碼忘記的解決辦法MySql密碼
- mysql 4.1.7忘記資料庫密碼的處理辦法MySql資料庫密碼
- Windows 7忘記密碼的處理方法Windows密碼
- Mac下Mysql的root使用者密碼忘記了MacMySql密碼
- MySql5.5忘記root密碼的解決辦法MySql密碼
- 07 . Jenkins忘記root密碼Jenkins密碼
- MySQL密碼忘記後怎麼辦?MySql密碼
- win10 mysql8.0.12 忘記root密碼如何重置密碼Win10MySql密碼