Reset Mysql Root Password

Following these steps should have your MySQL root password reset in no time! This guide is for the way Fiber Hosting, LLC servers are setup.

service mysqld stop
su - mysql
nano new

Now once nano has opened the text file insert the following:

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
Ctrl+x then hit "y" to save

Now we will need to start mysql with the text file.

exit (You need to go back to the root account)
mysqld_safe --init-file=/var/lib/mysql/new &

Once it has fully started up do the following

service mysqld stop
su - mysql
rm -rf new
exit
service mysqld start

Password should be reset!