Shulou(Shulou.com)06/01 Report--

Second, log in to mysql instance remotely.

To log in remotely, you need to change the corresponding host of the login user to% or the hostname or IP of the remote client (similar to whitelist).

Mysql > update mysql.user set host='%' where user='root'

Mysql > flush privileges

Mysql-u root-P 3306-h 10.68.53.103-p

Third, activate the mysql service

/ usr/local/mysql/bin/mysqld_safe-defaults-file=/data01/mysqldata/3306/my.cnf &

/ usr/local/mysql/bin/mysqld_safe-defaults-file=/data01/mysqlcld/insts/test002/conf/my.cnf &

/ data01/mysqlcld/mysql5.7/bin/mysqld_safe-defaults-file=/data01/mysqlcld/insts/test001/conf/my.cnf &

View

Netstat-ntlp | grep mysql

Or

Netstat-ntlp | grep 3306

Or

Ps-ef | grep mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.