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

Category: Virtual Dedicated Linux

Author: Jane83

Date: 2008/2/27

Keywords: MySQL Password Dedicated Linux Server

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

Hosting Article V1

URL: http://www.powerhoster.com/domainhosting/modules/article/view.article.php/c8/1274