Locked out of MYSQL and PLESK 7 due to an incorrect allowed host setting in MYSQL on 'admin'
Here's the deal.... I have a default Plesk install at my host provider on *nix. I use Navicat 2004 to connect to my MYSQL DB. Since the deafult admin MYSQL login only allows a login from host 'localhost', I used phpMyadmin to set the allowed 'admin' login host to '*', this change has completly locked my out of EVERYTHING!!! Plesk, phpMYAdmin, Navicat.. EVERYTHING!!! Here are my errors:
Plesk login: Unable to connect to database: saved admin password is incorrect. 0: /usr/local/psa/admin/auto_
==========================
phpMyAdmin: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#1045 - Access denied for user: 'admin@localhost' (Using password: YES)
==========================
I am unable to reboot my server. I know the problem is with the allowed "host" setting. I know the problem lies in how I tried to set the host to allow from '*'. So what I need to do is fix that setting so I can connect again. I am still able to connect via SSH using puTTY. I have root access. I believe I need to edit a mySQL config file to ignore grant tables and restart the mySQL service. I do not know how to do this. I need help, without help I'm sure I'll pay several hundred dollars to pay the support team at my ISP. Please help!!!
Plesk login: Unable to connect to database: saved admin password is incorrect. 0: /usr/local/psa/admin/auto_
==========================
phpMyAdmin: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#1045 - Access denied for user: 'admin@localhost' (Using password: YES)
==========================
I am unable to reboot my server. I know the problem is with the allowed "host" setting. I know the problem lies in how I tried to set the host to allow from '*'. So what I need to do is fix that setting so I can connect again. I am still able to connect via SSH using puTTY. I have root access. I believe I need to edit a mySQL config file to ignore grant tables and restart the mySQL service. I do not know how to do this. I need help, without help I'm sure I'll pay several hundred dollars to pay the support team at my ISP. Please help!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay, I figured out how to edit the my.cnf (vi my.cnf) and how to restart MYSQL via SSH (/etc/init.d/mysqld restart). I was unable to modify the allowed host via the "priviledges" in phpmyadmin (it kept returning an "unknown command"), however, I was able to browse to the mysql database and modify the 'admin' user in the 'users' table. It appears everything is working again. Thanks for all your help.
ASKER