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, 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... 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 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? 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! 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
Archived
This topic is now archived and is closed to further replies.