Introduction to MySQL Databases

MySQL is a widely used relational database management system for SQL databases. A database management system allows you to add, access, and retrieve data stored in a SQL database.

A relational database stores data in separate tables rather than in one table. This adds speed and flexibility in accessing and retrieving data. The tables are linked by defined relations making it possible to combine data from several tables on request.

Note: The MySQL service is available only if you have installed MySQL as an add-on when you installed the control panel.

About the MySQL database server

The MySQL Database Server is very fast, reliable, and easy to use. Its architecture makes it extremely fast and easy to customize. The MySQL Server is designed to handle large databases and has been successfully used in highly demanding production environments. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.

Some of the key features of the MySQL database server are:

• Portability
• Works on a range of platforms enabling you to port your databases across different operating environments
• Provides APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl allowing you to write programs using any of these applications
• Possesses parallel processing capability; multiple CPUs can be used to process data faster and more efficiently
• Security
• A secure password system that is very flexible, and allows host-based verification. Passwords are secure because all password traffic is encrypted when you connect to a server.
• Scalability
• Efficient in handling large databases. You can create databases with more than 50,000 tables.

If MySQL is available to you, you can:

• Connect to the phpMyAdmin MySQL interface to manage your SQL databases
• Change your MySQL password

For more information about using the MySQL Administration Tool, see www.PHPWizard.net.

For more information about working with MySQL databases, see www.MySQL.com.