win10下mysql5.7.xx版本下载
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.28-winx64.zip
https://dev.mysql.com/downloads/file/?id=489602
https://dev.mysql.com/downloads/mysql
安装说明:
https://www.cnblogs.com/qjoanven/p/7898006.html

下载完添加文件 my.ini 到mysql目录,配置的时候要用/不要用默认的\,然后用管理员权限运行
mysqld --initialize --user=mysql --console

改mysql密码

mysql -u root -p
SET PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;

忘记密码https://blog.csdn.net/weixin_43142423/article/details/85072342
加用户:

mysql -uroot -proot
use mysql
create user 'admin'@'%' identified by '123456';
grant all privileges on *.* to 'admin'@'%' identified by '123456';

标签: mysql

添加新评论