Jamie Le Souef

I also had this problem with Plesk servers. Upgrading the default MySQL4 instal to version 5 always gave me issues with the Privilege Tables and i could never get the command, mysql_fix_privilege_tables, to run - it would never accept my password.

I little bit of searching and i came across a page entitles ‘Upgrade to PHP5 and MySQL 4.1x on (dv) 2.0 Dedicated Virtual Servers‘ and it worked like a charm for me!

Here is the bit i needed

/usr/bin/mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`

All done

Related Posts

• September 15, 2008 -- Tip : Backing up a large MySQL Database (errno: 24)
• January 16, 2008 -- Installing Ubuntu Server LAMP, SSH, FTP, Webmin and phpMyAdmin for a newbie
• September 20, 2008 -- about
• September 15, 2008 -- Speed up your site with some htaccess mojo
• August 4, 2008 -- A Look at Some Essential Security Considerations

This entry was posted on Tuesday, July 22nd, 2008 at 10:57 am and is filed under Linux, Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply