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