[client]
default_character_set=utf8
[mysqld]
character_set_server=utf8
[mysql]
default_character_set=utf8
# 在 ini 配置中设置编码
SHOW VARIABLES LIKE 'character%';
# 查看整体编码
CREATE USER 'demo@localhost' IDENTIFIED by 'demo';
# 创建新的用户
mysqld --default-files="d:/amp/mysql/my.ini"
# 设置 mysql 配置文件位置
SET PASSWORD FOR 'root'@'localhost'=PASSWORD('root');
# 修改用户密码
# 创建一个拥有所有权限的用户
CREATE USER 'zy'@'%' IDENTIFIED BY 'pswd';
GRANT ALL PRIVILEGES ON *.* TO 'zy'@'%' IDENTIFIED BY 'pswd';
FLUSH PRIVILEGES;
MySQL Wiki
Mar 27, 2020#MySQL