Plasahosting Blogs
Web Hosting murah Indonesia

Remote MySQL Connection :: HowTo

June 28th 2005 in Artikel

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.ip2location.com/
http://ip2country.com/

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.

After your IP is added to the Access Hosts list:

First, you will have to create a mysql database and assign a user to it. Please see documentation on how to do this, as this article will assume you already have a database setup. Your username and password will be the username and password of the user assigned to the database.

Database name = cpanelusername_databasename

Database username = cpanelusername_databaseusername

MySQL Connection Port = 3306

* The database name and username is clearly displayed in CPanel, in the MySQL area.




required



required - won't be displayed


Your Comment:




An addon domain is a domain name that that points to a subdirectory within your account. For example, you may want yourdomain.com to point to mydomain.com/yourdomain/.

Addon domains must be registered domain names that you own and configured to point to your web site’s servers.

To add a domain to your web site, follow these simple steps:

Change […]

Previous Entry

Solusi berikut untuk mempercepat proses upload file ke server, saya melakukannya kurang dari 3 menit untuk file ukuran kurang dari 5Mb. Nggak percaya?? Ikuti petunjuk berikut ini.

SEMUA LANGKAH DIBAWAH SUDAH TERUJI BERHASIL OLEH RIBUAN ORANG
KEGAGALAN UPLOAD YANG TIDAK MENAMPILKAN HASIL WEBSITES YANG DIHARAPKAN DISEBABKAN KURANG MEMPERHATIKAN LANGKAH YANG DIBERIKAN.
SOLUSI ULANGI MENGIKUTI ARTIKEL INI SECARA PERLAHAN.

[…]

Next Entry