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

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

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!