How to Create a MySQL Database

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

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Use the MySQL Database Wizard in cPanel

Use the Database Wizard to easily create MySQL databases, users, and assign privileges through a...

How to Manage MySQL Databases in cPanel

Learn to create, manage, and delete MySQL databases and users using cPanel's comprehensive...

How to Use phpMyAdmin for Database Management

Master phpMyAdmin, the web-based interface for managing MySQL and MariaDB databases with advanced...

How to Configure Remote Database Access in cPanel

Enable remote database access to allow external servers and applications to connect to your MySQL...