How to bring live site on localhost

If you have a live site and Database DP following Steps to make it work on localhost

1. in you db.sql file find your base URL (secure and unsecured) using ctrl + f

change them something like that

Secure `https://www.example.com` to `https://localhost/example` 

insecure `http://www.example.com` to `http://localhost/example` 

Import you SQL dump in a local empty database

2. Copy all content from live site to var/www/html/example Now goto app/etc/env.php

change following data with your local credentials

'db' => [
        'table_prefix' => '',
        'connection' => [
            'default' => [
                'host' => 'localhost',
                'dbname' => 'magento235',
                'username' => 'root',
                'password' => 'admin123',
                'active' => '1',
                'driver_options' => [

                ]
            ]
        ]
    ],

3. Run following commands in example folder

php bin/magento setup:upgrade
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy -f
php bin/magento cache:flush
chmod -R 777 var/ pub/ generated/

I will work Fine I have migrated a site Few days ago with same steps

Happy coding

With reference to this link.

Can you please do this process in mysql.

Run $ n98-magerun2 admin:user:create --admin-user=dev_admin --admin-password=dev123456 [email protected] --admin-firstname=DEV --admin-lastname=dev123456

And check it will working.

Happy Coding.