Mysql修改密码的三种方式

1. mysqladmin -u ‘username’ -h ‘hostname’ password ‘new_password’ -p
   eg: mysqladmin -ujerry -hlocalhost password ‘123456’ -p
   将jerry的密码修改为123456, 这种方法需要输入旧密码

2. set password for ‘username’@‘hostname’=password(‘new_password’)
   eg: set password for ‘jerry’@’%’=password(‘123456’);

3. update mysql.user set authentication_string=password(‘12345’) where user = ‘jqerry’ and host=’%’;