Jump to content
The Uniform Server Community
Jordan Magnuson

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

Recommended Posts

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 ;)

Share this post


Link to post
Share on other sites

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 ;)

Share this post


Link to post
Share on other sites
*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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...