Create a MySQL database and connect a user to it
Build a database, add a user with a strong password and grant the right privileges.
Most scripts such as shops and forums need a database. You create three things: the database, a user, and the link between them.
Step by step
- Open Manage My Databases in cPanel.
- Under Create New Database type a short name and click Create Database.
- Under MySQL Users add a user and a long random password.
- In Add User To Database choose the user and database, then tick All Privileges.
cPanel adds your account name before both names, for example account_shop. Copy the full names into the installer of your script.
Important: Write the password down when you create it. It is not shown again.
