How to solve the problem that MySQL cannot start because it cannot create temporary files

Problem Description

I recently encountered a problem at work. MySQL failed to start. The error log was:

mysqld: Can't create/write to file '/tmp/ibfguTtC' (Errcode: 13)

Description: The /tmp directory cannot be written

Solution

Use the command ll -d /tmp to check the directory permissions.

Use chmod 1777 /tmp to set the correct permissions

Startup Success

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.