Home / server / Questions / 223288
Accepted
Utku Dalmaz
Asked: 2011-01-18 02:36:53 +0800 CST

error on remote connection to mysql

  • 772

I ve been trying to connect my dedicated server mysql db from my computers localhost my code is here;

$dbhost = 'domain.com';
$dbuser = 'username';
$dbpass = 'pass';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect: ' . mysql_error());

$dbname = 'dbname';
mysql_select_db($dbname);

I get that error

Could not connect: Lost connection to MySQL server at 'reading initial communication packet', system error: 61

Dedicated server is Linux centos 64 bit, php 3.2.4, mysql 5.1.54

Is there any workaround that ?

Thanks

mysql remote-access

3 Answers

  1. Check the my.cnf on your MySQL server, specially the bind-address parameter. Most of the time you need it commented to accept connections on all IP addresses of the server.

    • 0

  2. Check the firewall settings on your dedicated server. Maybe the port for the MySql server is blocked (usally 3306).

    • 0
  3. Best Answer

    Verify that MySQL is running and if you are able to connect by using 'telnet x.x.x.x 3306'. If you can get that far, your problem exists in MySQL's permissions. If not, check the firewall (iptables -L) as the previous person suggested, and verify that my.cnf is set up to listen to tcp (make sure there is no skip_networking line).

    • 0