cPanel, How to create a MySQL database on cPanel
MySQL databases on cPanel must be created and managed through the cPanel dashboard. Do not try to create or manage databases through the Linux command line.
Create MySQL Databases with the MySQL Database Wizard
- Login to your cPanel dashboard.
- In the Databases section, locate and click on "MySQL Database Wizard".
- Enter the name you would like your database to have. Your cPanel account name will be prepended to the database name automatically. Click Next Step.
- Enter the database username you would like to create. You can add additional database users after the database is created.
- Click on the Password Generator to have a strong, random password generated for your database user. Click the checkbox to indicate you have saved the password and click "Use Password" to have the 2 password fields filled in. You can also choose to create your own password.
- Click Create User.
- Add the user to the database. Here you can indicate what database privileges this database user should have. Click Next Step to complete the wizard.
From the resulting screen you can choose to add another database, add another database user to your existing databases, return to the MySQL Databases screen or return to the cPanel dashboard.