DiGiTSS Team's Programming experience with PHP, MySQL, Ajax, Javascript, jQuery, C# and Microsoft technologies
MySQL – The world’s most popular open source database
When we use GUI tools like HeidiSQL with MySQL Windows binaries – setup from MySQL.com might be creating issues like these. Because recently faced errors #1364 and #1133 both became visible while I did clean install of MySQL by downloading Windows Installer for MySQL 5.5.8 from MySQL.com and not while using it with MySQL as part of some WAMP package.
I have just downloaded and setup MySQL 5.5.8 community server for Windows (32bit Installer) from MySQL official downloads. After downloading while I tried connecting it with HeidiSQL 5.x I got following error “Problem while Creating new User (SQL Error (1364): Field ‘authentication_string’ doesn’t have a default value)”.
Table Views can be used as an unconventional way to avoid cross/multiple database connections sometimes..! Yes, it can be. I came across such case and found that it can be handy in some simple cases when we just want to avoid connection to another database on the same MySQL server and we can’t afford to create that table in the same database due to some reasons.
have been using HeidiSQL since more than three and half years now and I am really happy with it. I must say that we work with heavy database consisting of more than 400 tables and database size exceeding few GBs but HeidiSQL has never let us down. I have tried loading my development database with phpMyAdmin and SQL Buddy both but they just failed to load such a large database with few hundreds of tables..! But with HeidiSQL I never had any problem except I got some crashing sometime in newer 5.x version but I am sure all such things will be fixed in coming builds. I am not telling that there are no other good tools are available in the market but HeidiSQL is in premium open-source tool at free of cost. I remember I had written a post on HeidiSQL 4.x more than a year ago and today we are up with HeidiSQL 5.1.
Loading data from and to CSV or other tab delimited or similar file format is essential in day to day operation. With MySQL it is easy to load data into table using files and exporting data into CSV files is quite easy. No need to use any external tool it can be done right there from the query tool/command prompt, no specific GUI tool required.
In my projects we have to deal with exporting system/meta data sync with production server on a regular basis and this seems to be easier than using utilities provided by GUI tools, be it HeidiSQL, PHPMySQL, SQLYog or anything else. Though it depends on project to project and person to person but many times when we have to restore big backup created with HeidiSQL or SQLYog I have seen programs/database exhausted such that increasing packet size won’t help either. But mysqldump/mysql restore always been a piece of cake to walk with.
I am not sure how many MySQL developers are using HeidiSQL for development but I am sure those who are using it will be fan of some of it’s features.!
I have been using HeidiSQL tool for my php/mySQL development for a while now. (more than a year and half..!). Before few months I have upgraded to newer version of HeidiSQL which is 4.1 RC1. It has got quite new and exciting features, looks and skins are improved.
