This lesson covers the different options you have available to you for administering your MySQL service after it is successfully installed. If you already have that base covered feel free
to skip on to the next lesson.
MySQL Command Line
If you are an old-school programmer that has no need for a graphical user interface, then you can simply use any command line interface to execute MySQL queries.
Those of you with MySQL installed on your Microsoft Windows
operating system can reach the command line by going to the Start Menu and choosing "Run...". Type the
keyword "cmd" into the text field and press Enter to launch Window's command line interface.
With so many free MySQL administration tools available, many developers favor these free Graphical User Interfaces over the command line. The most popular options include:
- phpMyAdmin - A popular web interface that is included with almost every type of Shared, Virtual or Dedicated hosting solution.
- MySQL Administrator - A powerful tool developed by the folks at
- Navicat - A purchasable MySQL admin tool for Windows, Mac and Linux.
As previously mentioned, the very popular
phpMyAdmin tool should come with your web hosting plan.
This tool comes from the creators of MySQL, so you can be assured they have a solid understanding of database optimization and stability for 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.
Navicat comes with a 30-day trial so you can play around and see if you feel like dropping the cash
for this MySQL administration product. A brief overview of their product Navicat Admin can be found on their website. The cost of this product is around $100.
Download Tizag.com's MySQL Book
If you would rather download the PDF of this tutorial, check out our
MySQL eBook from the Tizag.com store.
You may also be interested in getting the PHP eBook
Found Something Wrong in this Lesson?
Report a Bug or Comment on This Lesson - Your input is what keeps Tizag improving with time!