Locked out of MYSQL and PLESK 7 due to an incorrect allowed host setting in MYSQL on 'admin'
Posted on 2004-11-26
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_prepend/auth.php3:2 psaerror(string "Unable to connect to database: saved admin password is incorrect.")
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.
#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!!!