linux下mysql的root密码忘记解决方

skip-grant-tables 

例如： 

<span style="color: #000000;">[mysqld] 
datadir</span>=/var/lib/<span style="color: #000000;">mysql 
socket</span>=/var/lib/mysql/<span style="color: #000000;">mysql.sock 
skip</span>-grant-tables 

保存并且退出vi。 

3．重新启动mysqld 

# /etc/init.d/<span style="color: #000000;">mysqld restart 
Stopping MySQL: [ OK ] 
Starting MySQL: [ OK ] </span>

4．登录并修改MySQL的root密码 

# /usr/bin/<span style="color: #000000;">mysql 
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is </span>3 to server version: 3.23.56<span style="color: #000000;"> 
Type </span>‘help;‘ or ‘\h‘ <span style="color: #0000ff;">for</span> help. Type ‘\c‘<span style="color: #000000;"> to clear the buffer. 
mysql</span>><span style="color: #000000;"> USE mysql ; 
Reading table information </span><span style="color: #0000ff;">for</span><span style="color: #000000;"> completion of table and column names 
You can turn off </span><span style="color: #0000ff;">this</span> feature to get a quicker startup with -<span style="color: #000000;">A 
Database changed 
mysql</span>> UPDATE user SET Password = password ( ‘new-password‘ ) WHERE User = ‘root‘<span style="color: #000000;"> ; 
Query OK, </span>0 rows affected (0.00<span style="color: #000000;"> sec) 
Rows matched: </span>2 Changed: 0 Warnings: 0<span style="color: #000000;"> 
mysql</span>><span style="color: #000000;"> flush privileges ; 
Query OK, </span>0 rows affected (0.01<span style="color: #000000;"> sec) 
mysql</span>><span style="color: #000000;"> quit 
Bye </span>

5．将MySQL的登录设置修改回来 

# vi /etc/my.cnf 

将刚才在[mysqld]的段中加上的skip-grant-tables删除 

保存并且退出vi。 
6．重新启动mysqld 

# /etc/init.d/<span style="color: #000000;">mysqld restart 
Stopping MySQL: [ OK ] 
Starting MySQL: [ OK ]
Work </span><span style="color: #0000ff;">for</span> fun,Live <span style="color: #0000ff;">for</span> love!

linux下mysql的root密码忘记解决方

标签：ati   moni   fun   war   star   mysqld   socket   root密码忘记   stop