MYSQL 10.1.35 Kaiqi Open remote Connection

1, first open 3306, allow any IP connection
In/etc/mysql/mariable.conf.d/
Vim 50-SERVER.CNF
This location is not the same as the location of the online blog.
In the my.cnf file The last one contains a folder, go to the folder to find yourself (personal experience, academic shallow, do not know the principle)
Find bind-address=127.0.0.1
Change it to
bind-adress=0.0.0.0
Save exit. The 3306 port is open.
2. Authorization of account number
Execute command after logging into database
GRANT all privileges on . To ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;
FLUSH privileges;

You can connect remotely after you have finished running.

MYSQL 10.1.35 Kaiqi Open remote Connection