数据库MySQL配置命令详解

create user ‘hag’@‘%’ identified by ‘HagSoft@123
ALTER USER root@localhost IDENTIFIED BY ‘HagSoft@123root用户登录密码
alter user’hag’@‘%’ IDENTIFIED BY ‘HagSoft@123
grant all privileges on . to ‘hag’@‘%’ with grant option;//允许任何东西ip通过hag远程连接账户
grant all privileges on . to ‘hag’@‘localhost’ with grant option;//赋予hag本地账户任何权限
flush privileges;//MySQL修改用户数据和权限后，希望不重启MySQL直接生效生效

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘HagSoft@123’ PASSWORD EXPIRE NEVER;///设置密码永不过期
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘HagSoft@123mysql_native_password
FLUSH PRIVILEGES;

屏蔽
#log-bin=“DESKTOP-QJAJH0D-bin” //binlog相关

添加：

skip-log-bin //binlog相关

log_statements_unsafe_for_binlog=0

event_scheduler = 1 //打开事件调度器

修改my.ini文件后的保存格式为ANSI编码格式。

datadir=C:/ProgramData/MySQL/MySQL Server 8.0\Data