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'm new to xampp, and have it installed on a Windows 7 machine. Earlier, I was able to at least get the login page for phpMyAdmin, but it was not taking username of "root" and no password, so I changed the username and password in the config.inc.php file, but now I don't even get the login page.

This is the message I get: "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."

Also, I changed the config.inc.php.safe file to have the same settings, and took the comment off of the "bind-address="127.0.0.1" in the my.ini file.

I want to make sure that the way I have my virtual host in httpd-vhosts.conf is not the problem (I don't know enough about it to tell):

NameVirtualHost *
<VirtualHost *>
DocumentRoot "C:\xampp\htdocs"
ServerName localhost
</VirtualHost>
<VirtualHost *>
DocumentRoot "C:\xampp\htdocs"
ServerName mygrafica.com
<Directory "C:\xampp\htdocs\mygrafica.com">
Order allow,deny
Allow from all
</Directory>

Thanks in advance!!!

share|improve this question

1 Answer 1

You need not change bind-address, since all this lives on the same box.

What you DO need, however, is mysqld listening on port 3306 on localhost, and a user that phpmyadmin can use to log on.

The first can be checked with netstat -an, look for port 3306.

The second is a bit more involved and requires you to log on to mysql first:

mysql -u root -p root_password

This will require a GRANT for that user, something like:

mysql > GRANT ALL ON *.* TO 'phpmyadmin'@'127.0.0.1' IDENTIFIED BY 'some_password';

And configure phpmyadmin to use those credentials.

share|improve this answer
    
To expedite time, so that I can answer you right away, how do I tell if mySQL is listening on port 3306? –  Grafica Mar 8 '12 at 15:24
    
In what file is "netstat -an" located? –  Grafica Mar 8 '12 at 15:38
    
Okay, you're not going to have much success running network services if you don't know how to open a command line... –  adaptr Mar 8 '12 at 15:39
    
I'm learning. You started somewhere too. –  Grafica Mar 8 '12 at 15:40
    
I'm looking for port 3306... –  Grafica Mar 8 '12 at 15:42

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.