Database issues and pitfalls in connecting to cloud servers with Navicat Premium15

Database issues and pitfalls in connecting to cloud servers with Navicat Premium15

When using a cloud server, we sometimes connect to the database, but when using Navicat Premium15 to connect, we always get an error.
The following is a general connection method using MySQL 5.6.50 in Tencent Cloud Server.

Heart Mender

General Links:

insert image description here

insert image description here

After filling in the above, click Test Connection, and an error will be reported, as shown in the figure:

insert image description here

Unable to connect! In this case, when modifying the security group rules in Tencent Cloud Server, both the inbound and outbound rules need to be changed.

insert image description here
insert image description here
insert image description here
insert image description here
insert image description here

After clicking Finish, adjust the outbound rules. This is the same as the inbound rules and will not be explained here.
After completing the above operations, return to Navicat Premium15 for configuration, and still get an error (2003-Can't connect to MySQL server on 'host' (10060 "Unknown error"))
Return to the home page of the pagoda and click on the security configuration on the home page.

insert image description here
insert image description here

Click Release. After release, return to Nacivat Premium15 and click Test Connection. It will show that the connection is successful.

insert image description here

The above are the problems I encountered during the connection test. I share them with you for discussion. If there are any problems, please correct them in time. Thank you.

This is the end of this article about Navicat Premium15 connecting to the database in the cloud server. For more information about Navicat Premium15 connecting to the cloud server database, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • Navicat Premium connect to mongodb detailed tutorial
  • How to use Navicat Premium to connect to Oracle
  • Solve the problem that the oracle library is not loaded when Navicat Premium 12 connects to Oracle
  • How to remotely connect to MySQL database with Navicat Premium
  • When Navicat Premium connects to the database, the error message appears: 2003 Can't connect to MySQL server on''localhost''(10061)
  • Analysis on how to solve the problem of Navicat Premium connecting to MySQL 8.0 and reporting error "1251"
  • Solve the problem of Navicat Premium 15 crashing when connecting to the database

<<:  Summary of bootstrap learning experience-css style design sharing

>>:  Usage and description of HTML tag tbody

Recommend

How to obtain root permissions in a docker container

First, your container must be running You can vie...

Automatic backup of MySQL database using shell script

Automatic backup of MySQL database using shell sc...

A complete guide to some uncommon but useful CSS attribute operations

1. Custom text selection ::selection { background...

A simple and in-depth study of async and await in JavaScript

Table of contents 1. Introduction 2. Detailed exp...

Implementing custom scroll bar with native js

This article example shares the specific code of ...

CentOS 8 Installation Guide for Zabbix 4.4

Zabbix server environment platform ZABBIX version...

Ubuntu installation graphics driver and cuda tutorial

Table of contents 1. Uninstall the original drive...

Example code for implementing fullpage.js full-screen scrolling effect with CSS

When I was studying CSS recently, I found that I ...

Tutorial diagram of installing zabbix2.4 under centos6.5

The fixed IP address of the centos-DVD1 version s...

CSS multi-column layout solution

1. Fixed width + adaptive Expected effect: fixed ...

Vue+node realizes audio recording and playback function

Result: The main part is to implement the code lo...