Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've just installed php on my win 2008 server using the web platform manager and installed phpmyadmin. I've configured phpmyadmin using a username/password but I'm getting an #1045 error, so I assume I can't connect to the mysql-server

Do I need to use the same login data for phpmyadmin as for my mysql database? If yes - how do I find out which password is set on my system?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

I see this a lot when people move over to 2008 server from previous operating systems.

When you install these programs they are not aware of the new Windows 2008 Advanced Firewall and can't automatcally open ports for you.

It is very likely that this is your problem. Although you accessing it locally the PHPadmin is a a program trying to accessing the MySQL DB through its port. Last time I looked it was 3306. Go into Windows Firewall and allow port 3306 open for all connections and try again.

If this works please lets us know. NOTE: it may not be 3306 as I don't use MySQL much but find out what port it is and open it.

I got the port info from here http://www.ozzu.com/programming-forum/phpmyadmin-error-1045-access-denied-for-user-root-t64849.html so just look at php pages to find out what port it is connecting on.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.