Resetting MySQL Passwords on Linux Servers
Before resetting your MySQL password, you must access your server as the root user.
To Reset MySQL Passwords on Linux Servers
- To stop MySQL and restart in safe mode: At the command prompt, type the following commands and press Enter after each.
service mysqld stopkillall mysqldmysqld_safe --skip-grant-tables&
- 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 your Parallels Plesk Panel or cPanel administrative password.
- To stop safe mode and restart MySQL: At the command prompt, type the following commands and press Enter after each.
killall mysqldservice mysqld start