set password for 'username'@'host' = password('123456')
或
mysql> set password for root@localhost = password('123456');
mysql -u root -p123456
set password for 'username'@'host' = password('123456')
或
mysql> set password for root@localhost = password('123456');
mysql -u root -p123456