|
#
1
Remote MySQL Connection to cPanel |
 |
|
|
luke1 |
 |
|
|
| Online |
no |
| State |
453 |
| Grouping |
Super Admin |
| Class |
class4 |
| Score |
250 |
| Wealth |
62 |
| Posts |
230 |
| Login |
07:37:57 |
|
|
|
Before you can connect to MySQL, You must enable your computer as an access host. 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 IP address in the Internet. 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.ViewIP.info Wait a minute, my IP constantly changes!
Okay, you have a dynamic IP address. Therefore, everytime you go online, or every once in awhile, your IP changes. You have a few options here. The most secure, would be to update your IP in “Allowed Hosts” in CPanel (under MySQL) everytime your IP changes. However, you do have other options available. However, you could simply enter “%” (a percentage sign) in the “access hosts” text filed in CPanel (under mysql). This would allow any IP to remotely connect via mysql. Another option: Lets say the first three parts of your IP never change. Then, you could enter 93.138.%.% , where the first two parts are your actual IP address numbers.
I believe most of you want to use % for simplisity, and not risky i think since there is a pair of username and password.
Hits: 321, Date: 2009-09-14 02:03:47
|
|
|
|
|
Post new topic
)
)
Quote
Edit 
