Start a conversation

How to connect to the MySQL server remotely

How to connect to the MySQL server remotely

=================================================

Configuration Settings:
Host = (use the server IP address)
Database name = (cpanelusername_databasename)
Database username = (cpanelusername_databaseuser)
Database password = (******)
MySQL Connection Port = 3306
TCP or UDP, either is fine.

Before you can connect to MySQL from another computer, you must enable your computer as an Access Host. It may sound confusing, but cPanel makes this very simple.

  1. Login to cPanel and click the Remote MySQL icon, under Databases.
  2. Type in the connecting IP address, and click the Add Host button.
  3. All done, try connecting remotely.

How can I find out my computers IP address?


Simple, just go to www.whatismyip.com 


Wait a minute, my IP constantly changes.


Okay, you have a dynamic IP address. Therefore, every time 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 Remote MySQL every time your IP changes. However, you do have other options available. You could simply enter % (a percentage sign) in the Add Access Hosts text field. This will allow any IP to remotely connect to your databases. Another option: Let's say the first two parts of your IP never change. Then, you could enter 93.138.%. %, where the first two parts are your actual IP address numbers.



Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Eicra.com

  2. Posted
  3. Updated

Comments

  1. shahidul islam

    মেহাদয়, আমােদর ডাটা সার্ভােরর আইিপ অথবা েহাস্ট নাম দরকার। েডস্কটপ ডাটােবস ৈতিরর জন্য serverName, port no দরকার। odbc ও adodb এর জন্য যা যা দরকার। দয়া কের উক্ত তথ্যগুেলা েপেল কৃতঞ্জ থাকেবা। please send me our mysql server IP and Host-name, port no whois needed for connect desktop software(odbc and adodb) and Macromedia dream waver thanks by Ideal computer training institute, barguna. +8801722542773 +8801924382547