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.
In the form that appears, click Select File and specify the path to our sql-file with the database dump.
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.
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.
In the form that appears, fill in the fields under Account Information
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.
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.
