Skip to main content

How to Create a MySQL Database and User With Database Wizard

You can create a MySQL database and a corresponding database user simultaneously using the Database Wizard in cPanel. This process ensures that the user is correctly assigned to the database with the appropriate permissions in one step.

You can create a MySQL database and a corresponding database user simultaneously using the Database Wizard in cPanel. This process ensures that the user is correctly assigned to the database with the appropriate permissions in one step.

Before you begin

You will need:

  • A cPanel account with the ability to manage databases.

  • A chosen name for the database.

  • A chosen username for the database user.

  • A secure password for the database user.

Create a database and user using the Wizard

  1. Log in to your cPanel account.

  2. Locate the Databases section and select MySQL® Database Wizard.

  3. Enter a name for the new database.

  4. Select the desired database name from the list.

  5. Enter a username for the database user.

  6. Select the desired username from the list.

  7. Enter a password for the database user.

  8. Select the desired privileges for the user (typically All Privileges).

  9. Click Submit.

Confirm the result

  • You will see a success message confirming that the database and user were created.

  • You can verify the new database and user by navigating to MySQL® Databases in cPanel.

  • The database should appear in the list of databases, and the user should appear in the list of database users with the assigned privileges.

Limitations

The Database Wizard is designed to simplify the creation of a single database and a single user. If you need to create multiple users for a single database or assign specific, limited permissions to a user, you should use the MySQL® Databases interface instead.

Did this answer your question?