Hi, I apologize for raising this issue but I'm at my wits end. I tried all the suggestions previously mentioned on this forum site.
Issue is that when I try to connect to the remote MYSQL server on my lan from my WindowsXP computer I get this error,
"Lost connection to MySQL server at 'reading initial communication packet', system error: 111"
On the server I'm running ClearOS 5.1(linux)with the PHP and MYSQL that comes with that. I have also have Webmin installed also.
Yes the MYSQL server is running. I can log into the MYSQL server via the prompt on the ClearOS box successfully. I can look at everything in the MYSQL server via Webmin also. Its essentially a problem of lan acccess to MYSQL so that I can connnect via PHPRunner from my windows computer. I can FTP to ClearOS box ok.
I have granted access for my windowsXP computer's ip on Host Permissions. I have given access to users for MYSQL and databases.
I know the user name and password are correct. I know the MYSQL server is using port 3306. Is this an issue with SSH?
I have also enclosed my my.cnf file. Any help would be greatly apreciated.
[mysqld]
datadir = /var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=64M
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1
port = 3306
big-tables
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
