Create a MySQL database in cPanel

1. Create the database

In cPanel open MySQL Databases and create a new DB. The user_ prefix is added automatically.

2. Create user

On the same screen create a user with a strong password.

3. Assign permissions

Add the user to the DB and tick ALL PRIVILEGES (or only the ones you need).

4. Connection

Host: localhost
Port: 3306
DB: user_mydb
User: user_myuser