mysql8.0常用命令

开启外网访问

CREATE USER 'root'@'%' IDENTIFIED BY '你的密码'; -- 这一步执行失败没关系

GRANT ALL ON . TO 'root'@'%';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

FLUSH PRIVILEGES;

设置大小写忽略

set global lower_case_table_names = 1

设置最大导入

set global max_allowed_packet = 210241024*10

设置服务器编码

set global character-set-server=utf8mb4

等待关闭连接的时间

set global wait-timeout = 2880000

设置密码强度

set global validate_password_policy=LOW;

设置密码长度

set global validate_password_length=6;

查看默认密码

grep 'temporary password' /var/log/mysqld.log

centos下启动和重启

systemctl restart mysqld
systemctl enable mysqld