win scoop mysql相关

scoop install mysql
scoop update mysql
scoop reset mysql

编辑my.ini

mysqld -remove MySQL

mysqld --initialize-insecure

mysqld -install

net start mysql

mysql -uroot -p 

一般密码为空或者在C:Usersndzyscooppersistmysqldatahosts.err找密码

更改加密方式ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;

更改密码ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘新密码’;

刷新权限

FLUSH PRIVILEGES;

net start mysql mysql -uroot -p

use mysql;

update user set host = ‘%’ where user = ‘root’;

select host, user from user;

FLUSH PRIVILEGES;

s