Sign In

Welcome! Log into your account

Forgot your password?

Create an account

Sign Up

Welcome! Register for an account

A password will be e-mailed to you.

Password Recovery

Recover your password

A password will be e-mailed to you.

Available for:

Webyog SQLyog 13.1.9 Ultimate

Webyog SQLyog 13.1.9 Ultimate
DownloadDownload Buy Now

Webyog SQLyog is the most powerful manager, admin and GUI tool for MySQL and MariaDB. With HTTP/ HTTPS/ SSH Tunneling is a easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world.

Webyog SQLyog software was developed keep in mind the necessities of all who use MySQL as their preferred RDBMS. Whether you enjoy the control of handwritten SQL or prefer to work in a visual environment, Webyog SQLyog makes it easy for you get started and provides you with tools to enhance your MySQL experience.

SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface.

Webyog SQLyog Features:

  • HTTP/HTTPs Tunneling
  • SSH Tunneling
  • Visual Data Compare
  • Query Profiler
  • Data Search
  • Schema Optimizer and Index Analyzer
  • Schema and Data Synchronization
  • Wizard driven compressed backups with scheduling
  • Visual Query Builder
  • Form View
  • Visual Schema Designer
  • SQL Formatter
  • Import External Data
  • Session Restore
  • SSH and HTTP Tunneling
  • Foreign Key Lookups
  • Autocomplete

SQLyog provides you with powerful means to manage your MySQL databases.

  • Works with MySQL servers from 4.1 and higher and all MariaDB servers.
  • Create/Drop/Alter Tables, Stored Procedures, Functions, Views, Triggers and Events.
  • HTTP and SSH Tunneling – smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed!
  • Protect your data with SSL encryption.
  • Smart AutoComplete.
  • Formats SQL statements.
  • Proactive Query Profiler.
  • Favorite Manager to neatly organize your favorite SQL statements.
  • Very fast retrieval of data.
  • Advanced GUI Query Builder. Supports JOINs, aggregate as well as ‘common’ functions, sorting (ORDER BY) and filtering (WHERE and HAVING) and ALIAS.
  • SQLyog Import External Data wizard – use the GUI or specify a query.
  • Schema and Data synchronization tools.
  • Powerful compressed Scheduled Backup with email notification.
  • Schedule various jobs.
  • SQL Scheduler and Reporting Tool – execute unattended queries for database maintenance of data verification with flexible email option.
  • Full support for Virtual Columns of both Oracle/MySQL and MariaDB
  • GUI transactions support
  • Transparent LDAP/PAM support for connection to both Oracle/MySQL and MariaDB. No settings are required
  • Update result returned from query – also supports queries with JOINs. No dialogues – just edit!
  • Manage foreign key relationships.
  • Fully InnoDB compliant.
  • Supports MySQL pluggable storage engines architecture.

More Features:

  • Multi-threaded query execution with option to allow multiple query execution simultaneously.
  • View your results in GRID/TEXT mode.
  • Filter data and resultsets directly form the context menu of a displayed value.
  • Execute (very large) SQL-scripts as batch files.
  • Execute multiple queries returning more than 1000s of rows per resultset. Its very efficient in memory.
  • Very compact binary.
  • Written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used.
  • Connection manager.
  • Tabbed interface to create/alter tables.
  • View and edit advanced table-properties, such as Comment, Key_Length etc.
  • Do table-diagnostics (check, optimize, repair, analyze)
  • Duplicate tables to new table-names.
  • Excel like grid interface to edit data with support for Enum/Set.
  • Create/Drop databases.
  • Manage indexes.
  • Comprehensive user/security manager. Control every available privilege on what level you like (server/database/table/column).
  • Reorder columns of table.
  • Copy database between two MySQL hosts.
  • Drop all tables of a database with a single click.
  • Edit BLOBs in TEXT or GRAPICHS mode. All common (non-proprioritary) graphics format (including ‘high-resolution’ TIFFs and PNGs) supported.
  • Export table-structure and data into SQL-dumps.
  • Direct export to Microsoft Excel.
  • Export/import data in/from CSV files.
  • Export database schema in HTML.
  • Log all queries for a session.
  • Syntax-highlighting.
  • Save resultset in CSV, HTML and XML.
  • Copy your result as CSV to clipboard.
  • Is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
  • View and kill other user-processes.
  • Flush Host/Logs/Privileges/Tables.
  • Quick access to processlist, status, variables etc.
  • and a lot more…

Changes in SQLyog 13.1.9 (January 2022):

Features:

  • Updated the ‘User Manager’ GUI to support the newly added privileges in MariaDB v10.5.

Bug Fixes:

  • SQLyog returned an error when setting user server resources like maximum number of queries per hour, Maximum number of updates per hour, Maximum number of connections per hour, or Maximum number of user connections using User Manager GUI for MySQL v8+ Servers.
  • The tunneler file for HTTP-tunnel has been updated with this release and must be replaced on the server. In the old tunneler file, curly braces were used for accessing array elements and string offsets; this behavior is deprecated. Also, some functions used are deprecated in PHP 7.4x.
  • In some rare cases, the Schema Designer failed to add all the child tables of a parent table to the canvas.
  • Explain Extended menu option is disabled for MySQL v5.7.3+ as it is deprecated.
  • Database Synchronization wizard returned an error “Column definition mismatch” for “DATETIME” column on syncing the data from v5.7 to v8.
  • SQLyog stopped responding when executing a query in an SSL connection through SSH-Tunnel.
  • When an SSL connection was established through an SSH-tunnel, the ‘New connection using current settings’ option failed to open the same connection, as the UI stopped responding and SQLyog had to be forcefully terminated.

Note:

  • Windows 7 Support has ended.

Changes in SQLyog 13.1.8 (April 2021):

Bug Fixes:

  • With MariaDB System-Versioned tables, SQLyog was hanging when clicking in SQL Preview in the Alter table wizard.
  • Indexes were not being displayed with MariaDB System-Versioned tables.
  • In some cases, LOAD DATA LOCAL INFILE query failed to be executed from the Query Editor.
  • Schema Sync tool generated incomplete queries if the table contained an exceptionally long ENUM data type.
  • In some rare cases, Schema Sync failed to sync the mismatch, even after executing the query generated by the Schema Sync tool.
  • SQLyog generated an incorrect ALTER TABLE statement in Schema synchronization with ‘TIMESTAMP’ and integer (INT, TINYINT, BIGINT, and SMALLINT) data types for MySQL Server version 8.0.19 or above with any target MySQL version and vice versa. Though the Schema Sync will still display the difference in the schema, SQLyog now allows the data to be synced for only INT, TINYINT, BIGINT, and SMALLINT data types.
  • In some cases, Schema Sync reported nonexistent differences in the schema.
  • When the connection was idle for a long time, executing Copy Database/Table or opening a new connection using the option New Connection Using Current Settings returned different MySQL errors like Error No. 1043 Bad Handshake.

Changes in SQLyog 13.1.7 (September 2020):

Bug Fixes:

  • SQLyog was unable to connect to a MySQL server using SSL when the client did not provide a CA Certificate file.
  • Editing a user password was not working for MariaDB server version prior to 10.4.
  • Calculating Optimal Datatypes in the Info table, returned syntax error for MySQL version 8 and above.
  • Copy Database was not working properly when the chunk size was set to 0 or less.
  • SQLyog returned random errors when importing a SQL dump using HTTP tunnel.
  • In some places, the connections and databases names longer than 44 characters were truncated on the right-side in the drop-down list of connections/database names.

Miscellaneous:

  • The MariaDB C Connector is upgraded to version 3.1.8.

Changes in SQLyog 13.1.6 (April 2020):

Features:

  • We added an option to specify the authentication plugin while creating/altering the user. This option is available for MySQL 5.7+ and MariaDB 10.4+ servers.
  • Now, it is possible to create invisible and descending indexes using GUI. This option is available for MySQL 8.0.11+ servers.

Bug Fixes:

  • In some rare cases, SQLyog failed to connect to MySQL over SSH tunnel.
  • The saved connection names that are longer than 44 characters were clipped on the right-side in the drop-down list of saved connections.
  • Fixed a UI issue for a column of ‘enum’ datatype in Alter table GUI.
  • Scheduled backup failed to send an email on the successful completion of the backup in a rare case.

Note:

  • SQLyog 32-bit version is no longer supported.

Changes in SQLyog 13.1.5 (July 2018):

Bug Fixes:

  • On environments involving SSH-tunnel reconnection to the server could fail after timeout. This was caused by slightly different error reporting in some cases by the new MariaDB Connector/C v3.0 compared to v2.3, we used before SQLyog v13.1.3.

Homepage – https://www.webyog.com

Runs on all Windows version from Windows 8 and higher as well as “Windows Server” systems of same generations (Windows Server 2012 and higher).