Available for:
No Comments
Report about Update or Broken Link

Webyog SQLyog 13.2.1 Ultimate

Webyog SQLyog 13.2.1 Ultimate
Download
Buy Now
Description
Changelog
Specifications

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.2.1 (November 2023):

This release of SQLyog addressed the most requested Quality Enhancements and some bug fixes. These enhancements are related to HTTP connections, schedule backups, Emoji updates, and Unique Identifiers.

Quality Enhancements:

  • With Azure DB, SQLyog returned an error “unknown thread id” on stopping the query execution.
  • Emojis will be displayed as they are in the ‘Table Data/Result’ tab, ‘Scheduled Backups’, ‘Copy Database To Different Host/Database’ on setting the character set to ‘utf8mb4’ in the ‘Init Command(s)’ field, under the ‘Advanced’ tab of the respective connection and in the Scheduled Backups window.
  • The tunneller file for HTTP-tunnel connections has been updated with this release and must be replaced on the server.

Bug Fixes:

  • SQLyog used to abruptly close on altering a table having a column with CHECK constraint and Comment.
  • SQLyog displaying an empty HTTP Response dialog is fixed for connections through HTTP-tunnel.
  • Fixed a memory corruption issue with ‘autocomplete’ that, in rare situations, could cause SQLyog to crash.
  • Fixed SQLyog failing to import the saved connections in some rare cases.
  • Selecting ‘Edit a saved job’ and selecting a job file that has a connection with SSL enabled, the ‘Use SSL Encryption’ checkbox was unchecked, and thus the connection failed.
  • Fixed SQLyog generating a wrong syntax in the Create/Alter Table if UUID or SYS_GUID were used as the default value for varchar columns.
  • SQLyog incorrectly interpreted the value ‘CHECK’ for CHECK CONSTRAINT on a column with ENUM datatype.

Miscellaneous:

  • The “keywords.db” file (used for syntax highlighting, autocomplete, and automatic letter case handling for functions and keywords) is updated with new keywords and functions added in recent MySQL and MariaDB servers.

Changes in SQLyog 13.1.9 (January 2022):

  • 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.

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).

Leave a Reply

0 Comments on Webyog SQLyog 13.2.1 Ultimate

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.