DebugAH

How to Solve Your Programmer Error

Skip to content
  • Home
  • Linux
  • JAVA
  • Python
  • Javasript
  • MYSQL
  • Windows
  • Error

[Solved] MYSQL ERROR 1 (HY000): Can’t create/write to file ‘/tmp/#sql_a019_0.MYI’

Solution:

mkdir /var/lib/mysql/tmp

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

Modify the /etc/my.cnf configuration file by adding in the [mysqld] field: tmpdir = /var/lib/mysql/tmp

Restart mysqld service

Similar Posts:

  • How to Solve MYSQL Startup Error: “MySQL Daemon failed to start”
  • MySQL Error: The server quit without updating PID file [How to Solve]
  • How to Solve MySQL Startup error: mysql-bin.index not found (Errcode: 13)
  • [Solved] MYSQL Export Sheet Error: –secure-file-priv option so it cannot execute this statement
  • MySQL Error: the solution of command not found
  • Solution to the error of MySQL: unrecognized service (CentOS)
  • [Solved] MYSQL database adds timestamp field error: Invalid default value for’xxx’
  • How to Solve MYSQL error “no directory, logging in with home = -“
  • MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
  • How to Solve MYSQL Error: Can’t create test file xxx lower-test

This entry was posted in MYSQL and tagged ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_a019_0.MYI', mysql, MYSQL ERROR 1 (HY000) on June 25, 2021 by Robins.

Post navigation

← Python oserror: [errno 22] invalid argument: emergence and solution [Solved] MYSQL Error 1040 (HY000): too many connections →

Recent Posts

  • [Solved] Win-KeX/wsl2/kali Startup Error: A fatal error has occurred and VcXsrv will now exit.
  • [Solved] samtools: error while loading shared libraries: libcrypto.so.1.0.0: cannot open shared object file
  • k8s Error: [ERROR FileAvailable–etc-kubernetes-kubelet.conf]: /etc/kubernetes/kubelet.conf already exists
  • [Solved] NoSuchMethodError: org.springframework.boot.web.servlet.error.ErrorController.getErrorPath
  • [Solved] flink web ui Submit Task Error: Server Respoonse Message-Internal server error
  • Mysql Error: 1140 – In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column ‘a.store’; this is incompatible with sql_mode=only_full_group_by
  • [Solved] Mybatis multi-table query error: Column ‘id’ in field list is ambiguous
  • [Solved] fluentd Log Error: read timeout reached
  • [Solved] xgboost Load Module File Error
  • [Solved] npm install Error: github requires permissions, Permission denied (publickey)

Tags

  • )
  • android
  • android studio
  • CentOS
  • centos7
  • chrome
  • DebugAH
  • django
  • docker
  • eclipse
  • git
  • github
  • go
  • hadoop
  • Hive
  • IDEA
  • ios
  • java
  • jenkins
  • Linux
  • Mac
  • maven
  • MyBatis
  • mysql
  • nginx
  • No module named XXX error
  • npm
  • Oracle
  • php
  • pip
  • pycharm
  • Python
  • Python TypeError
  • redis
  • shell
  • spring
  • springBoot
  • ssh
  • SVN
  • tensorflow
  • tomcat
  • ubuntu
  • vue
  • Windows
  • Yum
Proudly powered by WordPress