Creating a MySQL Database

In cPanel

1. Go to MySQL Databases
2. Enter database name > Create Database
3. Enter username and password > Create User
4. Add user to database > Select ALL PRIVILEGES > Make Changes

Connection Details

Use these in your application:

• Host: localhost
• Database: cpanelusername_dbname
• Username: cpanelusername_username
• Password: the password you set

phpMyAdmin

To manage your database (view tables, run queries):

1. cPanel > phpMyAdmin
2. Select your database from the left panel
3. Browse, search, import, or export data

Import Database

1. phpMyAdmin > Select database
2. Click Import tab
3. Choose .sql file
4. Click Go

Tips

• Always backup before making changes
• Database names are prefixed with your cPanel username
• Maximum database size depends on your hosting plan