我是小站长 發表於 2019-6-5 13:08:03

MySQL 忘记密码后的重置操作

<br /><br />一、修改配置文件方式<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1、关闭 MySQL <br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; linux：<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1）service mysqld stop<br />&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<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Windows:<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1) 命令提示符下执行 net stop mysql<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;2)计算机右键管理 -&gt; 服务 ，找到mysql服务，停止此服务<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;2、修改配置文件<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; linux下配置文件为my.cnf ，windows下配置文件为my.ini，在下添加<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; skip-grant<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;3、重启MySQL<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; linux：<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1）service mysqld start<br />&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<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Windows:<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1) 命令提示符下执行 net start mysql<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;2)计算机右键管理 -&gt; 服务 ，找到mysql服务，启动此服务<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;4、进入MySQL<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; Linux:<br />&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<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; windows：<br />&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的安装目录<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; <br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;5、更改密码<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 执行下面语句<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; use mysql;<br />&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是你要设置的密码<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; flush privileges;<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; exit;<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;6、去掉配置文件中的 skip-grant<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;7、重启 MySQL<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;<br />二、命令方式（针对linux）<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;1、关闭 MySQL<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 1）service mysqld stop<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 2）/usr/local/mysql/support-files/mysql.server stop<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;2、执行下面命令<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; /usr/local/mysql/bin/mysqld_safe --skip-grant<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;3、进入 MySQL <br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; /usr/local/mysql/bin/mysql -u root -p&nbsp;&nbsp;进入mysql<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;4、更改密码<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 执行下面语句<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; use mysql;<br />&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是你要设置的密码<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; flush privileges;<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; exit;<br />&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;5、重启 MySQL<br />mysql<em>, </em>MySQL<em>, </em>usr<em>, </em>local<em>, </em>服务

耗子 發表於 2019-6-7 22:50:09

&nbsp;&nbsp;感谢分享！！！

xzaxza 發表於 2019-6-9 08:38:53

不错的教程&nbsp; &nbsp;，谢谢分享
頁: [1]
查看完整版本: MySQL 忘记密码后的重置操作