Tudásbázis

Remote Database Connection Nigeria

Enable Your Computer as an Access Host

By default, all IPs are blocked and must be added to an access list in order to access the server.
Therefore, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.

If you do not know your IP address, find it by going to www.ping.eu

Dynamic IP Addresses

Having a dynamic IP address means that the connecting IP address can change periodically, depending on the Internet Service Provider (ISP).
You must update the connecting IP in Remote MySQL every time it changes.

Procedure

  1. Log into cPanel.
  2. Under Databases, click the Remote MySQL icon.
  3. In the Host field, type in the connecting IP address.
  4. Click Add Host.

You should now be able to connect remotely to your database.

Databse Configuration Settings

Use the following configuration settings for connecting to your database:

Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306
TCP or UDP, either is fine.

  • 1 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

Managing MySQL Databases With PHPMyAdmin Nigeria

Let's learn how to Manage MySQL Databases with phpMyAdmin. This tutorial will assume that you are logged into your cPanel. If you are having trouble doing that, please see the tutorial named "How...

How To Create A MySQL Database Nigeria

Let's learn how to create a MySQL Database. MySQL Databases allow you to store lots of information in an easy to access manner. This tutorial will assume that you are logged into your cPanel. If...

Importing databases and tables with phpMyAdmin Nigeria

This tutorial is to teach you how to import databases and tables with phpMyAdmin. We will assume that you are currently logged into phpMyAdmin, and for the purpose of this tutorial, we will use a...

Inserting fields into database tables with phpMyAdmin Nigeria

This tutorial is going to teach about the program phpMyAdmin, and how to Insert fields into database tables using phpMyAdmin. We will assume that you are already logged into phpMyAdmin. For the...

Deleting tables in a database with phpMyAdmin Nigeria

This tutorial is to teach you about specific operations in phpMyAdmin. We are going to learn how to delete a table in a database with phpMyAdmin. For the purposes of this tutorial, we will assume...