Member Avatar for anony

After hosting, i get this error:"Can't connect to MySQL server on 'localhost' (10061)"
The code was working fine in my computer.
I have hosted it in windows platform and i am using mysql and php.
Here is my code for db connection

$connection = mysql_connect(localhost,uname,pword) or die (mysql_error());

        $db = mysql_select_db($databaseName, $connection);
        if (!$db) {
            print "error selecting db--" . mysql_error() . "--" ;
        }

Any help will be appreciated.

Edited by mike_2000_17 because: Fixed formatting
  • 4 Contributors
  • 7 Replies
  • 337 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

10061 means connection refused. Are you sure mysql is running ? Perhaps a firewall won't let you connect. It can be a number of things.

Member Avatar for anony

Yes mysql is running. And i have created tables but get errors when i try to access them from the website.

Member Avatar for chintan@dani

Hello Anony

Other possible reason to error would be different password.
Is it same on your pc & from website?
Is the database named correctly??

Edited by Ezzaral because: Snipped "fake sig" link. Please restrict such links to your site-wide user signature, which can be edited from the user control panel.
Member Avatar for anony

Yes the password is correct. i can access it using phpmyadmin. Is it because of user privileges??

Member Avatar for metalix

User priveledges don't stop users connecting.
has the php-mysql setup completed correctly?

Member Avatar for anony

yes it was setup correctly.

Member Avatar for pritaeas

Check the config file for phpMyAdmin. Perhaps it is using a different port.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.