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

1. mkdir /var/lib/mysql/tmp

2. chown mysql:mysql /var/lib/mysql/tmp

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

4. 重启mysqld服务   service mysqld restart