EBHAUK
14th July 2007, 12:02 PM
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
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