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 Admin
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.
MySQL GUI
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
MySQL.com
.
- Navicat - A purchasable MySQL admin tool for Windows, Mac and Linux.
MySQL phpMyAdmin
As previously mentioned, the very popular
phpMyAdmin tool should come with your web hosting plan.
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 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 Navicat
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.
|
