[client] port=3306 default-character-set=utf8 [mysqld] port=3306 #最大连接数 max_connections=200 # 设置MYSQL安装目录 basedir=D:\app\mysql-5.7.20-winx64 # 设置MYSQL数据目录 datadir=D:\app\mysql-5.7.20-winx64\data character_set_server=utf8 sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER #开启查询缓存 explicit_defaults_for_timestamp=true #跳过密码验证 #skip-grant-tables # 开启 binlog log-bin=mysql-bin # 选择 ROW 模式 binlog-format=ROW
mysql> update mysql.user set authentication_string=password(‘你的密码‘) where user=‘root‘; mysql> flush privileges;
mysql> show variables like "%char%";
修改：
mysql> SET character_set_client=‘utf8mb4‘;
mysql> SET character_set_connection=‘utf8mb4‘;
mysql> SET character_set_database =‘utf8mb4‘;
mysql> SET character_set_results=‘utf8mb4‘;
mysql> SET character_set_server=‘utf8mb4‘;
七、授权任何人可以连接
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘你自己的密码‘ WITH GRANT OPTION; mysql> FLUSH PRIVILEGES;
原文：https://www.cnblogs.com/sungong1987/p/15188527.html