Creating a Database User on Hosting

Let's assume you have created a database. However, this is not enough for your program to be able to connect to this database. The point is that only database users associated with this database can connect to it.

Each database must have one or more users associated with it. In this case, our program will be able to connect to the specified database under the specified user.

Different users are needed to differentiate access rights to the database. Technically, this means that users will be able to execute not all SQL queries, but only those that are permitted for a given user.

Let's create a new user and link them to our database. To do this, in the hosting control panel, find where new database users are created. As a rule, this is done on the same page where databases are created.

You need to perform two steps.

Step 1. Create a new user and set a login and password for them.

Step 2. Link your user to your database.

At the moment of linking, you will be offered to choose the user's privileges for this database. For security, we should grant minimum privileges. As a rule, these are SELECT, INSERT, UPDATE, and DELETE.