MySQL Connection String Using PHP

Question

Hi,

I am trying to connect to the database that is hosted on my server through my local machine.

my server has cPanel 11, and it is a typical shared server, powered by CentOS, PHP and MySQL installed.

to be precise i am holding the reseller account in the same server. i want to access the database between different accounts or domains.

in MySQL connection String i tried defining the domain name, and it isn't working. here is what i tried.

<?php
$link = mysql_connect('mydomain.com', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

this is giving the following error

Warning: mysql_connect() [function.mysql-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://bhatkalnews.com:3306) in C:\wamp\www\test\conn.php on line 4

Warning: mysql_connect() [function.mysql-connect]: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\wamp\www\test\conn.php on line 4

Fatal error: Maximum execution time of 60 seconds exceeded in C:\wamp\www\test\conn.php on line 4

what do i have to define in connection string to make it work?

Answer 1

Did you try adding the port explicitly:

mysql_connect('mydomain.com:3306', 'mysql_user', 'mysql_password');

or the port youre running on if not the default 3306. This of course assumes your server allows remote connections.

Also make sure the user in quest has access from the IP address youre connecting from. This isnt youre issue right now, but it may be the next question you have after you get the server to respond :-)

Answer 2

Please refer,

http://forums.mysql.com/read.php?52,294772

Answer 3

You need to add your IP address/range on Access Host list in Remote MySQL in cPanel.

Answer 4

Firewall ?

try

telnet mydomain.com 3306

on the command line.

If that doesn't work, the connection is blocked by a firewall, most likely