1. Related applications

Navicat (PJ version) MySQL6. 0Ali Cloud Lightweight application server Highlight: Pagoda Linux panelCopy the code

2. Specific process

2.1 Opening firewall Ports

Open ali Cloud background left to find the firewall

Click Add rule

See the list has just configured drop port 3306 can be

2.1.1 Develop the firewall port of Ali Cloud server

Open the pagoda panel to the left to find safety

Port number write 3306 remarks according to their own preferences fill, then click release, and then see the list can be

2.1.2 Develop the firewall port on the tower panel

2.2 Downloading the Database

Open the pagoda panel and click on the database on the left. If MySQL is not downloaded, it will be automatically prompted to download it. Click Download, select the version of MySQL you want, and click Download

Click Add Database

Click Submit and you’re done

2.2 Configuring the Server

Open ali Cloud background to find the remote connection on the left

2.3 configuration navicat

Go to File — New Connection

To configure SSH

Reconfiguration routine

Finally, the connection test is basically no problem as long as there is no configuration error