1.设置root可以从任意地址访问：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;flush privileges;

%可以替换为ip地址，即为限制只能从此ip访问。

2.编辑my.cnf设置：

bind-address = 0.0.0.0

mysql监听本机所有地址。

3.设置mysql server默认字符集和连接为utf8：

[client]

default-character-set=utf8

[mysqld]

init_connect='SET NAMES utf8'

character_set_server = utf8

[mysql]

default-character-set=utf8

查看设置效果：

mysql> show variables like "%colla%";

+----------------------+-------------------+

| Variable_name        | Value                |

+----------------------+-------------------+

| collation_connection | utf8_general_ci |

| collation_database   | utf8_general_ci  |

| collation_server     | utf8_general_ci    |

+----------------------+-------------------+

3 rows in set (0.00 sec)

mysql> show variables like "%char%";

+-------------------------------+------------------------------+

| Variable_name　　　　　　  | Value                              |

+-------------------------------+------------------------------+

| character_set_client　　　　| utf8                                  |

| character_set_connection 　| utf8                                  |

| character_set_database　　 | utf8                                  |

| character_set_filesystem     | binary                               |

| character_set_results          | utf8                                  |

| character_set_server           | utf8                                  |

| character_set_system          | utf8                                  |

| character_sets_dir               | /usr/share/mysql/charsets/ |

+--------------------------+-------------------------------------+

8 rows in set (0.00 sec)