[Ilugc] mysql-php server access denied
- From: suresh1876@xxxxxxxxx (Suresh Kumar)
- Date: Mon Jun 30 10:54:39 2008
On Fri, Jun 27, 2008 at 10:17 PM, Arun Velusamy <arunvelusamy@xxxxxxx>
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 ilugc-request@xxxxxxxxxxxxx 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
Other related posts:
