MYSQL修改用户密码

来源：互联网发布：淘宝代理销售编辑：程序博客网时间：2024/06/08 03:59
第一种方法  将root的密码改为djg345  # mysqladmin -uroot -p123123 password djg345  以下方法需在mysql>提示符下操作  第二种方法 更改user01密码为user01pwd  mysql> SET PASSWORD FOR user01=PASSWORD("user01pwd");  mysql> show grants for test;+--------------------------------------------------------------------------------------------------------------------------------+| Grants for test@%                                                                                                              |+--------------------------------------------------------------------------------------------------------------------------------+| GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |+--------------------------------------------------------------------------------------------------------------------------------+1 row in set (0.00 sec)1.修改test用户密码为147258[mysql@master ~]$ mysqladmin -u test -p password 147258Enter password:   --这里输入的是原密码[mysql@master ~]$ [mysql@master ~]$ mysql -utest -p1472582.第2种方式:--修改test用户密码为999999mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> UPDATE user SET password=PASSWORD('999999') WHERE user='test';Query OK, 2 rows affected (0.00 sec)Rows matched: 2  Changed: 2  Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql>
0 0