stevieontario Posted March 29, 2010 Share Posted March 29, 2010 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, Quote Link to comment https://forums.phpfreaks.com/topic/196882-phpmyadmin-wont-accept-my-own-password/ Share on other sites More sharing options...
arbitter Posted March 29, 2010 Share Posted March 29, 2010 I think you HAVE to log in via username 'root', or at least that is how I have to login... Quote Link to comment https://forums.phpfreaks.com/topic/196882-phpmyadmin-wont-accept-my-own-password/#findComment-1033772 Share on other sites More sharing options...
ignace Posted March 29, 2010 Share Posted March 29, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/196882-phpmyadmin-wont-accept-my-own-password/#findComment-1033777 Share on other sites More sharing options...
stevieontario Posted March 29, 2010 Author Share Posted March 29, 2010 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? Quote Link to comment https://forums.phpfreaks.com/topic/196882-phpmyadmin-wont-accept-my-own-password/#findComment-1033781 Share on other sites More sharing options...
arbitter Posted March 30, 2010 Share Posted March 30, 2010 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! Quote Link to comment https://forums.phpfreaks.com/topic/196882-phpmyadmin-wont-accept-my-own-password/#findComment-1034055 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.