mysql命令行设置密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

sudo systemctl stop mysql

sudo mysqld_safe --skip-grant-tables &

mysql -u root

mysql> UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> EXIT;

sudo systemctl start mysql