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
mysql数据库出现ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_a019_0.MYI'
2022-09-21 22:52:57
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
mysql数据库出现ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_a019_0.MYI'