How to set up a new MySQL database?

How to set up a new MySQL database?

We assume that you have already purchased hosting with cPanel management panel.

If you are faced with choosing a performance-proven hosting, compare our packages.

All descriptions in this guide are based on the Smarthost.pl hosting

To create a new MySQL database, click on the "MySQL databases" button on the cPanel main screen

Then enter the any name of the database that we want to create (field 1) and click the "Create database" button (field 2).

After the database is created, a screen will appear to confirm the successful creation. On this screen, click the "Go back" button to return to the database management screen.

To create a new user in the database management panel, enter the desired name in the "User name" field (field 1).

Fill in the "Password" field with the selected password, or click the "Generate password" button. As a result, we will automatically generate a secure password, which we can then copy.

After filling in these fields, click the "Create user" button (field 2).

The next step is to assign the created user to the appropriate database. We do it in the database management panel under "Add user to database".

In the "User" field, select the user to which we want to assign to the database, and in the "Database" field, select the database to which the user is to be assigned. Then click the "Add" button.

In the next step of assigning a user to the database, select the permissions he should have. We do it by selecting the appropriate checkbox. After selecting the desired permissions, click the "Make changes" button.

In the database control panel, in the "Current databases" section, we can see the databases created by us and the users who are assigned to them.

Create a free test account on the Smarthost.eu server and check how a properly

configured mySQL database works: