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

HTML checkbox Click the description text to select/uncheck the state

In web development, since the checkbox is small an...

MySQL MyISAM default storage engine implementation principle

By default, the MyISAM table will generate three ...

Detailed explanation of HTML basic tags and structures

1. HTML Overview 1.HTML: Hypertext Markup Languag...

Vue custom v-has instruction, steps for button permission judgment

Table of contents Application Scenario Simply put...

Issues and precautions about setting maxPostSize for Tomcat

1. Why set maxPostSize? The tomcat container has ...

How to use VIM editor in Linux

As a powerful editor with rich options, Vim is lo...

How to rename the table in MySQL and what to pay attention to

Table of contents 1. Rename table method 2. Notes...

js implements custom drop-down box

This article example shares the specific code of ...

Multiple ways to change the SELECT options in an HTML drop-down box

After the form is submitted, the returned HTML pag...

A colorful cat under Linux

Friends who have used the Linux system must have ...

Tips for designing photo preview navigation on web pages

<br />Navigation does not just refer to the ...

Example of how to embed H5 in WeChat applet webView

Preface WeChat Mini Programs provide new open cap...

Example code for implementing complex table headers in html table

Use HTML to create complex tables. Complex tables...

A brief talk about JavaScript variable promotion

Table of contents Preface 1. What variables are p...

The simplest form implementation of Flexbox layout

Flexible layout (Flexbox) is becoming increasingl...