1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Can't login to phpmyadmin after mysql upgrade

Discussion in 'Plesk for Linux - 8.x and Older' started by dennysp, Oct 4, 2005.

  1. dennysp

    dennysp Guest

    0
     
    Hi guys,
    I upgraded MySQL to 4.1.12 using yum and now when I create a new database in Plesk, and try to access it using a standalone install of phpMyAdmin, it won't allow me to login. If I use the Plesk phpMyadmin client, it works fine.
    Also, I can login using usernames/passwords for users that were created before the upgrade, but not for any new user. Plesk is otherwise working fine after the upgrade, but I need to allow some clients access to phpmyadmi outside of plesk. I've tried with both http and cookie based authentication (the latest returns: "#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client") Please advice? :)

    Thanks
    -d
     
  2. dennysp

    dennysp Guest

    0
     
    Anyone??
     
  3. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    963
    Likes Received:
    32
    Location:
    Romania
    Did you have run

    /usr/bin/mysql_fix_privilege_tables --user=admin --password='cat /etc/psa/.psa.shadow'
     
  4. dennysp

    dennysp Guest

    0
     
    Yes, I did, and that didn't fix it, however I've found the solution to the problem:

    It looks like the current php mysql extension doesn't support the new authentication protocol in mysql 4.1.1 or higher. The fix was very easy. Add old_password entry on /etc/my.cnf and restart mysql.

    Important note:
    You will get this error on every php mysql call unless you do the above fix, or change the password for the database user using the OLD_PASSWORD() sql command from a mysql prompt.


    If you are running php5, you can avoid this by using the php MYSQLI extension instead.

    All about this fix can be found here

    Hope this info is useful to someone else here.
     
Loading...