How to use MySQL® Database Wizard

The MySQL Database Wizard in cPanel lets you create a database, add a user, and assign privileges in one guided flow. This article walks you through each step so you can complete the setup quickly and correctly.

Step 1: Access the MySQL Database Wizard in cPanel

1. Log in to your cPanel account.
2. Scroll to the Databases section.
3. Click MySQL Database Wizard.

Step 2: Create the database

2. In the New Database field, enter a descriptive name for your database. cPanel automatically adds your account username as a prefix (for example, accountname_appdb).
3. Click Next Step. A confirmation appears showing that the database has been created.

Step 3: Create the database user

1. In the Username field, type a short, descriptive user name. The account prefix is added automatically.
2. Enter a strong password in both Password fields, or click Password Generator to create one.
3. Click Create User. You will see a notice that the user has been added.

Step 4: Assign privileges to the user

1. On the Set Privileges screen, check All Privileges unless your application needs specific permissions only.
2. Click Next Step to apply the selected privileges.

Step 5: Finish and verify

1. The Complete the task screen confirms that the database and user are linked.
2. Click Return Home or Return to MySQL Databases.
3. Under Current Databases, check that the new database appears with the correct user assigned.
4. Copy the database name, username, and password for your application’s configuration file (for example, wp-config.php in WordPress).

Best practices

1.Strong passwords. Use complex passwords to help prevent unauthorized access.
2. Descriptive names. Choose names that make it easy to identify each database and user later.
3. Credential storage. Keep your database details in a secure password manager.
4. Remove unused databases. Deleting old databases reduces clutter and potential security risks.
5. Regular backups. Back up your databases before making major changes or updates.

This guide shows how to use the MySQL Database Wizard to set up a database and user in just a few clicks. If you have questions or run into problems, contact our Support Team for assistance.