Home  >  Article  >  Database  >  修改mysql密码与忘记mysql密码的处理方法

修改mysql密码与忘记mysql密码的处理方法

WBOY
WBOYOriginal
2016-06-07 17:55:331501browse

修改mysql密码与忘记mysql密码的处理方法,有需要的朋友可以参考下

修改MySQL密码:
代码如下:
mysqladmin -u root -p password 123456
mysqladmin -u用户名 -p旧密码 password 新密码

忘记MySQL密码:
代码如下:
chown -R mysql:mysql /var/lib/mysql
/etc/init.d/mysql stop 或 kill -9 杀死进程。
[root@corshetlpro01 bin]# cd /usr/local/mysql/bin
./mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[root@corshetlpro01 bin]# ps -ef | grep mysql
root 26544 25356 0 15:08 pts/18 00:00:00 /bin/sh ./mysqld_safe --user=mysql --skip-grant-tables --skip-networking
mysql 26673 26544 0 15:08 pts/18 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --skip-grant-tables --skip-networking --log-error=/var/lib/mysql/corshetlpro01.err --pid-file=/var/lib/mysql/corshetlpro01.pid --socket=/tmp/mysql.sock --port=3306
root 27223 25356 0 15:08 pts/18 00:00:00 grep mysql
./mysql -u root
mysql> use mysql;
mysql> update user set password=password('newpassword') where user='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
enter password:

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn