# 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:
Log in phpMyAdmin, go to User account->Edit privileges of root account
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:
Use SSH to connect MySQL Server
sudo mysql -u root -p password
Open the remote connection
mysql> use mysql; mysql> update user set host = '%' where user = 'root';
Test it
select host,user from user where user='root'
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