How to access the server-side local database through the external network (graphic demonstration)

Methods for accessing the database from the external network: 1. Create a database; 2. Import the database; 3. Access via phpmyadmin; 4. Install and activate navicat for mysql; 5. Connect to the database.

1. Database

1. Create database

##2. Import database

• Support sql and zip suffix files

3. Visit phpMyAdmin

• Install phpMyAdmin

##Need to open port 888

##Access the database

##2. Navicat For MySQL

1. Installation

Be sure to disconnect from the Internet,

Download

##2. Activate

• Copy the activation software to the installation directory

##Right-click to activate the software-》Run as administrator

##Click Patch

##Open the MySQL software and click Register

##Click Generate to obtain the license Certificate

##Click to activate manually

Copy the request code into the rich text box above and click Generate to get the activation code

##Activation successful

##3. Connect to the database

Direct connection is not possible. Using software to connect to the server database requires 2 conditions

Open port 3306

• Create database external network access accounts and permissions

##1. Open port 3306

Alibaba Cloud Server-》Security Group

• ## Pagoda Panel-》Safety

## 2. Create a database external network access account and permissions

Open phpMyAdmin

# #Click-》Account

Click-》New user account

Enter the user and password

• Select the permissions. If you don’t understand the meaning of each permission, place the mouse on the corresponding Regarding permissions, don’t move, there will be instructions

##Execution, creation successful

Test software connection, successful

## Both phpMyAdmin and Navicat For MySQL can access the database

##[Special topic: Building and using the Linux CentOS server PHP operating environment]

1.

linux CentOS server is online

2.

linux CentOS Pagoda panel

3.

linux CentOS Pagoda panel Use svn

4.

Access the database from the external network

5.

Pagoda panel FTP

Recommended learning:

phptraining

The above is the detailed content of How to access the server-side local database through the external network (graphic demonstration). For more information, please follow other related articles on the PHP Chinese website!