命令行修改MySQL密码

mysql -uroot -proot

set password for root@localhost = password('123456');

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

set password for root@'%' = password('123456');