Error when transferring joomla to open server, what should I do?

Question

Joomla

Hello everyone,
1. Transferred joomla files from hosting to your PC.
2. Installed open server, configured php and mysql version, as on hosting.
3.Imported the database, registered the connection to the database in configuration.php.
4.Does not load the main page, error 500.
If you register a connection to the hosting database in configuration.php, then everything works ... what should I do?
This is the hosting database:

This is the open server database:

Answer 1

Common mistakes:
username is copied from the vendor, but such user is not created locally.
connect via root without a password.
Correct option:
Use mysql user with mysql password to connect

Answer 2

To transfer a site to joomla, there is a rule to use akeeba backup.
As a result, you get a step-by-step interface for installing joomla in a new location.
If you solve the problem you have already created, then replace the .htaccess file with the default file, it lies in the root of the site as the htaccess.txt file, check the path to the $tmp_path and $log_path folder in configuration.php, check $live_site=''; -should look like this.
Make sure the connection to the database is configured correctly

public $host = 'localhost';  //на опенсервере хост по умолчанию
public $db = 'имя_базы';
public $dbprefix = 'префикс_';
...
public $user = 'имя_пользователя_базы';
...
public $password = 'пароль';