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

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

欧阳克
欧阳克Original
2021-09-29 14:15:1011570browse

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.

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

1. Database

1. Create database

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

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

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

##2. Import database

  • Support sql and zip suffix files

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

3. Visit phpMyAdmin

  • Install phpMyAdmin

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

    ##Need to open port 888

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

##Access the database

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

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

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

##2. Navicat For MySQLHow to access the server-side local database through the external network (graphic demonstration)

1. Installation

Be sure to disconnect from the Internet,

Download

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

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

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

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

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

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

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

##2. Activate

  • Copy the activation software to the installation directory

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

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

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

##Click Patch

How to access the server-side local database through the external network (graphic demonstration)##Open the MySQL software and click Register

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

##Click Generate to obtain the license CertificateHow to access the server-side local database through the external network (graphic demonstration)

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

##Click to activate manually

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

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

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

  • ##Activation successful

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

  • ##3. Connect to the database

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

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

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

Open port 3306
  • Create database external network access accounts and permissions

##1. Open port 3306How to access the server-side local database through the external network (graphic demonstration)

How to access the server-side local database through the external network (graphic demonstration)Alibaba Cloud Server-》Security Group

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

  • ## Pagoda Panel-》Safety

How to access the server-side local database through the external network (graphic demonstration)## 2. Create a database external network access account and permissions

    Open phpMyAdmin

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

# #Click-》Account

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

Click-》New user account

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

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

How to access the server-side local database through the external network (graphic demonstration)##Execution, creation successful

How to access the server-side local database through the external network (graphic demonstration) Test software connection, successful

## Both phpMyAdmin and Navicat For MySQL can access the databaseHow to access the server-side local database through the external network (graphic demonstration)

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

How to access the server-side local database through the external network (graphic demonstration)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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn