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 > > --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 > -- with regards http://www.discussweb.com J Suresh Kumar 99400 95614 _______________________________________________ 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
