MySQL for beginners - How to create a MySQL Database
Whether you are an experienced web programmer or a complete
novice attempting to provide data interactivity with your web
site, MyQSL is an easy to use and free database solution that
can allow you to store and configure data to be displayed on
your web site.
The best way to create and manage a MySQL database is to
download an open source (free) program called PhpMyAdmin.
PHPMyAdmin allows you to manage all aspects of both your
database structure and data from one easy to use interface. This
tool is intended to handle the administration of MySQL over the
Web.
This tool provides an interface that allows you to create and
drop databases, create, drop, or alter tables, delete, edit, or
add fields, execute any SQL statement, manage keys on fields,
manage privileges, and import and export data into various
formats. That sounds like a complicated set of activities, but
the easy to use graphical tools make things quite simple and
easy to understand. If you make a mistake, the software even
provides instructions on where you made your error.
For a complete demo see: http://www.phpmyadmin.net/phpMyAdmin/
For documentation visit:
http://www.phpmyadmin.net/home_page/docs.php
Most Linux based web hosting companies provide PhpMyAdmin as a
standard feature with their packages. It is also available in a