Have you tried MySQLTuner yet? It's free and it makes optimizing your MySQL server easier than ever!

Okay, so you’ve verified that the correct admin password is being used, but you still can’t login? Most likely the account has been locked out. You can reset the account by running the following SQL statement:

echo “use psa; truncate lockout;” | mysql -u root -p`cat /etc/psa/.psa.shadow`

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • bodytext
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Reddit
  • Slashdot
  • StumbleUpon
  • Technorati
  • TwitThis
Leave a Reply

You must be logged in to post a comment. Login »