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”
• How to Solve MySQL Startup error: mysql-bin.index not found (Errcode: 13)
• 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’
• MYSQL Login Error: mysqladmin: connect to server at ‘localhost’ failed
• How to Solve MYSQL error “no directory, logging in with home = -“
• How to Solve MYSQL Error: Can’t create test file xxx lower-test
• Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
• When MySQL uses select statement to export table data, error 1290 is reported