Differences
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] solo created |
en:faq:how_to_reset_admin_password [2017/12/12 03:05] (current) |
||
|---|---|---|---|
| Line 14: | Line 14: | ||
| </code> | </code> | ||
| - | your mysql root password is passw0rd | + | your mysql root password is passw0rd, connect to astercc commercial database with the user and password above |
| + | <code> | ||
| + | [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 | ||
| + | owners. | ||
| + | |||
| + | Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. | ||
| + | |||
| + | mysql> | ||
| + | </code> | ||
| + | |||
| + | then you can update your new password with the following command | ||
| + | <code> | ||
| + | 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 | ||
| + | </code> | ||
