MySQL 5 Tutorials & Articles

Setting up Cpanel Database and User

In this tutorial we will be setting up your first cpanel mysql database and mysql user. Then we will be connecting them so we can use them for programming purposes.

Step 1 - Login to cpanel

First off we need to login your cpanel account. This is usually located: http://domain.tld/cpanel/.

Step 2 - Creating your Mysql database

1. Click on the Mysql Database Icon

2. Now type in the input box, keep your database name at a max of 7 characters, then click Create Database.

Step 3 - Creating your Mysql User

1. Hoping your on the same page scroll down and find the Mysql Users looks like below

2. In the users box keep the user name to 7 characters max, this is why I said keep db name to 7 chars max. Click generate password, at least 12 characters max. And save everything in a txt file from this because you might/will need it later. Now click on “Create User” and you’ve created your first mysql user.

Connecting Database and User

1. Select your database and your mysql user like so: (security issues i erased something but it essentially looks like below)

2. Click Add and check the all privileges box thats red and click manage changes:

Congratulations you’ve created your first mysql database in cpanel.

Cpanel 11 Mysql Database Wizard

Instead of using my way theres a quicker way without all the link clicking.

Next to the Mysql Database link you will see this Wizard link. Its just like the current steps before, but with less page loading and link clicking. Basically “Quicker”.

Continue Reading

Mysql Starter Tut - Part 2 where you learn how to connect to a database using mysql and php.