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

General Discussion

Posted by David Jarrin
David Jarrin
Courses Plus Student 11,182 Points

XAMPP MySQL access denied!

I am having a hell of a time setting up XAMPP on my new computer. Before I get started let me mention that I am using windows 8 and my IDE is webmatrix3.

So my first problem was that apache wouldn't start up because something (either skype or webmatrix) was already listening to port 80, so I changed it to port 88 and now that at least starts. My next problem is that mySQL wont start. When I try to go to phpMyAdmin() I get a message telling

"#1045 - Access denied for user 'root'@'localhost' (using password: NO) 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."

Does this have anything to do with me changing apache port? I guess I need to change my username information (I never touched it though!). Any advice is greatly appreciated!

2 Answers

Jorge Eduardo Garcia Celorio
Jorge Eduardo Garcia Celorio
10,112 Points
Jorge Eduardo Garcia Celorio
Jorge Eduardo Garcia Celorio
10,112 Points

What if... just what if... you disconnect from the internet and give it a try with port 80?

David Jarrin
David Jarrin
Courses Plus Student 11,182 Points

Might be nice to stay connected so I can search the Internet for solutions while I develop

Hugo Paz
Hugo Paz
15,622 Points
Hugo Paz
Hugo Paz
15,622 Points

Unfortunately without seeing your config file is hard to pinpoint the issue. Have a look at this thread http://www.sitepoint.com/forums/showthread.php?846777-1045-Access-denied-for-user-root-localhost-(using-password-NO)