MySQL remote connection

Most of the time, if you want to use GUI tools to manage MySQL/MariaDB on you local computer, you shoud open the remote connection of MySQL/MariaDB.

Database is high security application, you need two steps for remote connection settings at least:

Enable the TCP:3306 port

In general, MySQL uses port 3306.

First, you must go to the Cloud Console and enable the TCP:3306 port of Security Group

Open MySQL remote connection

After the security group is turned on, the setup of the MySQL remote solution has not been completed.

Next, you need to set up MySQL itself so that it can access external networks

We provide two solutions to open the remote connection of MySQL. The first is GUI and the second is the command mode:

Use GUI(recommend)

To enable remote in phpMyAdmin, you only need to change the access mode of the root account to "any way to access", as follows:

1. Log in phpMyAdmin, go to User account->Edit privileges of root account

2. Select the tab Login Information, Host Name fill in "%", click "Go" button completing this setting

Use commands

If you have not installed phpMyAdmin or other GUI tools in you Server, you should use command to open the MySQL remote connection:

1. Use SSH to connect MySQL Server

   sudo mysql -u root -p password
   

2. Open the remote connection

   mysql>  use mysql;
   mysql>  update user set host = '%' where user = 'root';
   

3. Test it

   select host,user from user where user='root'
   

4. Exit MySQL command mode, return to Linux and restart it

   sudo systemctl restart mysqld
   

   This step is necessary, otherwise Navicat Premium/MySQL-Front can't connect to MySQL