Failed to connect to mysql - no response after period of time

[Jordan Magnuson]

I'm quite excited to start using Uniform Server after what I've heard involving speed improvements with drupal (over XAMPP and WAMP).

 

Unfortunately I've been trying to get it to work for the last couple of hours without success. I've narrowed the problem down to something having to do with mysql:

 

1.When I try to change the mysql root password from Apanel, I get "waiting for localhost" for a period of time, and then the webpage reloads with "Error Connecting to mysql."

 

2. When I try to set up a drupal installation, I get this message after entering the mysql database information (using username root, password root, on a database I just created in phpmyadmin):

"Failed to connect to your MySQL database server. Mysql reports the following message: 'A connection attempt failed because the connected party did not properly respond after a period of time."

 

3. I AM able to access phpmyadmin, and create new db's and users.

 

 

Other things to note:

*I'm using Windows 7.

*Started Apache and mysql as programs, not services.

*Server Status says everything's okay.

*I CAN'T install Apache and mysql as services: when I try, Server Status tells me that they are not running and that port situation is "Unknown!" Even though task manager shows the services as having started correctly. I don't know if this has anything to do with my problem.

*Until today have been using XAMPP, which works fine (though localhost a bit slow).

 

Any help with this would be much appreciated!

 

Thanks!

 

Jordan

[Jordan Magnuson]

Can I please get some help on this?

[Kevinmears]

Exactly the same problem here any help would be appreciated.

 

I'm quite excited to start using Uniform Server after what I've heard involving speed improvements with drupal (over XAMPP and WAMP).

 

Unfortunately I've been trying to get it to work for the last couple of hours without success. I've narrowed the problem down to something having to do with mysql:

 

1.When I try to change the mysql root password from Apanel, I get "waiting for localhost" for a period of time, and then the webpage reloads with "Error Connecting to mysql."

 

2. When I try to set up a drupal installation, I get this message after entering the mysql database information (using username root, password root, on a database I just created in phpmyadmin):

"Failed to connect to your MySQL database server. Mysql reports the following message: 'A connection attempt failed because the connected party did not properly respond after a period of time."

 

3. I AM able to access phpmyadmin, and create new db's and users.

Other things to note:

*I'm using Windows 7.

*Started Apache and mysql as programs, not services.

*Server Status says everything's okay.

*I CAN'T install Apache and mysql as services: when I try, Server Status tells me that they are not running and that port situation is "Unknown!" Even though task manager shows the services as having started correctly. I don't know if this has anything to do with my problem.

*Until today have been using XAMPP, which works fine (though localhost a bit slow).

 

Any help with this would be much appreciated!

 

Thanks!

 

Jordan

[Kevinmears]

Hi All,

 

Solved it! Instead of using 'localhost' as the host name just us '127.0.0.1'

 

Kevin

[Jordan Magnuson]

Hi All,

 

Solved it! Instead of using 'localhost' as the host name just us '127.0.0.1'

 

Kevin

 

Thanks a lot for sharing Kevin! Where did you change that?

[dimo414]

*I'm using Windows 7.

Me too, and I just realized what the issue is - Windows 7 assumes the DNS server will manage pointing localhost to 127.0.0.1, but not all DNS servers do that yet.

 

To fix this problem edit your hosts file (C:/Windows/System32/drivers/etc/hosts) and uncomment the line:

127.0.0.1   localhost

 

DO NOT uncomment this line:

::1	localhost

 

As it will take priority and something about the system (not sure which part) doesn't like that.