- Log in to cPanel and open Manage My Databases (or use the Database Wizard).
- Create a new database. Its name will start with your cPanel username, for example
user_shop. - Under MySQL Users, create a user with a strong password.
- Under Add User To Database, select the user and the database, and give it All Privileges.
In your application, use localhost as the database host. To import or export data, use phpMyAdmin in cPanel.