Tip: Start typing in the input box for immediate search results.

< Back
Print

MySQL Database Wizard – cPanel

Learn how to Use MySQL Database Wizard in cPanel. This wizard guides you through the setup of a MySQL® database, user accounts, and user privileges step by step.


Video tutorial – Use MySQL Database Wizard in cPanel


Step-by-step tutorial – Use MySQL Database Wizard in cPanel

  1. MySQL Database Wizard

    Login to cPanel.
    Tutorial: login from the Client Area or the direct link.

    Find the Databases section and click the MySQL Database Wizard link.

    Extilum cPanel - databases -  MySQL wizard

  2. Srep 1: Create A Database

    New Database
    Type a name for the database.
    A database name may contain a maximum of 64 characters.
    Click the Next Step button.

    Extilum cPanel - databases -  MySQL wizard

  3. Step 2: Create Database Users

    Username
    – type the MySQL username.
    Password
    – type the user password.
    Type a secure password in the Password text box. It must contain uppercase and lowercase letters, numbers, and symbols. The system will evaluate the password that you enter on a scale of 100. A weak password has 0 value, while a very secure password has 100 value. Or you can click Password Generator to let the system create a secure password for you. 
    Password (Again)
    – retype the user password.
    Click the Create User button.

    Extilum cPanel - databases -  MySQL wizard

  4. Step 3: Add user to database.

    Select the privileges you want to grant the user or click ALL PRIVILEGES to give the user all permissions to the database.

    Extilum cPanel - databases -  MySQL wizard

  5. Click the Make Changes button.

    Extilum cPanel - databases -  MySQL wizard

  6. Step 4: Complete the Task

    Get the success message.
    The process is finished.

Was this article helpful?
3.8 out of 5 stars

2 ratings

5 Stars 50%
4 Stars 0%
3 Stars 0%
2 Stars 50%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.