mysql 相关

windows 安装：

https://blog.csdn.net/ghhgc/article/details/103255934

 

1.跳过鉴权（root密码忘记）  skip-grant-tables

2.降低密码安全级别： set global validate_password_policy=LOW; 

3.更新密码 update mysql.user set authentication_string=password("123456") where user="root";

4.创建用户赋权 ：

grant all privileges on aaDB.* to 'lztest'@'%' IDENTIFIED BY 'lz12346';

create user "lztest"@"%" identified by "lz12346";

5.创建db CREATE DATABASE IF NOT EXISTS testDB DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

6.刷新权限， flush privileges;

7.设置binlog 的过期时间 

　　set global binlog_expire_logs_seconds=60*60*24;

　　flush logs; #手动刷新日志