mysql数据库出现ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_a019_0.MYI'

为什么80%的码农都做不了架构师？>>>   

mkdir /var/lib/mysql/tmp

chown mysql:mysql /var/lib/mysql/tmp

修改/etc/my.cnf配置文件，在[mysqld]域加入：tmpdir = /var/lib/mysql/tmp

重启mysqld服务

转载于:https://my.oschina.net/xiaoerit/blog/3001868