Creating a MySQL Database in cPanel
Most websites running on a HostGator Australia hosting account will eventually need a MySQL database to store posts, user accounts, product catalogues, or forum data. Whether you are setting up WordPress in Melbourne, launching a small WooCommerce shop in Brisbane, or building a custom application for clients in Perth, the process of creating the database itself happens inside cPanel. The interface looks busy at first, but once you know where the tools live, the workflow is short and repeatable. This guide walks through every screen you will see, the choices that actually matter, and the small mistakes that tend to slow down first-time users.
The Australian context matters more than it might seem. Local privacy law under the Privacy Act 1988 expects you to handle stored data carefully, so giving your database a clear name and a strong user password from the start is a good habit rather than a cosmetic detail. Many Australian developers also work in Australian Eastern time, so logging into cPanel at 9 pm AEDT and still being able to file a support ticket that is answered overnight can be a real advantage over hosting in regions with limited overlap.
Where MySQL Lives Inside cPanel
cPanel groups its features into sections such as Files, Email, Domains, and Databases. The block you need is labelled "Databases" and contains several icons that look similar at first glance. There is "Database Wizard", which is the simplest option, "MySQL Databases", which exposes every setting, "phpMyAdmin", which lets you run SQL queries directly, and "Remote MySQL" for connecting apps hosted elsewhere.
A quick comparison of the main methods helps you pick the right one for the job.
| Method | Best for | Skill level | Key advantage |
|---|---|---|---|
| Database Wizard | First-time users | Beginner | Walks you through each step |
| MySQL Databases | Repeat setup | Intermediate | Full control over names and users |
| phpMyAdmin | Importing existing dumps | Advanced | Direct SQL execution |
| Remote MySQL | External app servers | Advanced | Connects apps on other hosts |
Most Australian small business owners and bloggers will use the first two options. Developers importing a site from another host often open phpMyAdmin straight away to upload an SQL file rather than recreating tables by hand. The Database Wizard hides a few advanced settings, so anyone planning to run more than one site on a single cPanel account usually moves on to the manual "MySQL Databases" screen fairly quickly.
Step-by-Step: Building a New Database
Open your browser and sign in to cPanel using the credentials HostGator emailed when you signed up. The address is usually yourdomain.com/cpanel, or you can use the account portal. Once the dashboard loads, scroll down to the Databases group and click "MySQL Databases". This is the screen that gives you the most control and avoids the wizard skipping fields.
The first field is "Create New Database". Type a short prefix followed by an underscore and a descriptive name. cPanel adds a randomised prefix automatically, but adding your own helps when you are running several sites from one account, such as a portfolio site and a small online store for a Sydney client. Keep the name lowercase and avoid spaces. Something like wp_main or shop_orders reads better later in phpMyAdmin than a random string of characters.
Click "Create Database". cPanel confirms the action at the top of the page in a green banner. The database now exists on disk, but it is locked because no user can access it yet. That brings you to the next step.
Adding a User and Connecting It to the Database
Scroll down to "Add New User". Pick a username that follows the same logic as your database name — short, lowercase, and recognisable. The password field has a "Password Generator" button that creates a long random string. Copy it somewhere safe before you click "Create User", because cPanel does not show the password again. If you lose it, you can reset the password later, but any application already using the old one will break until you update its config file.
Now scroll to "Add User to Database". Choose the user you just created from the first dropdown, and pick the database from the second. Click "Add". The next screen asks about privileges. For most websites, ticking "All Privileges" is fine and matches what installers like WordPress expect during setup. If you are building a reporting tool that only needs to read data, choose only "SELECT" to follow the principle of least access, which aligns with the Australian Privacy Principles when handling personal information about customers.
Click "Make Changes" to save. cPanel will refresh and show the user listed under the database with a small modification icon beside it. At this point the database is usable, and you can return to your installer or script and feed it the hostname (always localhost), the full database name, the username, and the password.
Verifying the Connection From Your Application
Before you start installing WordPress or any PHP application, test the connection. Open phpMyAdmin from the same Databases group in cPanel. The left sidebar should list your new database. Click it, then go to the "SQL" tab and run a simple statement such as SELECT NOW();. If the query returns the current time, your database and user are wired correctly.
If you are running WordPress, paste the credentials into wp-config.php and visit the site in another browser tab. A working database connection shows the five-minute install screen. A broken one usually shows "Error establishing a database connection", which almost always means the hostname, database name, username, or password is wrong. Check the cPanel "MySQL Databases" screen again and copy the full prefixed name — the prefix is the most common stumbling block for new Australian customers setting up their first cPanel account.
Australian developers often keep a small staging site on a subdomain such as staging.yourdomain.com.au. Creating a separate database for it, named something like wp_staging, keeps test data out of the live site and makes it easy to drop the staging database later without affecting production.
Troubleshooting Issues Australians Run Into
A few recurring problems show up in HostGator support tickets from Australian customers. The first is timezone drift. PHP and MySQL run on different time zones by default, so timestamps in posts or orders can appear offset by several hours. In cPanel, open "MultiPHP INI Editor" or use phpMyAdmin to run SET time_zone = '+10:00'; for AEDT or '+09:30' for ACST. Doing this once at setup avoids confusing logs later when you compare order times against your bank statement.
The second is the email inbox versus database storage confusion. cPanel shows email storage and MySQL storage under different counters, and small businesses sometimes panic thinking their database has filled the account. Open "MySQL Databases" and look at the size column on the existing databases list to see the real number, which is usually only a few megabytes on a new site.
The third is the .au domain requirement. Since 2022, auDA rules require a valid ABN, ACN, RBN, or trademark to register a .com.au or .net.au domain. If you are transferring an existing .au domain to HostGator, the database host used by your old site may be different. Recreate the database on HostGator, import the old SQL dump through phpMyAdmin, and update the wp-config.php or equivalent file with the new credentials before pointing DNS to the new host.
Finally, keep an eye on the number of simultaneous connections. The default MySQL limit on shared Australian plans is generous, but a poorly coded plugin on a busy day can exhaust connections. If your site starts throwing "Too many connections" errors, check the "Remote MySQL" icon and review your user privileges to make sure no test scripts are holding connections open.
Keeping Your Database Healthy After Creation
Creating the database is only the start. Set a reminder to back it up weekly. cPanel includes "Backup" under the Files section, and "Backup Wizard" lets you download a full account backup that includes all MySQL dumps. For larger sites, schedule a cron job that runs mysqldump and emails the result to a secure address. Australian businesses subject to the Notifiable Data Breaches scheme benefit from regular, off-server backups because a compromised host does not have to mean a lost database.
Run occasional optimisation. phpMyAdmin lets you select all tables and choose "Optimize table", which reclaims space from deleted rows. Update your CMS and plugins to patch SQL injection vulnerabilities. Review user privileges every few months and remove any test accounts you no longer need. If you want a broader checklist of what to look for in a HostGator plan before you commit to this setup, this HostGator review breaks down the features that matter for Australian small businesses.
Once the database is live, the most useful next step is to log into phpMyAdmin, import a small test SQL file, and confirm you can read the rows back, since that single check confirms the database, user, privileges, and connection all work together and you are ready to install your CMS.