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?


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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