MySQL

If you are intending on having a Forum , Comments Page or any any other Web Applications on your site, you will require a Database. MySQL is popular for web applications and acts as the database component of the various platforms. MySQL has had more than six million installations worldwide. Its popularity as a web application is closely tied to the popularity of PHP, which is often combined with MySQL.

MySQL is a multithreaded, multi-user, SQL (Structured Query Language) Database Management System. MySQL is used on various platforms. These include Linux, Mac, Windows and Apache.

Getting started with MySQL

If you prefer books to the web try;

Or try these links;

MySQL - The software's official homepage with news, downloads and documentation.

MySQL Tutorial - Learn how to use PHP to interact with the free MySQL to make fully dynamic and database-driven sites. (Free Webmaster Help)

MySQL - Step by Step Instructions - Tips for installing MySQL on Windows machines. Also provides step by step instructions on creating and maintaining MySQL databases using basic SQL commands.

Beginning MySQL - A collection of MySQL tutorials on Administration, and Grant Tables. Includes a "Beginning MySQL" tutorial.

MySQL Administration

When you have MySQL successfully installed on your server, you have different options available to you for administration. You can simply use any command line interface to execute MySQL queries. Or you can use one of the MySQL Graphical User Interfaces listed below.

phpMyAdmin - phpMyAdmin is included with most hosting services and it is a good place to start. phpMyAdmin will allow you to view all the MySQL database, tables, and entries, as well as perform SQL queries remotely through a web browser. phpMyAdmin is an easy to use interface. This is what i used first time and I found it easy to use.

Navicat - MySQL administration product. A brief overview of their product Navicat Admin can be found on their website. This product costs from $75 and up. Navicat comes with a 30 day trial

MySQL Administrator - This tool comes from the creators of MySQL, so you can be assured they have a solid understanding of database optimization and stability for you power users. There are currently two versions of MySQL Administrator: 1.0 and 1.1. MySQL.com recommends you use 1.1 if your MySQL installation is 4.0, 4.1 or 5.0. Read more about the MySQL Administrator on MySQL.com's web site.

MySQL News