By jailani on

Well, after resolving the setting.php problem by copying the default.setting.php file,
now i keep getting this message and the database setup installation page.

Failed to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on 'localhost' (10061).

dunt know what shuld i do? or what im doing wrong?

New user here:-)
Jailani

⋅ Categories: Drupal 6.x

Comments

jailani’s picture

jailani commented

p.s. i already got the database created, and added a user with all the nessary permissions.

cog.rusty’s picture

cog.rusty commented

On some hosts, the database server name is not localhost but something else. Look carefully in your cpanel and/or in phpmyadmin to see whether there is a name or an IP for the database server. Or ask your host's tech support.

If the problem is not that, don't copy the default.settings.php file. Delete the copied settings.php file and try the following:
- either set the permissions of the sites/default directory to 777
- or upload an empty text file called settings.php in sites/default, and set the permissions of that file to 666
- or edit the settings.php copy that you created, and comment out the line $db_url = 'mysql://username:password@localhost/databasename'; by putting a # in front.

======== Edited to add:

I just noticed that it is a MySQL error 10061. This means that no mysql daemon/service was found running on TCP port 3306 of localhost. What exactly that means depends on your configuration. Is it a local installation? Windows or Linux? Is there a firewall blocking TCP port 3306? Or you may need to set the bind-address to the hostname where MySQL is running in my.cfg, if you can access MySQL locally on the server's network but not from outside. Or it may be something else.

http://dev.mysql.com/doc/refman/5.0/en/myodbc-errors.html#qandaitem-28-1...

This error can be raised by a number of different issues, including server problems, network problems, and firewall and port blocking problems. For more information, see Section B.1.2.2, “Can't connect to [local] MySQL server”.

http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

mattcch’s picture

mattcch commented

for hosting with cpanel 11+, use localhost,

for hosting with directadmin, it is not localhost, but echoes out the msqyl url after you login in,
maybe diifferent for each user. eg like: 12345678.yourhosting_provider_sqlhost.net

http://www.yaaaonline.com/

kraythe’s picture

kraythe commented

I had that problem because the location for the mysql.sock file was non-standard on my OS X box. That can be fixed by either configuring PHP.ini or my.cnf.

anosk15’s picture

anosk15 commented

Hi

I've edited drupal/sites/default/settings.php and replace localhost for mysql12.000webhost.com (if you are not using 000ewbhost try find another)