Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Byron Anderson
7,009 Pointsaccess denied !! (yikes)
after I created a new password, stored that password, and refreshed phpMyAdmin (after noticing no change had been made indicating if a password had been set) I was denied access.
#1045 - Access denied for user 'root'@'localhost' (using password: NO)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.`
where can i go to check this stuff?
Jeff Busch
19,287 PointsWhat's your operating system?
Byron Anderson
7,009 PointsWindows 8.1
2 Answers
Jeff Busch
19,287 PointsHi Byron,
I haven't been in Win8 with XAMPP for quite awhile. I've converted to Debian Linux. I think the least painful remedy will be uninstalling XAMPP and then re-installing. As I recall I had no problems with XAMPP. I even found it quite simple to set up multiple virtual hosts. If I recall, when I installed XAMPP I didn't set any password. Since this setup is only for development I wouldn't be too worried about passwords.
Jeff
Byron Anderson
7,009 Pointsi wondered if uninstalling and reinstalling would be the route..
I also wondered if avoiding passwords altogether would be painless considering mine are development needs only.
Thank you again Dr. Frank ;)
I'll let You know how things go!
Byron Anderson
7,009 PointsThat worked.. simply uninstall everything and reinstall. Tedious as all get-up, but I can now get back on track.
"Tedious", like the goings-on of our hero in the movie "Edge Of Tomorrow", which I watched while I was re-doing all this stuff. Appropriate now that I think about it. (Cool movie too. Someone's got to add it to the treehouse-movie-db schema.. or what's-it-called -- it seems I've got alot of learning to do here)
OKAY everyone, back to normal. As You Were! I'm good here. Thank you.
Cheers,
Byron
Byron Anderson
7,009 PointsByron Anderson
7,009 Pointsoh man, I'm developing an ULCER.. i don't even know how to describe what I did to hope to find where I went wrong! ugh... let me see:
from the <strong>Database Foundations</strong> course, I installed the MySQL stand alone deal, created a password and "stored it in the 'vault'" (whatever "vault" means, if I could find it, I could see what change I made).
I skipped ahead to Randy's course, <strong>Using PHP with MySQL</strong> and got the phpMyAdmin panel through XAMPP and went to create a password as he described. But I didn't realize this would CONFLICT with what I did the other day, and now I can't figure what, or where to go.
Neither of the 2 passwords I created work for the MySQL standalone (which I had no issue gaining access before messing about in phpMyAdmin). Under the Config button of MySQL in the XAMPP Control Panel there's a file called <strong>my.ini</strong> where I opened and added the "newer" password in that file and saved it... but nothing. (if I made it even worse doing THAT, i'll just.. i'll just... i don't know what!)
Good Lord, I'm buggin out now (if u can tell) because that's all Folks! until I can clear this up, I'm "Off Track" ("Track".. get it?)
Please, let there be understanding & therefor advice. Thank You everyone!