初步安装教程 :https://www.cnblogs.com/cyl048/p/11305642.html
安装时可能需要使用的命令:
进入到mysql安装包的bin目录下:cd /d D:\Program Files (x86)\mysql-8.0.17-winx64\bin
后面会遇到的问题
1.密码的修改
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
FLUSH PRIVILEGES;
2.The user specified as a definer ('root'@'%') does not exist 此种报错主要是针对访问视图文件引起的(没有权限)
update mysql.user set host='%' where user='root';
flush privileges;
3. timestamp 类型执行老备份数据执行不下去,需设置 explicit_defaults_for_timestamp 参数的问题
set global sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION';
set global log_bin_trust_function_creators=1;