Creating a MySQL Database using CPanel

Today, I created a development site for a support2. Under "Create New Database" type in your
client's web site. A development (dev) server allowsdatabase name and click "Create Database." Note
you to try all kinds of things without affecting the livethat the database name you enter results in a full
site. Not everything can be done in the draftdatabase name that includes your account User name,
workspace on a live site, so dev sites are essential.in this case "mjiacqa_typo3.
There are a number of ways to copy a site to
another server, but as I was going through the3. Now, you have to create a user for your database.
process, I thought that some things tend to be takenUnder "MySQL Users > Add New User" enter an
for granted by writers of instructions. One of theseappropriate name and a good password. Click "Create
things is actually creating a MySQL database for theUser."
new site. This applies to copied sites and completely
new sites. Some writers assume you know how to do4. Now you need to give the new user some
it. Others assume you know how to use a commandprivileges. Normally, you will select "All Privileges" for
line shell.the main TYPO3 database. Click "Make Changes" to
That is fine, but not everyone knows these things. Ifsave the privileges.
you have CPanel, it is extremely easy to create a
database and a user for the database. Here's how:5. Now you have to add the user to the database you
Make sure you record the full database and Usercreated. Under "Add User to Database" select the
Names, as well as the User password, these will beuser you just created and click "Add."
needed to enter in the TYPO3 localconf.php file.
1. Log into your CPanel, scroll down to the "Databases"6. Now you can see that the user is associated with
section and click "MySQL Databases."the database.