user mysqlupdate mysql.user set authentication_string = password("你的密码") where user="用户名"flush privileges
示例:
mysql> use mysql;mysql> update mysql.user set authentication_string = password("123") where user="root";mysql> flush privileges;