Download HeidiSQL 6.0 stable

HeidiSQL runs fine on Windows (2000, XP, Vista, 7) and on any Linux with Wine. Previous releases can be downloaded at Google Code.

Nightly Builds of heidisql.exe

Latest automatically compiled main executable and installers for HeidiSQL. Just download and overwrite your existing C:\Program Files\HeidiSQL\heidisql.exe. Be aware that these builds are not official releases and therefore probably have more bugs, possibly serious ones.

Link to latest build   RSS Feed Changes Feed

Revision Committed Notes Compiled .EXE Installer
4036 1 day ago

Decrease memory requirement for compressing files in installer, by using ZIP instead of LZMA2.

Application form 5,172 KB
1,056 downloads
Package 3,388 KB
379 downloads
4035 1 day ago
Compiled: 41 minutes later

Do not export data from MRG_MYISAM tables. See http://www.heidisql.com/forum.php?t=9842

Application form 5,172 KB
42 downloads
Package 2,624 KB
19 downloads
4034 1 week ago

Try to fix dbtree focus/refresh access violation. Fixes issue #2665.

Application form 5,172 KB
5,411 downloads
Package 2,624 KB
2,261 downloads
4033 1 week ago

Find erroneous SQL also when getting a "Duplicate entry 'xyz'" error. Fixes issue #2698.

Application form 5,172 KB
969 downloads
Package 2,624 KB
307 downloads
4032 1 week ago

Fix non-nil values for mysql_ssl_set(), broken in r4031.

Application form 5,171 KB
40 downloads
Package 2,624 KB
26 downloads
4031 2 weeks ago

Introduce a checkbox for explicit activation of SSL. Any combination is passed to the server now, while SHOW STATUS LIKE 'ssl_cipher' is used to find out if the connection is indeed SSL secured. Pops up a warning when SSL settings were ignored by the server. Fixes issue #2672.

Application form 5,171 KB
2,019 downloads
Package 2,623 KB
976 downloads
4030 2 weeks ago

Show up new session after "Save as" action. Fixes issue #2686.

Application form 5,170 KB
2,126 downloads
Package 2,623 KB
776 downloads
4029 2 weeks ago

Autofix TYPE|ENGINE clause when exporting to server. Fixes issue #2688.

Application form 5,170 KB
36 downloads
Package 2,623 KB
29 downloads
4028 2 weeks ago

Do not use TOP 1 in DELETE queries on MS SQL servers. Fixes issue #2690.

Application form 5,170 KB
43 downloads
Package 2,623 KB
28 downloads
4027 3 weeks ago

Use different TOP syntax for UPDATE + SELECT queries in MS SQL. Fixes issue #2682.

Application form 5,170 KB
2,537 downloads
Package 2,623 KB
965 downloads
4026 3 weeks ago

Avoid accessing non existing items in ADO error pool. Fixes issue #2684.

Application form 5,170 KB
2,102 downloads
Package 2,623 KB
547 downloads
4025 3 weeks ago

Add version of libmysql.dll to error message when it's outdated.

Application form 5,170 KB
41 downloads
Package 2,623 KB
35 downloads
4024 3 weeks ago

Fix repeated glitch in previous build. Sigh...

Application form 5,169 KB
1,992 downloads
Package 2,623 KB
727 downloads
4023 3 weeks ago

Issue #2550: Do not report unknown uptime if server was started before client machine. Broken in r4020.

Application form 5,169 KB
100 downloads
Package 2,623 KB
71 downloads
4022 3 weeks ago

Use master.dbo.sysprocesses finally to get it running on all MS SQL versions

Application form 5,169 KB
56 downloads
Package 2,623 KB
47 downloads
4021 4 weeks ago

Show functions and triggers in MS SQL. See http://www.heidisql.com/forum.php?t=9671

Application form 5,169 KB
2,342 downloads
Package 2,623 KB
924 downloads
4020 4 weeks ago

Issue #2550: Use sys.sysprocesses instead of dbo.sysprocesses so this does not fail on old servers. Querying sys.sysprocesses may return an empty result for spid 1, so there is a default of -1 for FServerStarted now, which then reports "(unknown)" in the status bar.

Application form 5,169 KB
128 downloads
Package 2,622 KB
69 downloads
4019 4 weeks ago

Fix enabled controls which should be disabled when no SSL option selected.

Application form 5,169 KB
156 downloads
Package 2,622 KB
95 downloads
4018 4 weeks ago

Fix mixed up GRANT privilege in user manager, caused by errors and high complexity in regular expression. See issue #2671. Revert modification in SynRegExpr.pas again, now that we have only about 10 parentheses left.

Application form 5,169 KB
832 downloads
Package 2,623 KB
353 downloads
4017 4 weeks ago

Support GRANT .. REQUIRE syntax in user manager with a new "SSL options" tab. Fixes issue #2671.

Application form 5,169 KB
138 downloads
Package 2,623 KB
77 downloads
4016 1 month ago

Code cosmetic: Remove unused FColumns list, and set FConnection once instead of accessing outside instance.

Application form 5,166 KB
1,911 downloads
Package 2,621 KB
582 downloads
4015 1 month ago

Enable OK button when user types custom object name. Fixes issue #2669.

Application form 5,166 KB
57 downloads
Package 2,622 KB
46 downloads
4014 1 month ago

Fix empty tabSettings when creating very first session. Do less what flickers in ValidateControls, move pagecontrol related stuff in ListSessions.FocusChanged. Also, call FocusChanged event explicitly in SelectNode() when focus did not effectively change.

Application form 5,166 KB
955 downloads
Package 2,622 KB
324 downloads
4013 1 month ago

Fix unfocused active control after modifications. Introduces a new bug unfortunately, when creating the very first session.

Application form 5,166 KB
652 downloads
Package 2,622 KB
185 downloads
4012 1 month ago

Make session list and details pagecontrol custom resizable via splitter. Also, do not auto-adjust column width in session list, which has funny effects in some cases.

Application form 5,166 KB
75 downloads
Package 2,622 KB
45 downloads
4011 1 month ago

Remove LoginPrompt() function, create and use TfrmLogin instance like a normal form. That way, mysql_authentication_dialog_ask() can hide the labels and the irrelevant edit box.

Application form 5,165 KB
770 downloads
Package 2,622 KB
294 downloads
4010 1 month ago

Fix 3 compiler warnings

Application form 5,165 KB
479 downloads
Package 2,622 KB
180 downloads
4009 1 month ago

Quote password in plink command line, so it can contain spaces. Fixes issue #2667.

Application form 5,165 KB
62 downloads
Package 2,622 KB
59 downloads
4008 1 month ago

Follow up to r4002 and issue #2656: Set focus to textbox only if it's already shown, to avoid "Cannot focus a hidden or disabled control".

Application form 5,165 KB
63 downloads
Package 2,622 KB
53 downloads
4007 1 month ago

Extend hints on how to install MDAC on Wine. See issue #2660, comment #5.

Application form 5,165 KB
1,934 downloads
Package 2,621 KB
607 downloads
4006 1 month ago

Fall back from number to string comparison in CompareAnyNode, so equal numbers with word characters in them are sorted alphabetically. Fixes issue #2659.

Application form 5,165 KB
503 downloads
Package 2,622 KB
176 downloads
4005 1 month ago

MS SQL 2000 compatibility for SELECT TOP... Fixes issue #2662

Application form 5,165 KB
917 downloads
Package 2,623 KB
285 downloads
4004 1 month ago

Add context menu item in data grid for inserting a column's default value. Fixes issue #2654.

Application form 5,165 KB
312 downloads
Package 2,622 KB
161 downloads
4003 1 month ago

In TMainform.SetupSynEditors, check if loop editor variable really exists - which is not the case for at least one user. Fixes issue #2651.

Application form 5,164 KB
83 downloads
Package 2,622 KB
55 downloads
4002 1 month ago

Focus textbox when user clicks "Custom" in default-value selector. Fixes issue #2656.

Application form 5,164 KB
71 downloads
Package 2,622 KB
63 downloads
4001 1 month ago

Allow "DELIMITER xyz" not followed by some whitespace. Fixes issue #2655.

Application form 5,164 KB
63 downloads
Package 2,621 KB
59 downloads
4000 1 month ago

Use downward compatible queries for fetching table names on MS SQL 2000. Fixes issue #2661.

Application form 5,164 KB
75 downloads
Package 2,622 KB
59 downloads
3999 1 month ago

Follow up to previous commit: Catch more exceptions when creating the ADO handle. Most probably there are more I know of.

Application form 5,164 KB
66 downloads
Package 2,621 KB
65 downloads
3998 1 month ago

Creating an ADO handle throws exception if MDAC is missing, especially on Wine. Create that handle in TAdoDBConnection.SetActive, not in TAdoDBConnection.Create, and turn the exception into an EDatabaseError, so the caller gets a handled error. Additionally, display a possible solution in that error popup, which I found on http://forum.winehq.org/viewtopic.php?p=30653 . Fixes issue #2660.

Application form 5,164 KB
69 downloads
Package 2,622 KB
61 downloads
3997 1 month ago

Add some taskdialog style to login form.

Application form 5,164 KB
614 downloads
Package 2,622 KB
304 downloads
3996 1 month ago

Remove unused unit includes

Application form 5,163 KB
566 downloads
Package 2,622 KB
293 downloads
3995 1 month ago

Try to prevent event cycles to some DBtree code. Fixes issue #2645.

Application form 5,163 KB
65 downloads
Package 2,623 KB
63 downloads
3994 1 month ago

Remove unused variables

Application form 5,163 KB
165 downloads
Package 2,623 KB
90 downloads
3993 1 month ago

Revert r3979, move imported mysql_* functions from TDBConnection to a global var scope. Fixes issue #2647. Also, move MySQL related structures out of dbconnection.pas into mysql_structures.pas and const.inc.

Application form 5,163 KB
68 downloads
Package 2,623 KB
61 downloads
3992 1 month ago

Add basic support for pluggable authentication:
* Implement and export callback function "mysql_authentication_dialog_ask"
* Update libmysql.dll to the one from MariaDB 5.2.10
* Copy dialog.dll from MariaDB into plugins subfolder
* Modify installer so it creates the plugins folder and its dll files
* Fixes issue #2658

Application form 5,159 KB
301 downloads
Package 2,622 KB
131 downloads
3991 1 month ago

Fix rare errors when passing a broken list of databases via session manager. See http://www.heidisql.com/forum.php?t=9550

Application form 5,158 KB
2,027 downloads
Package 2,615 KB
758 downloads
3990 1 month ago

Do not access char at non existent position in a string. Introduces CharAtPos function. Fixes issue #2649.

Application form 5,158 KB
127 downloads
Package 2,615 KB
80 downloads
3989 2 months ago

Fix broken sorting logic for positive small numbers, broken in r3987.

Application form 5,158 KB
1,850 downloads
Package 2,615 KB
584 downloads
3988 2 months ago

Do not store and restore old value of FOREIGN_KEY_CHECKS variable, just set it to 0 when beginning to export, and to 1 again at the end. Should prevent from running into "'foreign_key_checks' can't be set to the value of 'NULL'" error when disconnects happen within export process. Fixes issue #2500.

Application form 5,158 KB
386 downloads
Package 2,615 KB
155 downloads
3987 2 months ago

Use numeric sorting approach instead of string comparison for negative numbers. Fixes issue #2519.

Application form 5,158 KB
79 downloads
Package 2,615 KB
78 downloads
3986 2 months ago

Add support for SQL Server 2008 when fetching database names. Fixes issue #2550.

Application form 5,158 KB
83 downloads
Package 2,615 KB
82 downloads
3985 2 months ago

Refreshing datagrid result while connection is cut triggers SelectedTableColumns to reset implicitly in ConnectionReady > DBTreeFocusChanged > ParseSelectedTableStructure. Add an explicit Connection.Ping(true) before firing any query in DatagridBeforePaint, and merge code from ParseSelectedTableStructure into DBTreeFocusChanges. Fixes issue #2644.

Application form 5,158 KB
3,974 downloads
Package 2,615 KB
880 downloads
3984 2 months ago

Fix non logged errors, caused by late non executed code in a try block. Fixes issue #2646.

Application form 5,158 KB
1,127 downloads
Package 2,615 KB
340 downloads
3983 2 months ago

Use -- for line comments, not #, to support MS SQL also in export files.

Application form 5,158 KB
2,894 downloads
Package 2,615 KB
555 downloads
3982 2 months ago

Fix wrong offset when stripping trailing comma for MS SQL table structure export. See http://www.heidisql.com/forum.php?t=9449

Application form 5,158 KB
180 downloads
Package 2,616 KB
114 downloads
3981 2 months ago

Ensure there are no open result sets when destroying open connections. Fixes an access violation when closing Heidi, caused by accessing Connection.mysql_somefunction() in TMySQLQuery.Destroy. See http://www.heidisql.com/forum.php?t=9508

Application form 5,158 KB
658 downloads
Package 2,615 KB
494 downloads
3980 2 months ago

Late commit for 6.0 installer image

Application form 5,158 KB
666 downloads
Package 2,615 KB
302 downloads
3979 2 months ago

Encapsulate mysql_* functions as class methods of TDBConnection, and give each instance of TDBConnection its own libmysql handle. This way, we can release the lib handle after each disconnect. Also, this opens up some new possibilities:
* use different libmysql.dll versions per connection
* overload mysql_* functions

Application form 5,158 KB
108 downloads
Package 2,620 KB
115 downloads
3978 2 months ago

Auto build installer by InnoSetup command line

Application form 5,157 KB
83 downloads
Package 2,619 KB
105 downloads
3977 2 months ago

Use APPNAME constant from const.inc for SetVersion, and prefer "HeidiSQL 6.0.0.1234 32 Bit" over "A lightweight MySQL client" for the EXE description.

Application form 5,157 KB
6,603 downloads
 
3976 2 months ago

Do not modify SQL_MODE when exporting, just do that temporarily before creating triggers. Avoids running into errors when e.g. ANSI_QUOTES is turned on. Fixes issue #2619.

Application form 5,157 KB
1,396 downloads
 
3975 2 months ago

Place "Preferences" item in system menu of session manager, so users are able to configure stuff without the need to connect first.

Application form 5,157 KB
4,462 downloads
 
3974 2 months ago

Fix unresponsive updownPort + editPort when modifying its value. Broken in r3972.

Application form 5,157 KB
9,714 downloads
 
3973 2 months ago

Ignore different column in ListSessions.FocusChanged event, so modifications do not get discarded silently when user clicks the "wrong" area.

Application form 5,157 KB
120 downloads
 
3972 3 months ago

Add support for integrated Windows authentication on SQL Server. See http://www.heidisql.com/forum.php?t=8856

Application form 5,157 KB
490 downloads
 
3971 3 months ago

Adjust regular expression in ParseViewStructure so it gracefully matches broken code from SHOW CREATE VIEW. Fixes issue #2563 .

Application form 5,156 KB
405 downloads
 
3970 3 months ago

Remember column widths in data grid before clearing header. Fixes issue #2511.

Application form 5,156 KB
804 downloads
 
3969 3 months ago

Store selected database object and its properties in a copied TDBObject, instead of referencing an item from TDBConnection.FDatabases[x]. Not sure if that's a good idea as there may be logic somewhere which now updates the temporary copy, not the reference. But at least this fixes issue #2579.

Application form 5,156 KB
886 downloads
 
3968 3 months ago

Try again a fix for SynEdit exceptions, similar to what I've already tried in r3922. The approach was right, only there was Mainform.SetupSyneditors accessing all TSynMemos in a thread when reconnecting.
* fixes issue #2605
* should also fix issue #2545
* reverts r3924 and r3925 (SynEdit modifications which should not be required any longer now that logging is postponed for the mainthread)

Application form 5,156 KB
1,624 downloads
 
3967 3 months ago

Add new quick filter menu item "Column IN (...)". Fixes issue #2606

Application form 5,145 KB
176 downloads
 
3966 3 months ago

Provide option "tabs to spaces" in preferences dialog. For space reasons, move highlighter options to new tab "Highlighter". Also, unify padding on tab sheets, and move "Ask for saving files" option to "SQL" tab.

Application form 5,145 KB
2,098 downloads
 
3965 3 months ago

Fix memory leak

Application form 5,145 KB
159 downloads
 
3964 3 months ago

Add "truncate table" feature to text import dialog. See http://www.heidisql.com/forum.php?t=9367

Application form 5,145 KB
124 downloads
 
3963 3 months ago

Add support for Windows 7 task button progress. Unify all callers of ProgressBarStatus in a set of 5 functions in main unit instead of helpers, as this is where the progress bar is placed and also we need the handle of the main window.

Application form 5,144 KB
1,723 downloads
 
3962 3 months ago

Unformat local formatted floats in WHERE clause for grid updates. Probably fixes issue #2558.

Application form 5,143 KB
2,049 downloads
 
3961 3 months ago

Export VIEWs with alternative version of SELECT code. Follow up to r3941, see issue #2546.

Application form 5,143 KB
191 downloads
 
3960 3 months ago

Populate database pulldown with dbs from current connection in export window. Fixes issue #2572.

Application form 5,143 KB
136 downloads
 
3959 3 months ago

Make regex for detection of VIEW name more stable against international characters. Fixes issue #2578.

Application form 5,143 KB
150 downloads
 
3958 3 months ago

Confirm overwriting grid export output file. Fixes issue #2596.

Application form 5,143 KB
244 downloads
 
3957 3 months ago

Update VirtualTree component to r320

Application form 5,142 KB
2,220 downloads
 
3956 4 months ago

Fix non-used database in reconnect, caused by too early DoAfterConnect which triggers OnConnected event, which again triggers DBTreeFocusChanged which triggers grid updates. Fixes issue #2573

Application form 5,142 KB
7,713 downloads
 
3955 4 months ago

Merge main menu items "Import" and "Export" into "Tools" menu.

Application form 5,142 KB
216 downloads
 
3954 4 months ago

Take hidden primary key columns into account when tbtnDataColumns gets its ImageIndex.

Application form 5,142 KB
211 downloads
 
3953 4 months ago

Place some reasonable messages on status bar while deleting (many) grid rows. Fixes issue #2576.

Application form 5,142 KB
164 downloads
 
3952 4 months ago

Add support for routine parameters in completion proposal of stored routine editor. Fixes issue #2555.

Application form 5,142 KB
3,674 downloads
 
3951 4 months ago

Sort font names alphabetically in SQL font selector. Fixes issue #2569.

Application form 5,141 KB
181 downloads
 
3950 4 months ago

Include sample editor on preferences dialog in SetupSynEditors, so settings get applied when preferences dialog opens. Fixes issue #2568

Application form 5,141 KB
163 downloads
 
3949 4 months ago

Revert r3938, and add backticks around identifiers again, so ParseTableStructure can detect column for "copy columns" feature. Fixes issue #2540.

Application form 5,141 KB
3,607 downloads
 
3948 4 months ago

Delete node so treeIndexes.Repaint does not expect old children in moved up node. Todo: Bind FKeys to tree nodes if that's possible with deleted keys. Fixes issue #2557.

Application form 5,141 KB
192 downloads
 
3947 4 months ago

Deactivate toAutoScrollOnExpand in object selector, so 1st level nodes do not get out of sight when un/checking one of them.

Application form 5,141 KB
5,166 downloads
 
3946 4 months ago

TMySQLConnection.GetThreadId requires the connection to be active. Fixes issue #2561.

Application form 5,141 KB
333 downloads
 
3945 5 months ago

Do not replace two single quotes which are not used to present one escaped single quote. Fixes issue #2560.

Application form 5,141 KB
984 downloads
 
3944 5 months ago

Primary key columns can be hidden in data grid. Pressing home key has to use first visible column instead of column 0. Fixes issue #2559.

Application form 5,141 KB
1,399 downloads
 
3943 5 months ago

Fix broken link to plink.exe, prefer a link to the download page over the .exe, as that link is obviously randomly mirrored, while there are disappearing mirrors over time.

Application form 5,141 KB
1,902 downloads
 
3942 5 months ago

Process escaped single quote in TDBConnection.UnescapeString. Mentioned in issue #2546.

Application form 5,141 KB
3,974 downloads
 
3941 5 months ago

Attempt to preserver original VIEW code, by selecting text from the server's .frm file. Fixes issue #2546.

Application form 5,141 KB
1,042 downloads
 
3940 5 months ago

Issue #1289: Add some basic code to the "analyze" button, which detects missing tables in target database.

Application form 5,140 KB
4,235 downloads
 
3939 5 months ago

Catch more types of potential exceptions in image preview box. See http://www.heidisql.com/forum.php?t=8980

Application form 5,125 KB
280 downloads
 
3938 5 months ago

Remove redundant backticks in table editors CREATE and ALTER code. See http://www.heidisql.com/forum.php?t=9056

Application form 5,125 KB
3,089 downloads
 
3937 5 months ago

* disable controls as long as no session is selected.
* check all option check boxes by default

Application form 5,125 KB
1,021 downloads