How do I create a MySQL user account with limited privileges?

Procédure

Why create a MySQL user with limited privileges?

Creating a MySQL user with limited access allows you to limit the actions that can be carried out by this user account.

In effect, you can prohibit the user from creating, deleting or modifying a table in the databases to which they have access. This can be useful for limiting the user's possible actions to what is strictly necessary, and thus limiting the damage in the event of an intrusion.

What will you need to create a MySQL user with limited access?

To create a MySQL user with limited access, you need access to your cPanel web hosting space. You can connect to your cPanel interface via your LWS customer area or by using the login details you received by email when you subscribed to your package.

How do I create a MySQL user with limited access?

1. Connect to your cPanel web hosting space, click on"MySQL databases" in the"Databases" section.

2. Insert a new MySQL database and click on"Create a database".

3. Click on the"Back" tab to go on to the next step:

4. Go to the"MySQL User" section to create a new database user. Click on the"Create a user" button to continue.

5. Link a user to your database and click on the "Add" button.

6. You can now define MySQL privileges for the user you have just linked to your database.

The privileges that can be granted are as follows:

• ALTER: allows you to modify table structures.
• ALTER ROUTINE: allows you to modify or delete stored routines (procedures and functions).
• CREATE: used to create new databases and tables
• CREATE ROUTINE: this is necessary to create stored routines.
• CREATE TEMPORARY TABLE: used to create temporary tables.
• DELETE: allows you to delete table rows from a database.
• DROP: allows you to delete databases and tables.
• EVENT: is required to create, modify, delete or display events for the event scheduler.
• EXECUTE: is required to execute stored routines (procedures and functions).
• INDEX: allows you to create and delete indexes.
• INSERT: allows you to insert rows in database tables.
• LOCK TABLES: lets you lock tables. This prevents other sessions from reading the table.
• SELECT: allows you to select rows from tables in a database.

Conclusion

You are now able to create a PHPMyAdmin with limited database access via your cPanel web hosting space with LWS.

Don't hesitate to share your questions or comments!

How do I change the privileges of the Database User?

You can change the privileges of the user of the database concerned at any time. To do this, go to the"Add a user to the database" section and link the user back to the database. This will allow you to access the configuration of the user's privileges.