mysql 修改密码

官网链接
新建个mysql-init.txt文件

1.文件的内容如下:

MySQL 5.7.6 and later:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

MySQL 5.7.5 and earlier:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

2 执行一下命令
windows:

C:\> cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"C:\> mysqld --init-file=C:\\mysql-init.txt**或者**C:\> mysqld --defaults-file="C:\\ProgramData\\MySQL\\MySQL Server 5.7\\my.ini" --init-file=C:\\mysql-init.txt**授权**UPDATE mysql.user    SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N'    WHERE User = 'root' AND Host = 'localhost';FLUSH PRIVILEGES;

linux

shell> mysqld --init-file=/home/me/mysql-init.txt &

UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass')WHERE User = 'root' AND Host = 'localhost';FLUSH PRIVILEGES;

注意具体实现请参考官网:官网链接