方法一:
登录 mysql
- mysql> set password for user@localhost = password('mypassword');
- eg:
- mysql>set password for zbxuser@localhost = password('zbxpass');
方法二:
登录 mysql, 用 update 语句修改表
- mysql>use mysql;
- mysql>update user set password=password('mypassword') where cluase;
- mysql>flush privileges;
或者
- mysql>update mysql.user set password=password('mypassword') where cluase;
- mysql>flush privileges;
- eg:
- mysql>user mysql;
- mysql>update user set password=password('zbxpass') where user='zbxuser' and host='localhost';
- mysql>flush privileges;
或者
- mysql>update mysql.user set password=password('zbxpass') where user='zbxuser' and host='localhost';
- mysql>flush privileges;
方法三:
用 mysqladmin 命令
mysqladmin -u 用户名 -p 旧密码 password 新密码
- eg:
- # mysqladmin -uzbxuser -pzbxpass password zbxpassnew;
如果忘记 mysql 的 root 用户密码
先停止 mysql 服务
启动服务
mysqld_safe --skip-grant-tables & 跳过安全检查, 并在后台执行
- mysql -u root mysql
- mysql>update user set password=password('root123') where user='root';
- mysql>flush privileges;
来源: http://www.bubuko.com/infodetail-2765067.html