How to Use a SQL Database and C Panel
A Web developer uses a SQL database to store his website's data. SQL databases are created with a cPanel tool. Many Web hosting services provide access to the cPanel tool to the developer without cost. The cPanel enables the developer to create a new database, delete a database, add users to the database and set the access level for each user. The developer also use the cPanel's phpMyAdmin tool to add tables and fields to his database.
Other People Are Reading
Instructions
-
-
1
Open your cPanel utility. The cPanel may be accessed through your Web hosting account. Certain hosting providers allow direct access to the cPanel from the yourDomain.com/cpanel Web address.
-
2
Click the "MySQL" databases icon. The icon resides under the databases menu bar on the front page of the cPanel.
-
-
3
Create a new database. The MySQL databases cPanel features a create database button. Enter the name of your new database and press this button.
-
4
Add new users. Under the create database button, you will notice an option to add new users. Enter the names of the new users.
-
5
Assign users to your database. You will find the option to add users to the database just under the add new users input. Select the user of your choice from the drop-down menu. Match the user to the database you wish to provide access. A secondary window will appear and you will have the option to place a limit on the user's access.
-
6
Click the home icon on the top left corner of the page. This will return you to the home page of the cPanel.
-
7
Press the "phpMyAdmin" icon. This icon lies just under the databases menu. The phpMyAdmin program allows you to open up the database and create new tables and fields.
-
8
Select your database of choice and create a new database table. A listing of your databases will appear in the left side column of the page. Once a database has been selected, the right side column will display the option to create a new table and define the number of fields.
-
9
Name your columns and assign their characteristics. Possible characteristics include a limit on the number of characters that can be assigned the the field, index status and type of data (e.g. integer, varchar, timestamp or text).
-
1
References
- Photo Credit Pixland/Pixland/Getty Images
