Create MySQL Database and User via cPanel

The MySQL Database Wizard is a useful tool that allows you to create a MySQL database and user with ease. If you are about to install a PHP-MySQL application and you do not have a database already created for it, this tool will guide you through all the steps needed to create one.

To access the MySQL database Wizard, please scroll to the Databases section in your cPanel and click on MySQL Database Wizard.

During the first step of the database creation you will need to input the desired database name. Be advised that all cPanel databases are created with a prefix. This prefix represent your cPanel username and ensures your database name will be unique on the shared hosting environment even if you use a general database name.

The part before the underscore is your cPanel username and the part after it is what you assign. The two combined create the database name. You should take this under consideration when you configure your application or script to make sure that the correct settings are applied.

When you have the desired database name set, click Next Step. During the next step of the process you will need to input your database username and password. This user will be the only one able to access the database. The username also follows the rule that its name is generated with a prefix, containing your cPanel username. You can use the password generator on the page (recommended) or input your own strong password.

To create the user click Create User.

The final step of the process is assigning privileges to your database user. Database user privileges sets the database actions that can be performed by this specific user. If you are about to setup and configure an application we recommend you apply All Privileges to make sure that your script works properly.

When you are ready, click on Next Step at the bottom of the page. This will complete the process and you can now use your database name, user and password in your application.