October 7, 2013
by Ketan Patel
0 comments
If you are using Load Data Infile and you get the error SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user This is an error where the database user that is used for database connection is missing a permission required … Continue reading
October 8, 2012
by Ketan Patel
0 comments
Like me, if you got the message “#1005 – Can’t create table (errno: 150)” when creating a new table, then chances are that Google Search gave you information that this is a foreign key constraint error. You go back, look … Continue reading
July 11, 2011
by Ketan Patel
2 Comments
So you got an error “SQL Error: 2006: MySQL server has gone away”. Like me if you were wondering where the heck did MySql go away. It was there when the script started. Ok, I am gonna tell you that … Continue reading
May 5, 2011
by Ketan Patel
16 Comments
I have been MySql Workbench for a long time now and I recommend everyone to use it for their database design needs. Today, I was exporting the mysql database design to .sql file and then importing the sql to mysql … Continue reading