Use Navicate to connect to MySQL on Alibaba Cloud Server

1. First enter the server's mysql to modify permissions:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

The login user set here is root and the password is:

2. Refresh permissions by executing the following statement:

FLUSH PRIVILEGES;

The root user is set here, and the access password is 123456

3. Then open navicate, set the password and username in the general, the password is the mysql password set above 123456

General

4. Add Alibaba Cloud's public IP address and the username and password for logging in to the server in ssh, and you can successfully connect to the database. Note: Here are the Alibaba Cloud server login username and password, the same as the permission username you set above

ssh

Summarize

The above is what I introduced to you about using Navicate to connect to MySQL on Alibaba Cloud Server. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:

How to use Navicat to create a database and connect with JDBC
Tutorial on installing MySQL database and using Navicat for MySQL
Simple tutorial on using Navicat For MySQL
Problems with changing password and connecting to Navicat when installing and using MySQL 8.0.16 under Windows 7
Import csv file into mysql using navicat
Simple examples of creating stored procedures, triggers and using cursors in Navicat (pictures and text)
Use Navicat Premium to export SQLServer data to sql format
Use Navicat 8 to create a database and import data to manage users and permissions [Graphic Method]
Detailed explanation of the simple use of Navicat

<<: VMware Workstation 14 Pro installs CentOS 7.0

>>: React Native scaffolding basic usage detailed explanation