How to Create a MySQL Database Print

Creating a MySQL Database in cPanel

Many web applications (like WordPress, Joomla, or custom PHP apps) require a MySQL database. Here's how to create one on your Fantastic NZ Hosting account.

Step-by-Step Instructions

1. Log into cPanel via your client area.
2. Scroll to the Databases section and click MySQL Databases.
3. Create a Database:
   • Enter a name for your database in the "New Database" field.
   • Click Create Database.
4. Create a Database User:
   • Scroll down to "MySQL Users".
   • Enter a username and a strong password (use the password generator for a secure one).
   • Click Create User.
5. Add the User to the Database:
   • Scroll to "Add User To Database".
   • Select the user and database you just created.
   • Click Add.
   • On the privileges screen, tick ALL PRIVILEGES and click Make Changes.

Important Notes

• Your full database name and username will be prefixed with your cPanel username (e.g., cpuser_dbname).
• The database hostname is usually localhost when connecting from your own hosting account.
• Keep your database credentials safe — you'll need them when configuring your web application.

Managing Your Database

To manage your database tables and data, use phpMyAdmin in cPanel (under the Databases section). phpMyAdmin provides a web-based interface for browsing, querying, and modifying your database.

If you need assistance, open a support ticket and we'll help you out.