MySQL – ORDER BY does not sort data properly…
Imagine a developer working late at night trying to complete some simple queries for a report due the next day. No matter what she does, the resulting query will just…
Read moreMySQL – Help, I lost the Root password! Error number 1045
Have you ever seen the dreaded MySQL Error number 1045 Access denied for user ‘root’@’localhost’ (using password: YES)? Don’t worry, this is an easy to recover from situation. Just follow…
Read moreMySQL – ERROR 1005: Can’t create table (errno: 150) – INNODB
If you have seen this error, don’t worry, you are not alone. This error is often accompanied by a message that a table or file could not be created, and…
Read more