允许远程访问
- 被访问绑定地址的的修改 修改 my.cnf 文件
[mysqld]
bind-address = 0.0.0.0
复制代码
- 保存并重启mysql服务
$ sudo /etc/init.d/mysql restart
复制代码
- 授权用户远程链接
mysql> grant all privileges on *.* to root@"%" identified by "password" with grant
option;
mysql> flush privileges;
复制代码
支持表情
- my.cnf 添加以下内容
[mysqld] character-set-server = utf8mb4 collation-server = utf8mb4_general_ci init_connect='SET NAMES utf8mb4' skip-character-set-client-handshake = true
[client] default-character-set=utf8mb4
[mysql] default-character-set=utf8mb4
复制代码
- 重启服务
$ sudo /etc/init.d/mysql restart
复制代码
- 修改对应的数据库,表,字段