Add new comment

If you've forgotten your root password, you'll need Linux Root login to reset your MySQL root password. Here is the steps for resetting forgotten MySQL root password.

// First login to your Linux box as a root user, and stop mysqld daemon.
# service mysqld stop
// Now, start the mysqld daemon without the grant table bypassing 
// authentication
# mysqld_safe --skip-grant-tables &
// The mysqld daemon should have started. Now login as a root user
// without the password.
# mysql -u root
mysql> use mysql
// Reset the root user password.
mysql> update user set Password=PASSWORD('new-password') 
where user='root';
mysql> flush privileges;
mysql> exit;
// Restart the mysqld daemon, so that the new password will take 
// into effect.
# service mysqld restart
By admin

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.