In the mysql admin 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.
What is MySQL Command Line?
If you are an programmer ,but you have not need for a graphical user interface, then you can simply use any command line interface to execute MySQL queries.
In which time you succsfully installed MySQL on your Microsoft Windows operating system then you 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.
What is MySQL GUI?
In mysql GUI it's a graphical user interface have so many free MySQL administration tools available, and it's the many developers favor these free Graphical User Interfaces over the command line.
The most popular options include:
The php Admin - A popular web interface that is included with almost every type of Shared, Virtual or Dedicated hosting solution.
The MySQL Administrator - It's a powerful tool developed by the folks at MySQL.com
The Navicat - A purchasable MySQL admin tool for Windows, Mac and Linux.
The MySQL php Admin
As previously mentioned, the very popular phpMyAdmin tool should come with your web hosting plan.
What is 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.
What is 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.