SQLyog – MySQL database manager

Posted on February 11, 2009 at 5:18 am

Lately we have written about XAMPP which lets you get started with Apache, PHP and mySQL. XAMPP comes packed with phpMyAdmin as a default database client where you can use to manage your databases. See the screenshot of phpMyAdmin below:

phpMyAdmin has a lot of features but since it is a web based client, you are limited to its interface’s capabilities (i.e. no functional right click shortcuts and requires more steps to issue an operation).

SQLyog works like the old MS SQL Enterprise Manager and P/L SQL Developer for Oracle database. It lets you connect to any mySQL database servers and displays database objects on the left part of the GUI which users familiar with traditional GUI-based database clients will surely appreciate. You can get the free version from www.webyog.com

You can see from the example above that when I clicked a table it generates an Excel like view to the lower right side of the window. Predefined column values are also automatically generated for easier modification – they appear as a dropdown field. The location of the save and edit buttons are also intuitively positioned at the upper left part of the table.

Clicking the Objects tab will show the query used to generate the table as well as the column information. This comes in very handy for folks who want to dig straight to the CREATE TABLE SQL:

Right clicking a table will show a bunch of context sensitive operation for a table. This makes tasks like altering columns and indexes an easy to follow process. Novice SQL developers will surely love these shortcuts.

With a GUI-based client like SQLyog, users will not have to worry remembering some infrequently used queries. Creating indexes for example will not require you to issue a CREATE INDEX command. A simple right click to a table and clicking Manage Indexes will let you create indexes at once:

Executing your own SQL commands is supported by the query editor field. The green buttons at the upper left part on the window act as a run and execute all buttons.

Managing database connections are also as easy as filling up a basic login information. You can save the connections along with the password so you can easily switch from one connection to the next.

If you need to have a powerful mySQL manager application, SQLyog is very much recommended. One thing that stood out with this tool is that you can directly edit BLOBS in TEXT or GRAPHICS mode. You can also drop processes from other users assuming that you login with this privilege. It also doesn’t cause strain on my laptop as it only takes about an average of 18MB of RAM resource with queries with a few hundred rows.

Ben Carigtan shows you how it’s done.

» Filed Under Computer Tips

Comments

2 Responses to “SQLyog – MySQL database manager”

Oleg Burlaca said on : May 1st, 2009 at 4:08 pm

You may also check out AeroSQL: it’s a free web based tool for managing MySql servers written in PHP. The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications.