MySQL is a "Structured Query Language," part of the family of databases that power applications ranging from industrial-level software to personal account programs. Many of today's web programs are powered by the MySQL database. For instance,
if you want to install the popular WordPress blog software on your site, you will need to specify a database, username, and password. You will also need to specify the "host," which usually has the value "locahost" meaning that the database is
on the same server as the program.

In this tutorial, we will show you how to use the program within Cpanel to create a user, password, and database,
and we will show you how to grant the proper permissions to the user so the database is accessible.

Step 1: Login to Cpanel

Login to your control panel through http://host.kenosys.com/cpanel or http://yourdomain.com/cpanel


Step 2: Create Database from Cpanel

Once logged into the control panel, there is a link says "MySQL Database." First click on this link.



There is a field partway down the "MySQL Database." page for adding databases. It says, "New Database " with an empty field after it.
Enter here the name of the database you would like to create - perhaps "wordpress" if you were to set up a WordPress database for your blog. Then click "Create Database" and the database will be created.



Step 3: Create user from "MySQL Database."

Now you must create the user. Right underneath the "Create Database" feature, there is the add user feature.
Here, enter the "UserName" and "Password" and click on the "Create User" button.



Step 4: Give new user permission to access new database

Now that the user and database are connected, you need to give the user permission to access the database.
Above the "Create Database" feature there is a dropdown list for the user and database. Select the newly created user and the newly created database. Under privileges, check the "all" option. Then click on "Add User to Database"



The database and usernames are the same as that in the dropdown menu. Both the username and database will be appended with your account name as a prefix, and this is for internal server organization. The password will be whatever you specified
when creating the user. The host, if prompted in your program, is going to be "localhost."