[mysql]修改用户密码

来源:互联网 发布:淘宝手机流量互刷 编辑:程序博客网 时间:2024/06/02 07:08
### 方法1# mysqladmin -uroot -h hostname password 'new-password' -p;### 方法2mysql> SET PASSWORD FOR 'user'@'host'=PASSWORD('new-password');### 方法3mysql> UPDATE mysql.user SET PASSWORD=PASSWORD('new-password') WHERE condition;### 方法4mysql> GRANT PRIVILEGES ON *.* TO 'user'@'host' IDENTIFIED BY 'pass-world';
原创粉丝点击