CPanel and the Database Wizard

CPanel Home

If your web hosting provider uses CPanel, you will see a page similar to the image below after you log in to your control panel (normally by adding /cpanel after your domain name).

Somewhere on your CPanel homepage you will find a section named Databases, inside which you should find the MySQL Database Wizard icon. Click on it to create your ecosystem database.

MySQL Wizard

MySQL Wizard Step 1 / 4

The first step is to decide on a name to call your ecosystem database. The choice of name is up to you, but we are using ecosystem in the image below.

Note: The actual database name (in the above example) is admin_ecosystem. CPanel automatically prepends whatever name you give it with your own username. This is normal practice for shared web hosting.

Now move to the Next Step.

MySQL Wizard Step 2 / 4

Now that your database was successfully added, you must create a database username and password for it. This username/password combination is specifically for your database, and it will be used later in ecosystem to give it access to this database.

Your CPanel username once again prepends whatever database username you enter. In the above example, our database username is admin_dbuser.

Once you are happy with your username/password, click Create User.

MySQL Wizard Step 3 /4

Now that your database has been created and you have made a username to connect to it, it is time to choose the permissions your database user has when interacting with the database.

In this case, choose All Privileges so that your database user can do whatever it likes in your database.

Note: This is NOT good practice, but will suffice for now. Once you have set up ecosystem and are happy that it is all working, you should remove most of these unnecessary settings.

When all privileges are selected, click Next Step.

MySQL Wizard Step 4 / 4

Nothing to do here :-) except confirm that the privileges have been set on your database.

A Note about your Database Username

The username and password that you have just created for your database will not be used by you anywhere, so you won't get asked to type it in at any time. If you are asked at any point for a username/password, it will not be this one! This username/password will only be used in ecosystem later to allow it access to your database.

Now that we're all done, click Return Home.

Next Steps

Now that your database is ready, you must now create the necessary ecosystem tables. The tables will hold all the data that your ecosystem website creates.

Creating the tables is done within the phpMyAdmin package.

Return to Database overview