远程连接阿里云上的Mysql，连接不上！

Question

除了分配权限之外，还有其他要配置的么？

Answer 1

There may be two reasons. One is because of browser interception. You can use

service iptables stop

Solved, but this is more dangerous.

Second, change 127.0.0.1 to localhost in the configuration. The configuration may be in bind-address

/etc/mysql/my.cnf

or

/etc/mysql/mysql.conf.d/mysqld.cnf

Find

and change it to bind-address

bind-address = 127.0.0.1

If you cannot find the configuration, you can also use the

command to search find

find / -name mysqld.cnf

find / -name my.cnf