mysql远程客户端无法连接，修改配置文件

mysql远程客户端连接:

4)设置Mysql远程访问

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

5)编辑配置文件/etc/my.cnf,有时候没有需要创建

[mysql]

default-character-set=utf8

[mysqld]

user=mysql

skip-name-resolve

datadir=/opt/data/mysql

#socket=/opt/data/mysql/mysql.sock

port=3306

max_allowed_packet = 20M

max_connections=1500

thread_concurrency = 16

tmp_table_size=512M

thread_cache_size = 512

query_cache_size = 512M

lower_case_table_names=1

log-error=/var/log/mysql.log

#[mysqld_safe]

#log-error=/var/log/mysqld.log

#pid-file=/var/run/mysqld/mysqld.pid

#[client]

#socket=/opt/data/mysql/mysql.sock

最后按Esc输入:wq保存退出