Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com

How to Create a MySQL Database Print

  • 0

Create MySQL databases for your applications like WordPress, Joomla, or custom scripts.

Creating a Database

1. Log into cPanel
2. Find "MySQL Databases" in the Databases section
3. Click on it
4. Under "Create New Database":
• Enter database name
• Click "Create Database"

Creating a Database User

1. Scroll to "MySQL Users"
2. Enter username and password
3. Click "Create User"

Adding User to Database

1. Scroll to "Add User to Database"
2. Select user from dropdown
3. Select database from dropdown
4. Click "Add"
5. Select privileges (usually "All Privileges")
6. Click "Make Changes"

Database Connection Details

For your applications, use:
Database Host: localhost
Database Name: cpanelusername_dbname
Username: cpanelusername_username
Password: The password you created

Managing Databases

Use phpMyAdmin to:
• Import/export data
• Run SQL queries
• Manage tables
• View database structure


Was this answer helpful?

« Back

Powered by WHMCompleteSolution