phpMyAdmin - cPanel Tutorial Ch.7 | Web Hosting Articles & Tutorials

phpMyAdmin - cPanel Tutorial Ch.7

cPanel comes readily available on most web hosting servers you will run across these days. One of its many functions is allowing users to manage their databases; this includes creating, modifying and even deleting tables. There are a few things you will not be able to do such as retrieving selective backups, having the ability to backup only certain tables in a database or execute queries.

This is where PHPMyAdmin comes in. This user friendly application was designed to make the management of your website easy, in this case your web hosting server that runs with a cPanel. PHPMyAdmin simplifies the process of maintaining your databases, specifically those scripted on MySQL.

The PHPMyAdmin application is essentially composed of PHP scripts, the language of the web.
The control it gives you over a database is remarkable. PHPMyAdmin currently allows you to:

- create and drop a database
- create, copy and alter tables
- delete, modify and create fields
- execute any database statement with the inclusion of batch queries
- load text into your tables
- import and export data
- administrate a primary database

ACCESSING PHPMyAdmin IN CPANEL

PHPMyAdmin can be accessed through the “Databases” panel of your website. This will typically be labeled “MySQL”. You should notice a link for PHPMyAdmin near the bottom of the page. After clicking this you will now be able to maintain your databases. Let’s go further into the process and detail how PHPMyAdmin will manage a database you plan to create.

- Create a MySQL user ID and password for whom ever will access to the database
- Click “Add User”
- Assign privileges to the user; they can alter, create, create temporary tables, delete, drop, select, insert, update, reference, index or lock tables. In this instance we will check the “all” box.
- Click “Add User To DB”
- Download the zipped config.inc.php file and extract the main component
- Open this in your text editor screen and modify the lines with your, IP address or web host and the username you created above
- Save the file and close the screen
- Go back and login in your cPanel
- Create a directory such as “phpmyadminstaff_html”
- Upload all your content into the directory you created

From there installation is complete and PHPMyAdmin can be used to effectively manage your database. Be sure to add password protection the directory for security measures.

MORE ON PHPMYADMIN

The PHPMyAdmin application is widely used because of its actual interaction with the database. This program is currently available in over fifty languages. Since PHPMyAdmin is mainly configured for MySQL there are other versions that rival its function with cPanel. PHPPGAdmin works similar to maintain databases of PostgreSQL. PHPMSAdmin is designed to manage Microsoft SQL Servers. While it has many of the same capabilities it includes no actual codes from the PHPMyAdmin application. The closest tool in resemblance would be PHPMinAdmin. This includes all the most crucial features of PHPMyAdmin but is composed of only one PHP file.

PHPMyAdmin typically comes free with most web hosting servers.

Share this article: