2.7.8. Temporary access to a specific database

Sometimes it may be necessary to provide a third party (for example, a website developer or a third-party specialized specialist) with temporary access to a specific database.

To grant access to a specific database, do the following:

1. Create a new user for the database to be granted access.
2. Data to connect to the database under this user (host, database name, login and password) provide the person for whom access was created.
3. If limiting access to MySQL is enabled, add the IP of the person to whom access is granted to list of allowed.

Having the data to connect, the third party will be able to connect to the database using any MySQL client, for example phpMyAdmin or HeidiSQL.

To close access, do the following:

1. Delete the created user or change his password.
2. If limiting access to MySQL is enabled, remove the IP of the person to whom access was granted from list of allowed... If access restriction is disabled, it is recommended to enable it.