Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Accidentally Lost Admin Pass - Can't Reset Rate Topic   - - - - -

 

Posted 20 April 2021 - 09:32 PM #1

Dear Community, 

Problem explenation: Fresh install of CS Cart on MariaDB and Nginx, after successful installation I tried to set up properly emails that I couldn't verify on sending/receiving (This is for reseting password over email), I logged off from the Administration Panel of CS cart and when I tried to login, my keychain said something for changing password, which I did not. Nevertheless the password I used for the installation and admin panel was not working anymore. 

With a lot of google search based on this post here: https://forum.cs-car...ass-cant-reset/

 

And some guidance tutorial of this : https://www.guru99.c...install.html#10

 

I have managed to get through ssh connection via root and enter to SQL

mysql

I did receive this quotes

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1040
Server version: 10.1.47-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]>

by entering the command 

SHOW DATABASES;
MariaDB [(none)]> SHOW TABLES;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> SHOW DATABASES;
+-----------------------+
| Database              |
+-----------------------+
| Example_cscart        |
|                       |
| information_schema    |
| mysql                 |
| performance_schema    |
|                       |
|                       |
+-----------------------+
7 rows in set (0.00 sec)

MariaDB [(none)]>

"lets say the name of Database is "Example_cscart"

 

Then I type:

USE Example_cscart

That bring me inside of the column list "cscart_users"

DESC cscart_users;

that provide this information

MariaDB [XXXetech_XXcart]> DESC cscart_users;
+---------------------------+-----------------------+------+-----+---------+----------------+
| Field                     | Type                  | Null | Key | Default | Extra          |
+---------------------------+-----------------------+------+-----+---------+----------------+
| user_id                   | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| status                    | char(1)               | NO   |     | A       |                |
| user_type                 | char(1)               | NO   |     | C       |                |
| user_login                | varchar(255)          | NO   | MUL |         |                |
| referer                   | varchar(255)          | NO   |     |         |                |
| is_root                   | char(1)               | NO   |     | N       |                |
| company_id                | int(11) unsigned      | NO   |     | 0       |                |
| last_login                | int(11) unsigned      | NO   |     | 0       |                |
| timestamp                 | int(11) unsigned      | NO   |     | 0       |                |
| password                  | varchar(255)          | NO   |     |         |                |
| salt                      | varchar(10)           | NO   |     |         |                |
| firstname                 | varchar(128)          | NO   | MUL |         |                |
| lastname                  | varchar(128)          | NO   |     |         |                |
| company                   | varchar(255)          | NO   |     |         |                |
| email                     | varchar(128)          | NO   | MUL |         |                |
| phone                     | varchar(128)          | NO   |     |         |                |
| fax                       | varchar(128)          | NO   |     |         |                |
| url                       | varchar(128)          | NO   |     |         |                |
| tax_exempt                | char(1)               | NO   |     | N       |                |
| lang_code                 | char(2)               | NO   |     |         |                |
| birthday                  | int(11)               | NO   |     | 0       |                |
| purchase_timestamp_from   | int(11)               | NO   |     | 0       |                |
| purchase_timestamp_to     | int(11)               | NO   |     | 0       |                |
| responsible_email         | varchar(80)           | NO   |     |         |                |
| password_change_timestamp | int(11) unsigned      | NO   |     | 0       |                |
| api_key                   | varchar(255)          | NO   |     |         |                |
| janrain_identifier        | varchar(32)           | NO   |     |         |                |
+---------------------------+-----------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)

How can I change the admin password from via cmd commands so I can get access to Admin panel again?