HeidiSQL - MySQL made easy

Latest posts in user forum

SQL error (1265): Data truncated for column Mar 11 / anse
SQL error (1265): Data truncated for column Mar 11 / Soporose
Access denied errors in latest snapshots Mar 10 / anse
Access denied errors in latest snapshots Mar 10 / kalvaro
temp data revovery ? Mar 10 / anse
temp data revovery ? Mar 10 / devils86
User database name lenght problem Mar 10 / togropl
User database name lenght problem Mar 10 / anse
temp data revovery ? Mar 10 / anse
User database name lenght problem Mar 10 / sahiba
temp data revovery ? Mar 10 / devils86
SQL error (1265): Data truncated for column Mar 10 / anse
SQL error (1265): Data truncated for column Mar 10 / Soporose
SQL error (1265): Data truncated for column Mar 09 / anse
SQL error (1265): Data truncated for column Mar 09 / Soporose

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)