2.6.1.7. Temporary access to specific database

Occasionally, it may be necessary to grant a third party (such as a site developer or an external specialist) temporary access to a specific database.

1. Create a new user for the database you want to grant access to.
2. Credentials for connecting to the database under this user (host, database name, username, and password) should be provided to the person for whom the access was created.
3. If MySQL access restrictions are enabled, add the IP address of the user you want to grant access to the allowed list.

With the connection details, a third party can connect to the database using any MySQL client, such as phpMyAdmin or HeidiSQL.

1. Delete the user you created or change their password.
2. If MySQL access restrictions are enabled, remove the IP address of the user who was granted access from the allowed list. If access restrictions are disabled, we recommend enabling them.