Advertisement

SQLyog

13.1.6

Webyog(Free)

User rating8

Advertisement

Database management tool

SQLyog is a MySQL administration tool for database administrators, database architects, and developers. It is also referred to as a graphical user interface tool that can manage 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 in tandem with MySQL servers 4.1 or higher and on all MariaDB servers. With SQLyog, you can create, drop, or alter tables, stored procedures, functions, views, triggers, and events with the safety of its built-in HTTP and SSH Tunneling. 

Advertisement

Starting SQLyog 

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

New means creating a new connection. By default, SQLyog will create an instance with common values such as localhost or root. You can change this by typing a new connection name in the textbox. The connection name can be changed anytime as it is only used by SQLyog internally. It also means 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 the connection entirely. 

Using Query Builder 

SQLyog main draw is the GUI Query Builder, a TAB in the SQL editor area of the program. The Query Builder is selected by clicking on the addition or + icon on the query editor line. A pop-up menu will appear with four options including New Query Builder. One Query Builder TAB consists of 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 the queries. 

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

Important tool for MySQL users

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

Title:
SQLyog 13.1.6 for Windows
Requirements:
  • Windows 2000,
  • Windows NT,
  • Windows 95,
  • Windows ME,
  • Windows 98 SE,
  • Windows Vista,
  • Windows 98,
  • Windows XP
Language:
English
License:
Free
Date added:
Friday, April 3rd 2020
Author:
Webyog

http://www.webyog.com

SHA-1:
1ce278b337b72b7ac51c9fcc627a7e1aa8a7710b

We don't have any change log information yet for version 13.1.6 of SQLyog. Sometimes publishers take a little while to make this information available, so please check back in a few days to see if it has been updated.

Can you help?

If you have any changelog info you can share with us, we'd love to hear from you! Head over to ourContact pageand let us know.

Advertisement

Advertisement