MySQL修改字符集和给任意IP授权允许登录

查看字符集

mysql> show variables like '%character%';
(mysql中utf8不算真正意义上的utf8，utf8mb4才是)

vim打开编辑  /etc/mysql/debian.cnf。添加如下：

[client]
...
default-character-set=utf8

vim打开编辑  /etc/mysql/mysql.conf.d/mysqld.cnf 。添加如下：

[mysqld]
...
character_set_server=utf8

vim打开编辑  /etc/mysql/conf.d/mysql.cnf 。添加如下：

[mysql]
...
default-character-set=utf8

给任意IP授权

即允许其他设备登录此台中的mysql

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