How Do I Create a MySQL Database in cPanel? Print

  • Create Database, MySQL, Database, WordPress Database, phpMyAdmin
  • 0

Most dynamic websites (like WordPress) require a MySQL database to store content, user information, and settings. You must create a database before installing a CMS.

Step-by-Step Guide:

  1. Log in to your cPanel.

  2. In the "Databases" section, click on "MySQL Databases."

  3. Create a Database:

    • Under "Create New Database," enter a name for your database.

    • Click "Create Database."

  4. Create a User:

    • Scroll down to "MySQL Users."

    • Enter a username and a strong password (use the "Password Generator").

    • Click "Create User."

  5. Add User to Database:

    • Scroll down to "Add User to Database."

    • Select the User and Database you just created from the dropdown menus.

    • Click "Add."

  6. Set Privileges:

    • A new window will appear asking for privileges. For a standard website, check "ALL PRIVILEGES."

    • Click "Make Changes."

You now have a database ready to use. You can manage it later by clicking the "phpMyAdmin" button in cPanel.


Was this answer helpful?

« Back

Powered by WHMCompleteSolution