On Mon, Jun 30, 2008 at 10:54 AM, Suresh Kumar <suresh1876@xxxxxxxxx> wrote:
On Fri, Jun 27, 2008 at 10:17 PM, Arun Velusamy <arunvelusamy@xxxxxxx>
wrote:
fromwhen i try connecting the mysql server on server-2 ( 192.168.8.200)
192.168.8.200my
server-1 (192.168.1.227)
i get the following error
*Warning: mysql_connect(): Can't connect to MySQL server on '
select'
(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
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 ilugc-request@xxxxxxxxxxxxx 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>
