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

MYSQL User Problem

Discussion in 'Plesk for Linux - 8.x and Older' started by EBHAUK, Jul 14, 2007.

  1. EBHAUK

    EBHAUK Guest

    0
     
    Just found a small problem following upgrade to 8.2 Linux.

    Could not access any MYSQL Databases at all, neither log in to MYSQL via SSH.

    Through trial + error, found admin user reset to plesk default admin user. Following successful login via SSH I did this to fix:

    mysql> GRANT ALL PRIVILEGES ON *.* TO 'your_admin_user'@'localhost' IDENTIFIED BY 'your_admin_password' WITH GRANT OPTION;

    All burst into life again!

    I am running MYSQL Server 5.0.22
     
Loading...