Support Manual

MySQL

Setting up a MySQL Database is easy and only requires a few simple steps. Log into cPanel and click on MySQL Databases. There will be a variety of fields, the first of which is “new database.” >

1. Type the name of your new database and click on create database.>

2. Type in a username and password that will give you access to the MySQL database>

3. Once you have created a database and a user, you will need to give that particular user permission to access the database. >

Giving Access to Users

To give access to a user, select the username from the dropdown menu under the “add users to your databases” category. Note that you can adjust the privileges of a user, but if creating an account for yourself, be sure to have the “all” box checked.>

Click to Enlarge
After clicking on “add user to database,” the current databases category should have a new string of code displayed in it.>


Click to Enlarge
Your MySQL server hostname appears after mysql_connect. In this case the hostname is “localhost.”>

 

Copyright © 2003-2010 Hosting Connecticut, LLC.
Resellers of Hosting Connecticut, LLC. may reproduce this manual on their sites.