mysql5.7 windows 安装

执行命令：
mysqld --initialize --user=mysql --console
最后有密码

执行命令：
mysqld --install MySQL


net start mysql

登录mysql



修改密码
set password for root@localhost = password('123456');



开启任务计划
set global event_scheduler =1;

show variables like '%sche%';

开启远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '12345678' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY  '12345678' WITH GRANT OPTION;
FLUSH PRIVILEGES