mysql数据库为用户设置密码

方法一

use mysql insert into user (host,user,password) values ('%','user_name','your password'); 
flush privileges;

方法二

set password for user_name = password("your password")

方法三

创建一个用户时直接设置密码

grant all on *.* to mailto:user_name@ identified by "your password";

方法四

mysqladmin -u root password "your password"