Wednesday, November 8, 2017

3 Best tool for working with MySQL database

3 Best tool for working with MySQL database

MySQL is one of the most popular relational database out there and has been around for long time, if you are developer who works a lot with MySQL, you probably want to check out these 3 program that can help you when working with MySQL database. So these are 3 best tool for MySQL database.


MyTop


MyTop is a command line tool for showing mysql query that's currently executed, mytop is very similar like command line tool top, unlike top which shows process list, mytop will shows query from mysql database. This tool is quite handy when you want to see what's going on behind the scene on mysql database. MyTop is made using perl programming language and available on official lubuntu/ubuntu repository.


PhpMyAdmin



PhpMyAdmin is a web based graphical interface tool for managing MySQL database, the user interface is not too intimidating and quite easy to understand, highly recommended for starter/beginner. As the name suggest phpmyadmin is made using php language which also available on official lubuntu repo. PhpMyAdmin is the first tool i use before going to MySQL workbench.


MySQL Workbench



MySQL workbench is one of the most popular graphical interface program for MySQL, workbench is perfect for working on a query, the user interface is quite simple and easy to understand, maybe there is little bit learning curve, but once you used to it, you probably don't want to use anything else.


No comments:

Post a Comment