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

Plesk/mysql/pass problem...

Discussion in 'Plesk for Linux - 8.x and Older' started by evilbob, May 29, 2005.

  1. evilbob

    evilbob Guest

    Hiya, seem to have a problem with plesk atm which is driving me bananas :).

    Plesk error when trying to login...
    "ERROR: Unable to connect to database: saved admin password is incorrect"

    If I try from ssh mysql -u admin -p I can't log in with any pass.

    If I start mysql with --skip-grant-tables I can obviously login, change passwords etc (and flush privileges), but none of it makes any difference. It seems its more an mysql problem, as after that I still can't login with mysql -u admin -p.

    So this is basically where I'm stuck, when I change the password in mysql with privileges off, afterwards it doesn't seem to make any difference I still can't login to mysql?

    Always says....ERROR 1045: Access denied for user 'admin'@'localhost' (using password: YES)

    Any help much appreciated.
  2. evilbob

    evilbob Guest

    Nm think I've sorted it...

    update mysql.user set Password=PASSWORD('*********') where User='admin';

    seems to work 2nd time around after starting a different mysqld (even though had the same content?)
  3. rstackhouse

    rstackhouse Guest

    Killed admin for psa

    I guess I didn't realize that a user is mysql was for all the databases..

    I changed, deleted or munged the admin user for mysql and I'm getting the

    Unable to connect to database: get_admin_password() failed: file_get_contents() failed:

    0: /usr/local/psa/admin/auto_prepend/auth.php3:437 psaerror(string "Unable to connect to database: get_admin_password() failed: file_get_contents() failed: ")

    How do I add that back?
    Is the "update command a mysql? how do i logon with out the admin account?

    Help! :confused:
  4. Traged1

    Traged1 Guest

    Try this from console or ssh: provided that your are using MySQL version 3.xx

    mysql -uadmin -p`cat /etc/psa/.psa.shadow`;
    use mysql;

    INSERT into user values ('localhost','admin',"Password(PLESK_PASSWORD)",'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

    flush privileges;