On Mon, Jun 30, 2008 at 10:54 AM, Suresh Kumar <[EMAIL PROTECTED]> wrote:
> > > On Fri, Jun 27, 2008 at 10:17 PM, Arun Velusamy <[EMAIL PROTECTED]> > wrote: > >> >> >> >> when i try connecting the mysql server on server-2 ( 192.168.8.200) >> from >> >> my >> >> server-1 (192.168.1.227) >> >> i get the following error >> >> >> >> *Warning: mysql_connect(): Can't connect to MySQL server on ' >> 192.168.8.200 >> >> ' >> >> (4) in /srv/www/htdocs/../../dbtest.php on line 5 Not able to connect >> >> Error Can't connect to MySQL server on '192.168.8.200' (4)Cannot >> select >> >> DB!* >> >> I ran across the same problem some time back. >> >> Check what is in "bind-address" on your my.cnf file. If it is localhost >> or 127.0.0.1, >> change it to 192.168.8.200. Now restart the mysql server and try it >> again. >> > > my.cnf file does not contain any such code. > here is the code of my.cnf file which i have in 192.168.8.200 > > # The following options will be passed to all MySQL clients > [client] > #password = your_password > port = 3306 > socket = /tmp/mysql.sock > > # Here follows entries for some specific programs > > # The MySQL server > [mysqld] > port = 3306 > socket = /tmp/mysql.sock > skip-locking > key_buffer = 16M > max_allowed_packet = 99999M > table_cache = 64 > sort_buffer_size = 512K > net_buffer_length = 8K > read_buffer_size = 256K > read_rnd_buffer_size = 512K > myisam_sort_buffer_size = 8M > > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > #safe-updates > > [isamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [myisamchk] > key_buffer = 20M > sort_buffer_size = 20M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > > > this time i get this error. Warning: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 113 please help > > > >> >> --Arun Velusamy. >> >> >> >> >> >> _______________________________________________ >> To unsubscribe, email [EMAIL PROTECTED] with >> "unsubscribe <password> <address>" >> in the subject or body of the message. >> http://www.ae.iitm.ac.in/mailman/listinfo/ilugc >> > > > > -- > > > <http://www.discussweb.com> _______________________________________________ To unsubscribe, email [EMAIL PROTECTED] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
