HeidiSQL - MySQL made easy

What's this?

HeidiSQL is a lightweight, Windows based interface for managing MySQL and Microsoft SQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers. read more...

News

01 Mar New feature: Launch command line window

After having established a MySQL or MariaDB connection, HeidiSQL offers to launch a command line window (located in the "Tools" menu). This executes mysql.exe from the directory which is set in Tools > Preferences > Miscellaneous. The clue is that HeidiSQL passes all connection parameters from the current connection to that command line, including host/user/password, named pipes and SSL s ... [read]
12 Feb HeidiSQL 7.0 released

450 revisions after the 6.0 release follows the new 7.0 release of HeidiSQL now. Here are the most noticable changes since the 6.0 release:- Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export- Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created- Threaded query execution, ... [read]
22 Jan New feature: Pluggable authentication

Starting with MySQL 5.5.7 or MariaDB 5.2, the server allows the client to authenticate via plugin. HeidiSQL now fully supports establishing such connections, by providing an exported method called mysql_authentication_dialog_ask, which is automatically invvoked by libmysql.dll, if the server says so during the connection handshake.Curious how that works? Here's a simple example:1. Be sure to ha ... [read]
19 Jan New feature: SSL settings in user manager

In MySQL you can restrict users to connect only via SSL settings. HeidiSQL's user manager now adds support for these settings, which include cipher, subject and issuer. You can also select X509 certificate, in which case cipher etc. do not matter. To get this new feature, you just need to update to the latest build (see Help > Check for updates). [read]
10 Dec Automated installer creation

On the download page you will find the executable for each SVN commit in the HeidiSQL repository. The executables are processed in conjunction with a SVN post commit hook. I just extended this process so it also creates the installer with that executable, using a InnoSetup command line. This way, users who need a full installer and also want to use the latest build can do that in one download.T ... [read]