环境: mysql 5.0.8 方式一: mysql> insert into mysql.user(Host,user,password,ssl_cipher,x509_issuer,x509_subject) values('localhost','system',password('manager'),'','',''); mysql> flush privileges 方式二: mysql> replace into mysql.user(Host,User,password,ssl_cipher,x509_issuer,x509_subject) values('localhost','king1',password('king1'),'','',''); mysql> flush privileges; 方式三: mysql> set password for system@'%' =password('abc'); 这里不需要flush privileges; 方式四: mysql> grant usage on *.* to system@'%' identified by '123'; 这里也不用flush privileges 完成对mysql用户修改密码的操作。