Remote MySQL Connection :: HowTo
Can I remotely connect to mysql? YES! Follow these simple instructions to remotely connect to mysql. Before you can connect to MySQL, You must enable your computer as an access host. It may sound confusing, but CPanel makes this ver simpe. First, login to cpanel using yourdomain.com/cpanel. Then, on the main menu of CPanel, click [MySQL]. Now, scroll down to about mid way through the page until you see "Access Hosts:". Under that, you will see a list of all the IPs that are permitted to connect to your mysql databases. As default, only "localhost" will be listed. Directly under that, you will see "Host (% wildcard is allowed):" with a text field next to it. In that text field you can enter your computers IP address. After you enter your IP address, click [Add Host] and your done. Your computer can now remotely connect to your mysql database(s). How can I find out my computers IP address? - Simple, just go to http://www.whatismyip.com/ http://www.ip2locatio...