phpmyadmin won't accept my own password

[stevieontario]

Hello everyone,

 

I created a username and password for phpMyAdmin, and now my own phpMyAdmin won't accept my own password!

 

Here's the error I get:

#1045 - Access denied for user 'SteveAplin'@'localhost' (using password: YES)

 

Following someone else's advice, I deleted the files "user.frm", "user.MYD", and "user.MYI" from the folder xampp/mysql/data/mysql then put new ones back in.

 

Any advice would be greatly appreciated! Thanks,

[arbitter]

I think you HAVE to log in via username 'root', or at least that is how I have to login...

[ignace]

Following someone else's advice, I deleted the files "user.frm", "user.MYD", and "user.MYI" from the folder xampp/mysql/data/mysql then put new ones back in.

 

I think you HAVE to log in via username 'root', or at least that is how I have to login...

 

Yep as your username no longer exists

[stevieontario]

Arbitter, many thanks -- that worked. I should have indicated I am a wet-behind-the-ears novice when it comes to this.

 

This is all a result of my old computer crashing and me having to rebuild the application from memory and old files.

 

One further question: is there any way I could have discovered this on my own, by going through the files in the xampp/phpmyadmin folder?

[arbitter]

I had exactly the same problem when I installed xampp here, so that's why it occured to me

 

I really have no idea about how you could find it like that, if you can..

 

When I installed xampp, i followed a tutorial on youtube so I knew what to do, otherwise I wouldn't even have been able to make an account!