This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| en:faq:how_to_reset_admin_password [2014/07/26 14:45] – created solo | en:faq:how_to_reset_admin_password [2014/07/26 14:53] (current) – solo | ||
|---|---|---|---|
| Line 14: | Line 14: | ||
| </ | </ | ||
| - | your mysql root password is passw0rd | + | 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. | ||
| + | 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 | ||
| + | owners. | ||
| + | |||
| + | Type ' | ||
| + | |||
| + | mysql> | ||
| + | </ | ||
| + | |||
| + | then you can update your new password with the following command | ||
| + | < | ||
| + | mysql> update cc10_accounts set password=md5(' | ||
| + | Query OK, 0 rows affected (0.00 sec) | ||
| + | Rows matched: 1 Changed: 0 Warnings: 0 | ||
| + | </ | ||