360mysql账户密码忘记了怎么办_MySQL忘记密码怎么办

如果有一天你忘记了root的密码&＃xff0c;我们可以利用 --skip-grant-tables这个参数&＃xff0c;具体实施如下&＃xff1a;

[root&＃64;HE1 bin]# mysql -uroot -p

Enter password:

ERROR 1045 (28000):Access denied for user &＃39;root&＃39;&＃64;&＃39;localhost&＃39; (using password: YES)

[root&＃64;HE1 bin]# ps-ef|grep mysql

root      7572 2398  0 00:58 pts/1    00:00:00 /bin/sh ./mysqld_safe--defaults-file&＃61;/etc/my.cnf

mysql    8199 7572  0 00:58 pts/1    00:00:00 /usr/local/mysql/bin/mysqld--defaults-file&＃61;/etc/my.cnf --basedir&＃61;/usr/local/mysql --datadir&＃61;/data/mysql--plugin-dir&＃61;/usr/local/mysql/lib/plugin --user&＃61;mysql--log-error&＃61;/data/mysql/error.log --open-files-limit&＃61;3072--pid-file&＃61;/data/mysql/HE1.pid --socket&＃61;/data/mysql.sock --port&＃61;3306

root      8230 2398  0 00:59 pts/1    00:00:00 grep mysql

[root&＃64;HE1 bin]# kill -9 8199 7572

[root&＃64;HE1 bin]# ps-ef|grep mysql

root      8232 2398  0 00:59 pts/1    00:00:00 grep mysql

[1]&＃43;  Killed                  ./mysqld_safe--defaults-file&＃61;/etc/my.cnf

[root&＃64;HE1 bin]# ps-ef|grep mysql

root      8234 2398  0 00:59 pts/1    00:00:00 grep mysql

[root&＃64;HE1 bin]# ./mysqld_safe --defaults-file&＃61;/etc/my.cnf--skip-grant-tables &

[1] 8235

[root&＃64;HE1 bin]#160317 00:59:43 mysqld_safe Logging to &＃39;/data/mysql/error.log&＃39;.

160317 00:59:43mysqld_safe Starting mysqld daemon with databases from /data/mysql

[root&＃64;HE1 bin]# mysql -uroot

Welcome to the MySQLmonitor.  Commands end with ; or \g.

Your MySQLconnection id is 1

Server version:5.6.16-log MySQL Community Server (GPL)

Copyright (c) 2000,2014, Oracle and/or its affiliates. All rights reserved.

Oracle is aregistered trademark of Oracle Corporation and/or its

affiliates. Othernames may be trademarks of their respective

owners.

Type &＃39;help;&＃39; or &＃39;\h&＃39;for help. Type &＃39;\c&＃39; to clear the current input statement.

mysql> quit

Bye

[root&＃64;HE1 bin]#mysql

Welcome to the MySQLmonitor.  Commands end with ; or \g.

Your MySQLconnection id is 2

Server version:5.6.16-log MySQL Community Server (GPL)

Copyright (c) 2000,2014, Oracle and/or its affiliates. All rights reserved.

Oracle is aregistered trademark of Oracle Corporation and/or its

affiliates. Othernames may be trademarks of their respective

owners.

Type &＃39;help;&＃39; or &＃39;\h&＃39;for help. Type &＃39;\c&＃39; to clear the current input statement.

mysql> quit

Bye

本文中采用kill-9的方式&＃xff0c;这种方式不建议在生产库中使用&＃xff0c;生产库中应采用正常停库