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

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.

You may also be interested in:
  • How to create a temporary folder in Python
  • How to create a temporary file in C#
  • Java creates a temporary file and then automatically deletes the file when the program exits
  • Unix programming to create a temporary file with a fixed prefix code sharing
  • Detailed example of creating a temporary file using File.createTempFile

<<:  JavaScript implementation of a simple addition calculator

>>:  How to use nginx to simulate blue-green deployment

Recommend

Quick understanding and example application of Vuex state machine

Table of contents 1. Quick understanding of conce...

How to debug loader plugin in webpack project

Recently, when I was learning how to use webpack,...

React+ts realizes secondary linkage effect

This article shares the specific code of React+ts...

A tutorial on how to install, use, and automatically compile TypeScript

1. Introduction to TypeScript The previous articl...

Detailed explanation of the difference between docker-compose ports and expose

There are two ways to expose container ports in d...

Briefly understand the MYSQL database optimization stage

introduction Have you ever encountered a situatio...

MYSQL METADATA LOCK (MDL LOCK) theory and lock type test

Table of contents MYSQL METADATA LOCK (MDL LOCK) ...

MySQL deep paging (how to quickly paginate tens of millions of data)

Table of contents Preface Case optimization summa...

How to prevent Vue from flashing in small projects

Summary HTML: element plus v-cloak CSS: [v-cloak]...

How to use resize to implement image switching preview function

Key Points The CSS resize property allows you to ...

Detailed explanation of component development of Vue drop-down menu

This article example shares the specific code for...

Instructions for using the meta viewport tag (mobile browsing zoom control)

When OP opens a web page with the current firmwar...

Learn more about the most commonly used JavaScript events

Table of contents JavaScript events: Commonly use...

How to use MyCat to implement MySQL master-slave read-write separation in Linux

Table of contents Linux-Use MyCat to implement My...

JavaScript to switch multiple pictures

This article shares the specific code of JavaScri...