Solutions for Day to Day Technical Problems

Category Archives: mysql

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 →

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 →

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 →

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 →