Sometimes, your connection can be blocked by your firewall, so make sure your MySQL port is open. There are many possible causes for failed connection errors like “2003 – Can’t connect to MySQL server”. Please check with your host provider to find similar tools. Here is Hostgator’s excellently documented remote MySQL connection page. HostGator and other quality hosts should provide a simple webpage that displays your remote ip address if you don’t know it…. Keep in mind that your remote ip address may change from time to time and you will have to add the new ip address to the access list. Simply specify your server ip address for the hostname. Then you can access your MySQL database through standard tcpip port 3306. It depends on your provider, but in the case of HostGator for example, you have to add your local ip address to an "allow-access list" which you can do yourself through your account cpanel. Excel2MySQL can access MySQL databases on a local machine, network machine OR on remote host provider servers.
0 kommentar(er)
