Shulou(Shulou.com)05/31 Report--

Editor to share with you how to access the database, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

The method of accessing the database in the external network: 1, create the database; 2, import the database; 3, phpmyadmin access; 4, install and activate navicat for mysql;5, connect to the database.

I. Database

1. Create a database

2. Import the database

Sql and zip suffix name files are supported

3. PhpMyAdmin access

Install phpMyAdmin

Port 888 needs to be opened.

Access the database

II. Navicat For MySQL

1. Installation

Be sure to cut off the network and download

2. Activate

Activate the software copy 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 get the license

Click to activate manually

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

Activation succeeded

Connect to the database

It is impossible to connect directly, but two conditions are required to connect to the server database with software.

Open port 3306

Create database public network access account and permissions

1. Open port 3306

Ali CVM-"Security group"

Pagoda panel-"safe"

2. Create database public network access account and permissions

Open phpMyAdmin

Click-"account"

Click-"add user account"

Enter user, password

Select permissions, if you do not understand the meaning of each permission, put the mouse on the corresponding permissions, do not move, there will be instructions

Execution, created successfully

Test software connection, successful

Both phpMyAdmin and Navicat For MySQL can access the database.

The above is all the contents of the article "how to access the database on the external network". Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.