win scoop mysql相关

win scoop mysql相关

scoop install mysql
scoop update mysql
scoop reset mysql

配置mysql

编辑my.ini

移除已错误安装的mysqld服务

mysqld -remove MySQL

初始化

mysqld --initialize-insecure

mysqld -install

net start mysql

mysql -uroot -p 

mysql密码

一般密码为空或者在C:\Users\ndzy\scoop\persist\mysql\data\hosts.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 -