Mysql安装后的一些设置

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)

转载于:https://www.cnblogs.com/Red-28K/archive/2013/04/29/mysqlset.html