Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I want to access my MySql database remotely, but can't seem to make it happen. Accessing the database local works perfectly fine.

System - Window Server 2008 Web Edition - IIS 7 - Mysql 5.1.56

I have tried the following things: - Grant mysql user full access (all privileges) and connection access from any host ("%") - Turn off Windows Firewall on server and open port 3306 on external Firewall - Added the following code to my my.ini:

# The MySQL server
[mysqld]
basedir                 = "C:\rootfolder\MySQL\"
datadir                 = "C:\rootfolder\MySQL\data\"
port                  = 3306
#socket                  = "MySQL"
socket                  = "TCP/IP"
skip-locking
key_buffer              = 16M
max_allowed_packet      = 1M
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

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
#enable-named-pipe
bind-address=0.0.0.0

When connection I use: - Public IP from server - Username from user with all privileges - corresponding password - Port 3306

Sequal Pro (which i'm using tot connect) says the following:

Unable to connect to host IP, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).

MySQL said: Can't connect to MySQL server on 'IP' (4)

Can anybody help me out?

share|improve this question
    
On the firewall, have you forwarded port 3306 to the correct server? –  John Gardeniers Aug 24 '12 at 9:25
    
Yeah. It is a managed server by our datacentre so I expect them to set this up right. –  Wouter Rosenkamp Aug 24 '12 at 12:51
    
Anybody an idea? –  Wouter Rosenkamp Aug 27 '12 at 8:03
    
You may expect them t set it up right but that doesn't men it will always happen. Check with them and ask them to verify that it was done. People make mistakes, so don't rely on assumptions. –  John Gardeniers Aug 27 '12 at 9:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.