Home WebServer PanelcPanel How to enable Remote Database on cPanel

How to enable Remote Database on cPanel

by Thạch Phạm
Khuyến mãi sinh nhật 8 tuổi

In the process of using cPanel, to access and manipulate the database, you must do it in phpMyAdmin. However, in some cases, you need to connect to a remote database (for example, using remote database management software such as Navicat or connecting to a website on another host) then you must enable the Remote MySQL feature as in this guide.

First, go to cPanel => find the Remote MySQL section.

chrome lXBRhMDiQp

Then you declare the following information:

  • Host: The server IP address to connect, if you want to connect on all servers, enter the value %
  • Comment: Description or extra notes
chrome iFme7uNL2f

Then you can proceed to connect to the database remotely. For example, if you use Navicat, open the software, select Connection => MySQL.

navicat AMVfntQohi

You enter full database information, including:

  • Connection Name: Enter the display name
  • Hosts: Enter the server IP or the server address.
  • Port: Default is port 3306
  • Username: You enter the hosting username to remote control the entire existing database on the hosting or enter an independent database account
  • Password: You enter the hosting password if the user is the hosting user or enter the database password if the Username is the database user

Next, click Test Connection to check the connection and click OK to save.

Then you click on the Database Name above and select Open Connection

navicat VYfNW6slZW

If the connection is successful, the full display will appear, as shown below:

navicat VYfNW6slZW

You have now completed connecting to the MySQL database on the host remotely through the Remote MySQL feature on cPanel.

Đánh giá
Khuyến mãi sinh nhật 8 tuổi

Bài viết cùng chuyên mục

AZDIGI – Không chỉ là đơn vị hàng đầu trong lĩnh vực Web Hosting và Máy chủ, chúng tôi mong muốn mang lại những kiến thức bổ ích nhất và luôn cập nhật thường xuyên cho cộng đồng người đam mê thiết kế website, công nghệ,…

Vui lòng không sao chép nội dung nếu chưa xin phép. Designed and Developed by PenciDesign