.jpg)
這篇文章主要介紹了centos下 修改mysql密碼的方法,需要的朋友可以參考下
1．修改MySQL的登錄設(shè)置：
#?vim?/etc/my.cnf
加上一句：skip-grant-tables
如：
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock
2．重啟mysql
#?service?mysqld?restart Stopping?MySQL:?[?OK?] Starting?MySQL:?[?OK?]
3．修改密碼
mysql>?USE?mysql?; database?changed mysql>?UPDATE?user?SET?Password?=?password?(?'新密碼'?)?WHERE?User?=?'root'?; Query?OK,?0?rows?affected?(0.00?sec) Rows?matched:?2?Changed:?0?Warnings:?0 mysql>?flush?privileges?; Query?OK,?0?rows?affected?(0.01?sec) mysql>?quit
4．修改剛剛改過(guò)的mysql
#?vim?/etc/my.cnf
5.重啟mysql
#?service?mysqld?restart Stopping?MySQL:?[?OK?] Starting?MySQL:?[?OK?]
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
