HeidiSQL - MySQL made easy

Latest posts in user forum

SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 13 / xrader00
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 13 / anse
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 13 / xrader00
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 13 / anse
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 12 / xrader00
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 12 / anse
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 12 / xrader00
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 12 / anse
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 12 / xrader00
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060) Mar 12 / xrader00
SQL error (1265): Data truncated for column Mar 12 / Soporose
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

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

13 Mar Mailing lists removed

Now that the move to Google Code is nearly 2 years ago, all SourceForge related stuff for HeidiSQL was removed today. That includes three mailing lists on which you probably were subscribed:* heidisql-devel* heidisql-issues* heidisql-commitsThe first one was only use... [read]
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]

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.4%
MySQL 5.1	32.2%
MySQL 4.1	6.3%
MySQL 4.0	3.0%
MySQL 3.23	1.0%
MySQL 5.4	0.4%
MySQL 5.5	0.3%
MySQL 6.0	0.2%
MySQL 5.2	0.0%

* Reported by 13247 HeidiSQL users over the last month, which have the statistics feature enabled in their preferences dialog. (Implemented in build r2497)