Hi, for my shopping carts, chat boards websites, I am using MySQL to manage databases, designing tables, and adding, deleting, and updating records, all from within your web browser.
For, the websites which have got the requirments of the databases, we can use MySQL in them. The MySQL database server is the world’s most widely used open source database management system. A database is a structured collection of data, which may be anything from a list of products on your site to large amounts of information in a corporate network.
To add, access, and process data stored in a computer database, you need a database management system. Since computers are very good at handling large amounts of data, database management plays a central role in computing, as stand-alone utilities, or as parts of other applications.
How we can administer this MySQL?
You can use, phpMyAdmin which is a tool written in PHP intended to handle the administration of your MySQL.
Here is list of phpMyAdmin features:
1. Create and drop databases
2. Create, drop, and alter tables
3. Delete, edit, and add fields
4. Execute any SQL statement
5. Manage keys on fields .
To access phpMyAdmin please follow these instructions.
1. Login to the members section.
2. Click on the MySQL Database tools icon.
3. Click on the phpMyAdmin link beside the database that you wish to access.