I have been so stupid to hit go at the bottom after I added a new user, deleting all users including root. I have re-installed xampp twice, tried to change the password via the xampp security, still with no success. xAmpp loads perfect on http://localhost, phpMyAdmin though shows the following error -
#1130 - Host 'localhost' is not allowed to connect to this MySQL server
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I found a few similar posts, no one that helped me in getting to log in to MySql again.
I am running as administrator on win xp sp3, xampp shows all services running etc.
I have in the mean time tried to reset the password by using command prompt and editing the resetroot.batch file in the mysql folder. Still the problem persist.
Is there any way to delete the entire root for mysql and re-installing xampp? I don't mind what databases exist, they are all for testing anyway. I just need to get back as the super user 'root'.
You can delete all your mysql data by deleting the "data" directory in \xampp\mysql (at least that's the path in my installation). The access restrictions are stored in a database named mysql, so when you delete and re-install it you should be back on square 1.
This has nothing to do with any windows administrator privileges - mysql maintains its completely independent access restriction system.