What's this?
HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.
News 
-
10 Mar Issue statistics
* First bug report came in on April 19, 2006* We have a total of 1,753 issue reports (1,110 bugs, 639 enhancements)* 259 out of these are duplicates to other issues* 1,038 issues were fixed (726 bugs, 312 enhancements)* 392 invalid issues, marked as upstream, needinf... [read]
-
03 Mar Grid enhancements
Both grids in "Data" and "Query" tabs now support a variable row height. Very useful if you like to see more than the first line of text in table cells at once. Just increase the option "Lines of text in grid rows" in "Tools" > "Preferences" > "Data" to a highe... [read]
-
26 Feb SSL support added, and more
If you update to the latest build now, you will find a bunch of new SSL fields, used to select certificates and keys needed to connect to a SSL featured MySQL server. Thanks to SuperNiFF for posting most relevant code.Second thing is, you can specifiy a startup scrip... [read]
-
05 Feb Rewritten search + replace dialog, Loglevel settings
Two minor news today about nice new stuff in HeidiSQL:1. Rewritten search + replace dialog. Previously HeidiSQL used a default dialog provided by the Windows API, supporting only a small feature set, and including some nasty focussing bugs. Anyway, the new dialog can... [read]
-
30 Jan HeidiSQL 5.0 Beta available
A new release with lots of new features and bugfixes. To mention some of them:* Completely rewritten, homebrown database communication layer, supporting Unicode from the very beginning* Rewritten table editor, now supporting foreign keys and drag'n drop editing* Rewr... [read]
Features
- Generate nice SQL-exports
- Synchronize tables between two databases
- Manage user-privileges
- Import text-files
- Export table-data as CSV, HTML, XML and SQL
- Browse and edit table-data using a comfortable grid
- Create and edit tables, views, stored routines and triggers
- Bulk edit tables (move to db, change engine, collation etc.)
- Batch-insert ascii or binary files into tables
- Write queries with customizable syntax-highlighting and code-completion
- Pretty reformat disordered SQL
- Monitor and kill client-processes
- Connect to servers via commandline
- Find specific text in all tables of all databases of one server
- Optimize and repair tables in a batch manner
- And much more
MySQL version usage*
| MySQL 5.0 | 56.8% |
| MySQL 5.1 | 31.7% |
| MySQL 4.1 | 6.6% |
| MySQL 4.0 | 2.9% |
| MySQL 3.23 | 1.0% |
| MySQL 5.4 | 0.5% |
| MySQL 6.0 | 0.3% |
| MySQL 5.5 | 0.3% |
| MySQL 5.2 | 0.0% |
* Reported by 12225 HeidiSQL users over the last month, which have the statistics feature enabled in their preferences dialog. (Implemented in build r2497)