Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
en:faq:how_to_reset_admin_password [2014/07/26 14:45] – created soloen:faq:how_to_reset_admin_password [2014/07/26 14:53] (current) solo
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>
en/faq/how_to_reset_admin_password.1406385944.txt.gz · Last modified: (external edit)
Recent changes RSS feed Debian Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki