In this section, we will learn about MySQL admin and the different options that are available in administering your MySQL service after it is successfully installed.
MySQL Admin using Command Line
Command line interface is commonly used by an old-school programmer to perform MySQL queries. If you have already installed MySQL on your Microsoft Windows operating system you can open a command line by clicking the Start Menu and launch Window’s command line interface by typing the keyword “cmd” into the text field and press Enter on the keyboard.
MySQL Graphical User Interface(GUI)
There are so many free MySQL administration tools that are available and many developers prepare these free Graphical User Interfaces( gui ) on the command line. These are the most popularly used: phpMyAdmin , MySQL Administrator and Navicat.