Mon 30 Oct 2006
mysql_fix_privilege_tables doesn’t work on Plesk machines?
Posted by Jonathan Adjei under LAMP , PleskThe reason for this upgrade script failing for Plesk machines is due to Plesk changing the mysql ‘root’ account into ‘admin’.
To get the script to run successfully, you can simply open up the file /usr/bin/mysql_fix_privilege_tables and change the ‘user=”root” to user=”admin”.
Then start the script passing the parameter –password=xxx where xxx is your Plesk admin account’s password.
/usr/bin/mysql_fix_privilege_tables --password=xxx Super