1,105,332 Community Members

xampp, phpMyAdmin deleted all users

Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

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 -

Error
MySQL said:

#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'.

Any ideas?

Member Avatar
smantscheff
Nearly a Posting Virtuoso
1,289 posts since Oct 2010
Reputation Points: 265 [?]
Q&As Helped to Solve: 271 [?]
Skill Endorsements: 8 [?]
 
1
 

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.

Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

I did that, uninstalled xampp, made sure that mysql is completely deleted as well as the xampp folder. I then re-installed the entire app, apache, xampp and mysql using xampp. I still can't get in.

It seems that the mysql root folder stays intact. Any way to delete that?

Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

I have managed to solve this!!!!

For future readers, if you are running Skype, open the connections configurations and de-select the check box that wants to share port 80.

Also make sure that port 80 is added to your firewall or that your anti virus is allowing the listening on port 80.

Now I can work again.;)

Question Answered as of 3 Years Ago by smantscheff
Member Avatar
WebStudio
Newbie Poster
1 post since Aug 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

dude seriously, good work

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article