Our website developer has not provided us the main Admin ID and Password. so hardly after reading some posts now, I found the admin_user file in the database.
You can try following sql query
UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxYourNewPassword', 256), ':xxxxxxx:1') WHERE username = 'admin';
xxxxxxx as it is in the query.
Alternatively, you can try the command
For more details on using this command go through https://devdocs.magento.com/guides/v2.2/install-gde/install/cli/install-cli-subcommands-admin.html
no, because the password is hashed.
You can update the password by clicking on sql in the top and executing the following sql command:
UPDATE admin_user SET `password` = md5('YOUR_NEW_PASSWORD'), is_active = 1 WHERE `username` = 'YOUR_ADMIN_USERNAME';
You should change your password in the Magento backend afterwards again.