SQLyog Latest Version

Database management tool:
SQLyog is a latest MySQL administration tool for database administrators, database architects, and developers. It is also referres to a graphical user interface tool that can manage of MySQL databases. The desktop program can run on all Windows computers running, Windows Vista/2008 or newer as well as Windows Server Systems released on or after 2008. You can use this tandem with in MySQL servers 4.1 or higher and on all the MariaDB servers. With SQLyog, you can creates, drop, or alter tables, triggers, stored procedures, functions, views, and events with the safety of its built-in HTTP and SSH Tunneling.

Database management tool

Starting SQLyog:

The first time you launched SQLyog on your PC a pop-up window will appears, allowing you connect to your MySQL server. You can also choose one of four connectivity options: Direct connection, SSH Tunneling, HTTP Tunneling, HTTPS Tunneling, and SSL Encryption. Note: These depend on your preference and does not have an effect on the layout of your MySQL Server/s. Another important steps to take when opening SQLyog is to creates an instance of your database connection. To do this, you must have select New on the connection manager dialog box.

New means creates a new connection. By default, SQLyog will creates an instance with common values and such as localhost or root. You can changes this by typing a new connection name in the textbox. These connection name can be changed in anytime as its only used by SQLyog internally. It means that it does not have an effect on the names or connections in MySQL. In addition to renaming the connection, you can save the changes or delete to the connection entirely.

Using Query Builder:

SQLyog main draw is that GUI Query Builder, a TAB in the SQL editor area of the program. The Query Builders is selected by clicking on the addition or + icon on the query editor lines. A pop-up menu will appear with four options includes to the New Query Builder. One Query Builder TAB consists of the three sections: a canvas, a grid area, and a read-only editor area. Between each area is a divider that can be moved, allowing you to modify the panels according to the size of queries.

Creating a query is easy as its only requires that you use your mouse. With it, you can drag tables from the Object Browsers on to the canvas. You can then arranges and resize them according to your preference. During these process, you can may see some lines forming between two tables. This means the Foreign Keys are defined between the tables and an SQL JOIN is available. You can right click on line to define the JOIN properties or to remove it.

Important tool for MySQL users:

As a web developer using to PHP and MySQL, SQLyog is important for maintaining a good front end system. It displays all that tools you need in managing your database so you can easily select it, when needed. The integration of the mouse is also an important features as it allows you to quickly navigate throughout the program. Altogether, this database management tools is a suitable programs for both new and experienced MySQL administrators.

Important tool for MySQL users

Download