One note is to secure MySQL, I don't know for sure but I believe you could login to MySQL remotely with no password during this operation (I'm not sure, maybe it doesn't accept blank passwords but I firewall MySQL port anyway and recommend you do the same).
[mysqld] field add the following line somewhere:
Now restart mysql:
service mysql restart or on Debian style systems:
You can now login to mysql as root with no password.
mysql -u root
Enter the following commands (you can copy and paste below, remember to change "YOURNEWPASSWORD" to whatever you want the password to be.
UPDATE user SET password=password("YOURNEWPASSWORD") WHERE user='root';
*Note more note is that if you are using Plesk, the root user is probably called/renamed "admin" so you'll need to replace everything above with "admin" if that's the case. Of course an easier way if Plesk is actually running is to use the Forgot Password function of the Control Panel itself.
mysql, reset, passwordone, login, remotely, password, doesn, passwords, firewall, edit, etc, cf, mysqld, restart, debian, init, commands, quot, yournewpassword, update, user, flush, privileges, plesk, renamed, admin, ll, panel,