Download HeidiSQL 6.0

Various tools have been developed over time to manage a MySQL database. For example, there is phpMyAdmin, which manages via a web application. To manage a MySQL database from a Windows application, you can look at HeidiSQL. This makes it possible to perform most administrative tasks directly, such as synchronizing tables between different databases, importing and exporting data, and executing queries. The developers have released version 6.0 with the following announcement:

HeidiSQL 6.0 released

This is a new release of HeidiSQL, the result of 331 changes done after the previous 5.1 release. HeidiSQL 6.0 introduces many new features of which I’ll list the most important ones here:

• Tabs for multiple batch results or multiple procedure results in a query tab.
• Multiple connections in one application instance
• Editable query results
• Rewritten user manager, using GRANT and REVOKE syntax now
• Rewritten “Copy table” dialog and logic, supporting WHERE filters now
• Rewritten “Load text file” dialog and logic, supports client side parsing for situations where LOAD DATA is not allowed
• Rewritten SQL help dialog
• Query profiling in query tabs
• Introduce “Run current query” action (Shift+Ctrl+F9)
• Enhance detection of Unicode text files
• Server details hint when mouse over version status panel
• Internal image previewer for BLOBs
• LaTeX and Wiki markup output for grids
• ZEROFILL support in table editor
• Session manager: Prompt for username and password on demand
• Add support for TIME values ​​above 24 hours
• Tons of bug fixes