linux忘记mysql密码处理方法
- WBOYOriginal
- 2016-06-07 18:03:51893browse
linux忘记mysql密码处理方法，需要的朋友可以参考下。
linux忘记mysql密码处理方法:# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root 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:
mysql>
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
Previous article：SQL的小常识, 备忘之用, 慢慢补充.Next article：SQL截取字符串函数分享