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-cart.com/topic/39871-accidentally-changed-admin-pass-cant-reset/
And some guidance tutorial of this : https://www.guru99.com/mariadb-tutorial-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.04Copyright (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?