Local Navicat connects to Alibaba Cloud database RDS for MySQL (the most detailed in the entire network, there is no one!)

Let me first congratulate you all: Happy Holidays! {First of all, let me congratulate you: Happy Holidays! } First first volume I first wish congratulate each bit : Festival day fast music !
Insert picture description here


Starting to enter today's topic, this article explains how to use local Navicat to connect to the cloud database.

I use aliyun cloud. Note that I am not advertising, nor do I have the ability! If you want to use the cloud database, you can go to the ali cloud database official website to have a look: https://www.aliyun.com/product/outline/index?spm=5176.22772544.J_8058803260.38.10632ea9T5tO1q



首 先 我 已 经 准 备 好 了 一 个 云 数 据 库 R D S f o r M y S Q L {首先我已经准备好了一个云数据库RDS for MySQL} First First I have by quasi prepared well of a th cloud number data database R & lt D S F O R & lt M Y S Q L

Insert picture description here


Insert picture description here


1. Set a whitelist (by default, the cloud database cannot be accessed by any IP, you need to add your local IP to the whitelist)

Command window query (ipconfig)
Insert picture description here
Insert picture description here


Insert picture description here
Insert picture description here



2. Create a database account

Insert picture description here


Insert picture description here



3. Create a database

Insert picture description here


Insert picture description here


Insert picture description here



4. Connect to cloud database

有 两 种 方 法 , 第 一 种 是 直 接 在 控 制 台 进 行 在 线 连 接 ; {有两种方法,第一种是直接在控制台进行在线连接;} There are two Species square method , first a Species is directly connected to the control system units into rows in a line connected connection ;

The first type: online connection

Insert picture description here


Insert picture description here
Using this one will prompt you to add certain IPs to the whitelist


The second type: local Navicat connection

Insert picture description here


Insert picture description here
Insert picture description here

How to find the external network address? Look below!

Insert picture description here


It's a success!

Insert picture description here


Insert picture description here