Windows could not start the MySQL56 service on Local Computer. Error 193: 0xc1

I got this error while I was messing around with MySQL root password using command line. Apparently somehow I had managed to damage the mysqld.exe file (MySQL Daemon). I have read that there might be several reasons for this error.

Read More Windows could not start the MySQL56 service on Local Computer. Error 193: 0xc1

Some Useful MySQL Database MD5/ Binary(16)/ Bigint Search Performance Benchmarks

I have been trying to build an application which could have 50-100 million rows in a MySQL table, and my requirement is finding a unique string (varchar) record in this data set as fast as possible. Before deciding on the

Read More Some Useful MySQL Database MD5/ Binary(16)/ Bigint Search Performance Benchmarks

Error Code: 1651. Query cache is disabled restart the server with query_cache_type=1 to enable it

This is the annoying error message that you may get if you try to set query_cache_type variable on your MySQL Workbench. You have searched through many blogs and tech posts and still haven't found the solution to this message? Don't

Read More Error Code: 1651. Query cache is disabled restart the server with query_cache_type=1 to enable it