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保存退出