- 论坛徽章:
- 0
|
我在LINUX平台下搭建了Extmail邮件系统,后台数据库为MySQL,想问下,如何在命令提示符中修改用户密码。我在Mysql中修改过以后,用户就没法登陆web界面了。
mysql -u root -pxxxxx
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use extmail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update mailbox set password=password('test'),clearpwd=password('test') where username='sales@xxxxcom';
Query OK, 1 row affected (0.14 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
我觉得web管理方式还麻烦,用命令管理方式好一点,有谁知道提点一下,先在这儿谢谢了各位!! |
|