Mysql ERROR 1005 (HY000): Can’t create table ‘TMP’ (errno: 13)
MAC

sudo chown -R mysql:mysql /usr/local/mysql/data/

Read More:

• About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
• MySQL error: can’t create table ‘..’（ errno:150 ）Solutions
• [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
• MySQL error 1451 23000 foreign key exception handling
• DB2 create table error – 104 42601 illegal symbol encountered in SQL statement
• MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
• ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./myapp’, errno: 39)
• 【Exception】mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table…
• mysql ERROR 1050 (42S01): Table already exists
• MySQL error: error 1010 (HY000) when deleting database
• ERROR 2005 (HY000): Unknown MySQL server host
• SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.
• ERROR 2000 (HY000): Unknown MySQL error
• MySQL partitions the existing tables of the data table
• Solve MySQL error 2002 (HY000)
• MySQL error: 1005 can’t create table (error: 150)
• Error 2005 (HY000) unkonw MySQL server host…
• Error 1396 (HY000): Operation create user failed for ‘xxx’ @’xxx ‘
• Question: cannot create windows service for mysql.error : 0 (install MySQL)
• Solution to error 2002 (HY000) in MySQL