Membership Membership:
Latest New User Latest: vpros
Past 24 Hours Past 24 Hours: 0
Prev. 24 Hours Prev. 24 Hours: 0
User Count Overall: 137

People Online People Online:
Visitors Visitors: 6
Members Members: 0
Total Total: 6

NakedMCSE Computer Tech Support Forums

So you have passed all of the exams and you are now out in the real world of windows servers, linux servers and freebsd servers faced with a tech support problem you have never seen before...

Find free online tech support in the forums below, respecting that advice is free, but work beyond advice is not...

The General forum is provided for off topic discussion.

You need a user account to post - please Register or Login.

Online Tech Support Forums
  Forum  Open Source Tec...  MySQL Server  How to reset the root password in MySQL
Previous Previous
Next Next
New Post 8/25/2010 2:17 PM
119 posts
10th Level Poster

How to reset the root password in MySQL 

Login and stop the mysql process. This will vary from linux to linux, but will either be:

/etc/init.d/mysql stop or service mysql stop

Now we need to restart the mysql process, telling it to skip using the password table:

mysqld_safe --skip-grant-tables

Now connect with the client:

mysql -u root

And then change the password for root:

use mysql;
update user set Password=PASSWORD('your-new-password') where user='root';
flush privileges;

Then exit the client, stop the running mysqld process and restart as normal.


Previous Previous
Next Next
  Forum  Open Source Tec...  MySQL Server  How to reset the root password in MySQL
Send me One Million FREE Guaranteed Visitors