修改mysql的root密码方法

June 9th, 2011 by Dream☆Wing Leave a reply »

1. 停止mysqld

2. my.cnf的[mysqld]里加上skip-grant-tables

3. 启动mysqld

4. 以root无密码方式登录mysql

5. UPDATE `mysql`.`user` SET `Password`=PASSWORD(’newpassword’) WHERE `User`=’root’;

  • Share/Save/Bookmark

Posted in Linux, Mysql

You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

Advertisement
Post comment as
twitter logo facebook logo
Sort: Newest | Oldest