MySQL Error Number 1005 Can’t create table (errno: 150)

By: Techie on 22:18

Despite having proper  column mappings and type, when you are unable to establish foreign key relationship, look for 'Engine' they belonging to:

In this scenario, 'InnoDB' is the engine for both tables.

Read More

Mysql - Map users to access schema

By: Techie on 22:08

Grant all privilege to user for all tables

GRANT ALL PRIVILEGES ON <schema_name>.* TO '<user>'@'%' WITH GRANT OPTION;

Read More