troubleshooting Question

MySQL 5.1 - Cannot connect to mysql from remote server

Avatar of Birgos
Birgos asked on
MySQL ServerWindows Server 2008
8 Comments1 Solution784 ViewsLast Modified:
Hello everybody,

trying to connet to my mysql server 5.1 from a remote machine without any luck.
netstat -an tells me:
TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING

I can connect via:
telnet localhost 3306

but not with:
telnet serverip 3306

Local Firewall is off, also DEP.
OS MS Windows Server 2008 x64
Here is my Config-File:
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port = 3306
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
default-character-set=latin1
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=160
query_cache_size=200M
table_cache=320
tmp_table_size=204M
thread_cache_size=8
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=336M
key_buffer_size=32M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_data_home_dir="D:/mySQL/data/"
innodb_additional_mem_pool_size=24M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=12M
innodb_buffer_pool_size=1154M
innodb_log_file_size=231M
innodb_thread_concurrency=8

Also tried with following options but it doesnt help either.
enable-named-pipe
skip-name-resolve
bind-address=serverip   <== But then i can't connect to my sqlserver in any way.

Any help would be appreciated !!!! I don't know how to resolve that issue....

Kindly Regards
birgos
ASKER CERTIFIED SOLUTION
Birgos

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros