How to Create, Manage, and Setup MySQL Databases in cPanel
At Vivint Host, we use MariaDB, a high-performance, reliable drop-in replacement for MySQL. Developed by one of MySQL’s original creators, MariaDB ensures better speed and stability while maintaining full compatibility with MySQL-based applications like WordPress.
Overview of Database Tools in cPanel
cPanel makes database management simple with an intuitive interface. Under the "Databases" section, you’ll find essential tools:
phpMyAdmin: Best suited for advanced users. This tool lets you perform detailed database operations like editing tables, running queries, and exporting data. Avoid this unless you're familiar with database structures.
MySQL® Databases: Here, you can create and delete databases, manage users, and assign privileges. It's ideal for general day-to-day use.
MySQL® Database Wizard: A beginner-friendly tool that walks you through creating a database, user, and permission settings-all in one place.
Remote MySQL: Allows external servers to access your database. Use this only when absolutely necessary and consult Vivint Host support to enable it safely. For security, this feature is best suited for VPS or dedicated hosting users.
How to Create a MySQL Database
If you're installing apps like WordPress, we recommend using Softaculous within cPanel. It will automatically handle the database setup for you. But if your app requires manual database configuration, follow these steps:
Step 1: Create a Database
- Go to cPanel → MySQL Database Wizard.
- Enter a unique database name (max 54 characters).
Step 2: Create a Database User
- Username: Choose a recognizable name (e.g., mywebsite_user).
- Password: Generate a strong password using the built-in tool. Never proceed with a weak password.
Step 3: Assign User Permissions
- For most applications, select "All Privileges."
- Check your software’s documentation if unsure.
Step 4: Complete Setup
Your database is now ready! Use the credentials when configuring your application.
Pro Tip: If you’re installing WordPress, Drupal, or similar apps, use Softaculous Apps Installer (in cPanel) for automatic database setup.
How to Manage Existing Databases
Click MySQL® Databases from your cPanel dashboard to:
Create a New Database
While possible here, beginners should use the MySQL Wizard for proper user setup.
Modify Databases
- Check Database: If your site shows database errors, run this tool to scan for corruption.
- Repair Database: Fixes issues (mainly for MyISAM tables). Always back up first!
Current Databases
- View all databases, their sizes, and linked users.
- Warning: Deleting or renaming a database can break your website.
User Management
- Add/Modify Users: Create new users or reset passwords.
- Assign Users to Databases: Link users to specific databases.
Caution: Incorrect changes here can disrupt your website. Only proceed if you’re confident.
Final Thoughts
Setting up and managing MySQL databases in cPanel is straightforward with Vivint Host’s high-performance SSD cloud hosting. Whether you’re a beginner or an advanced user, our 24/7 expert support is here to help.
Need assistance? Contact Vivint Host Support anytime.