mysql connection problem

zoalord · New Member Joined: Aug 05, 2006 Posts: 2

MySQL Database Connectivity Test Results
config.php file found!
I was unable to reach your MySQL server using the MySQL connection settings in your nuke config.php file. The exact error that MySQL reported is:
MySQL Error # 2 = Lost connection to MySQL server at 'reading initial communication packet', system error: 111

running php5
and mysql5 with ubuntu 7.04

this is my config.php which i have starred out the password
$dbhost = '192.168.0.101';
$dbuname = 'root';
$dbpass = '*********';
$dbname = 'ravennuke';
$prefix = 'nuke';
$user_prefix = 'nuke';
$dbtype = 'MySQL';
$sitekey = 'SdFk*fa2rnv21076v28367-dm56w69.3a2fDS+e9';
$gfx_chk = 7;
$subscription_url = '';
$admin_file = 'admin';
$tipath = 'images/topics/';

the reason i have used the internal ip is because i have multiple pc's that i like to get to the admin utility from all of them instead of just localhost.
Thx in advance,
Z

montego · Posted: Wed Jul 11, 2007 7:02 am

Unfortunately I don't know much about remote mySQL connections, so take this for what it is worth. Are you certain that your mySQL instance allows connections from a remote host?

I have only ever used mySQL with localhost.

zoalord · New Member Joined: Aug 05, 2006 Posts: 2

gotya, thx for the input. For some reason installing mysql and using the above config.php works fine in windows.

But not for linux. It requires the localhost command in the config.php.

Thanks for the help. I figured it out this morning just by chance.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2852

MySQL may not be enabled to allow remote connections. By default, this is a security feature. You'd have to dig into the command line to enable remote connections

(I know I had to do this to get a Java program to connect through JBCD to MySQL.. on the same server!)