How to reset admin password

When we lost password for a user, we can login as admin or teamadmin to reset their password, but when we lost password for admin, we have to reset this in mysql database. You need to know mysql root password, if you don't, try check /etc/astercc.conf

[root@astercc_cn ~]# head /etc/astercc.conf

dbtype = mysql
dbhost =
dbname = astercc10
dbport = 3306
username = root
password = passw0rd
prefix = cc10_

your mysql root password is passw0rd, connect to astercc commercial database with the user and password above

[root@astercc_cn ~]# mysql -uroot -ppassw0rd astercc10
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 276197
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


then you can update your new password with the following command

mysql> update cc10_accounts set password=md5('newpassword') where username='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

en/faq/how_to_reset_admin_password.txt · Last modified: 2017/12/12 03:05 (external edit)
Recent changes RSS feed Debian Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki