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