win10下mysql5.7.28版本下载
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';