我是小站长 發表於 2019-6-1 18:30:17

MySQL 忘记密码后的重置操作

<font face="Tahoma, &amp;quot">一、修改配置文件方式</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1、关闭 MySQL </font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; linux：</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1）service mysqld stop</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;2）/usr/local/mysql/support-files/mysql.server stop</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Windows:</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1) 命令提示符下执行 net stop mysql</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;2)计算机右键管理 -&gt; 服务 ，找到mysql服务，停止此服务</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;2、修改配置文件</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; linux下配置文件为my.cnf ，windows下配置文件为my.ini，在下添加</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; skip-grant</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;3、重启MySQL</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; linux：</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1）service mysqld start</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;2）/usr/local/mysql/support-files/mysql.server start</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Windows:</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1) 命令提示符下执行 net start mysql</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;2)计算机右键管理 -&gt; 服务 ，找到mysql服务，启动此服务</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;4、进入MySQL</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Linux:</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;/usr/local/mysql/bin/mysql -u root -p&nbsp;&nbsp;进入mysql</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; windows：</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;D:/mysql/mysql -u root -p&nbsp;&nbsp;进入mysql，其中，D:/mysql为mysql的安装目录</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; </font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;5、更改密码</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 执行下面语句</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; use mysql;</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; UPDATE user SET Password=password(&quot;XXX&quot;) WHERE User=&quot;root&quot;;&nbsp; &nbsp;&nbsp; &nbsp;其中，XXX是你要设置的密码</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; flush privileges;</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; exit;</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;6、去掉配置文件中的 skip-grant</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;7、重启 MySQL</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;</font><br /><font face="Tahoma, &amp;quot">二、命令方式（针对linux）</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1、关闭 MySQL</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1）service mysqld stop</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 2）/usr/local/mysql/support-files/mysql.server stop</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;2、执行下面命令</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; /usr/local/mysql/bin/mysqld_safe --skip-grant</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;3、进入 MySQL </font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; /usr/local/mysql/bin/mysql -u root -p&nbsp;&nbsp;进入mysql</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;4、更改密码</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 执行下面语句</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; use mysql;</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; UPDATE user SET Password=password(&quot;XXX&quot;) WHERE User=&quot;root&quot;;&nbsp; &nbsp;&nbsp; &nbsp;其中，XXX是你要设置的密码</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; flush privileges;</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; exit;</font><br /><font face="Tahoma, &amp;quot">&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;5、重启 MySQL</font><br />Tahoma<em>, </em>quot<em>, </em>mysql<em>, </em>MySQL
頁: [1]
查看完整版本: MySQL 忘记密码后的重置操作