Close Window x

Frequently Asked Questions

Help Center Search

How do I reset my MySQL Password on my Dedicated Linux Server?

Print this Article
Comment on this Article
Last Updated: November 10, 2008 1:20 PM

To Reset Your MySQL Password on a Dedicated Linux Server

  1. To stop MySQL and restart in safe mode: At the command prompt, type the following commands and press Enter after each.
    service mysqld stop
    killall mysqld
    mysqld_safe --skip-grant-tables&
  2. To reset the admin password and permissions: At the command prompt, type the following command and press Enter.
    mysql psa -e "flush privileges; grant all privileges on *.* to 'admin'@'localhost' identified by "password"

    NOTE: Replace "password" with you Plesk or cPanel administrative password.

  3. To stop safe mode and restart MySQL: At the command prompt, type the following commands and press Enter after each.
    killall mysqld
    service mysqld start