Unable to remotely access my MySQL 5.5 install
I am running a Windows 2008 Enterprise Server and I have installed MySQL 5.5
I have several programs running that are using MySQL and its all working.
The problem comes when I need for php scripts on another server to access the W2008 server, then I just get connection errors. Like:
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2003): Can't connect to MySQL server on 'my_static_ip' (110) in /home/blackmar/public_html/minecraft/Statsogachievements/minestats.php on line 25
Connect Error (2003) Can't connect to MySQL server on 'my_static_ip' (110)
The ports are open in the firewall and by using an online portscanner on port 3306, it says that mysql is open and listening.
I have enabled named pipes.
Keep in mind that I adminstrate MySQL through the workbench, so no experience with other ways of editing the settings and even the workbench I am pretty bad at.
Can anyone advice what I need to do so the scripts can access the database remotely?
Subject
Written By
Posted
Unable to remotely access my MySQL 5.5 install
April 05, 2011 12:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.