Preface: Today I want to remotely connect to MySQL on my server. The software I use is Navicat. The MySQL version on the server is 5.7 Something went wrong when I connected for the first time. It probably means that you cannot connect to the MySQL service. The solution steps are as follows First: First check whether your Alibaba or Tencent server console has enabled access to port 3306. For where to look, please search Baidu. Mine is as follows. You can see that remote connection is not allowed. If you haven't enabled it like me, then enable it. After enabling Allow all connections, try again Another error occurred. This time, the approximate meaning is that access to this MySQL service is denied. The solution is as follows First: Enter MySQL, select the MySQL database, and check the user=root information As you can see, the root user is only allowed to access locally. Now you need to change it to all or specify the IP address. I changed it to all, don't forget to flush privileges, that is, refresh the permissions, and finally try to connect remotely. You can see that you can connect remotely. Summary: The first step is to check whether the Alibaba or Tencent server backend is open to allow connection to port 3306 Step 2: Check whether the root user of the MySQL database table is allowed to connect remotely The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: How to manually scroll logs in Linux system
>>: WeChat applet scroll-view implements a solution to duplicate data loading when pulling up
Table of contents 1. Flink Overview 1.1 Basic Int...
The transaction log records the operations on the...
Nginx log description Through access logs, you ca...
1. If MySQL is not started successfully, check th...
After setting the table width in the page to width...
Preface PC Server has developed to this day and h...
Table of contents 1. Control the display and hidi...
The road ahead is always so difficult and full of...
This article example shares the specific code of ...
1. Overview Redis Cluster enables high availabili...
In actual projects, there are relationships betwe...
I recently encountered a problem when doing IM, a...
This article is mainly to let beginners understan...
1. Download the 64-bit zip file from the official...
Library Operations Query 1.SHOW DATABASE; ----Que...