Connect to the PhpMyAdmin web interface with mysql-user rights - root. By default, the access address in PhpMyAdmin is as follows:

http://ip-адрес-сервера/phpmyadmin  

After logging in, press the Import button.

file

In the form that appears, click Select File and specify the path to our sql-file with the database dump.

file

After specifying the file, choose the desired encoding and click the OK button at the bottom of the page.

This will load the database from the specified file. When the download is complete, the database will appear in the list of other existing databases on the server.

file

Now let's create a user for this base. To do this, click on the name of our database, then click on Privileges in the top navigation bar and in the form that appears, click on Add User.

file

In the form that appears, fill in the fields under Account Information

file

Check that under Database for user and make sure the checkbox in front of Give all privileges to database is checked.

If necessary, you can grant global privileges to this user.

file

After specifying the necessary rights, click the Forward button at the bottom of the page, as a result of which the created user will appear in the list of those having access rights to the given database.

file