Modify the default data directory of MySQL 8.0 (quick operation without configuration)

Modify the default data directory of MySQL 8.0 (quick operation without configuration)

Usage scenario: We use Alibaba Cloud and purchased a data disk separately (large space and can be used for backup). The MySQL 8.0 database is installed on the system disk by default. In order to consider security and space issues, we need to change the default database directory to another location (I use an SSD data disk here, by mounting)

Operating system: CentOS 7.6 Database: MySQL 8.0 To view more of my original articles, please click here

The default data directory location for MySQL 8.0 is: /var/lib/mysql

My target location is: /data/

Now let’s get started

1. First, we stop the MySQL 8.0 service and use the following command

[root@JasonSong ~]# sudo systemctl stop mysqld.service

Use the following command to check whether the service has stopped

[root@JasonSong ~]# sudo systemctl status mysqld.service
● mysqld.service – MySQL Server
  Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
  Active: inactive (dead) since Thu 2019-02-21 13:52:24 CST; 9s ago
   Docs: man:mysqld(8)
      http://dev.mysql.com/doc/refman/en/using-systemd.html
 Process: 6152 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
 Process: 6082 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 6152 (code=exited, status=0/SUCCESS)
  Status: "SERVER_SHUTTING_DOWN"

Feb 20 16:30:39 JasonSong systemd[1]: Starting MySQL Server...
Feb 20 16:30:50 JasonSong systemd[1]: Started MySQL Server.
Feb 21 13:52:21 JasonSong systemd[1]: Stopping MySQL Server...
Feb 21 13:52:24 JasonSong systemd[1]: Stopped MySQL Server.

2. Move the default data directory to the target location

[root@JasonSong ~]# mv /var/lib/mysql/ /data/

Soft link the target location to the original location and use the following command to create a soft link

[root@JasonSong ~]# ln -s /data/mysql /var/lib/

To check whether the link is successful, use the following command

[root@JasonSong ~]# ls -la /var/lib/mysql
lrwxrwxrwx 1 root root 11 Feb 21 14:00 /var/lib/mysql -> /data/mysql

After displaying the above information, you can start the MySQL service for testing.

[root@JasonSong ~]# sudo systemctl start mysqld.service
[root@JasonSong ~]# sudo systemctl status mysqld.service
● mysqld.service – MySQL Server
  Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
  Active: active (running) since Thu 2019-02-21 14:02:13 CST; 8s ago
   Docs: man:mysqld(8)
      http://dev.mysql.com/doc/refman/en/using-systemd.html
 Process: 21361 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 21379 (mysqld)
  Status: "SERVER_OPERATING"
  CGroup: /system.slice/mysqld.service
      └─21379 /usr/sbin/mysqld

Feb 21 14:02:12 JasonSong systemd[1]: Starting MySQL Server...
Feb 21 14:02:13 JasonSong systemd[1]: Started MySQL Server.

The above information is displayed, which means it is OK. To view more of my original articles, please click here.

This is the end of this article about changing the default data directory of MySQL 8.0 (quick operation without configuration). For more information about changing the default directory of MySQL, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • How to modify the data directory of MySQL 5.5 database under win2008 R2 server
  • Modify the MySQL 5.5 database data directory under Windows Server 2003
  • How to modify the mysql data directory under Win2008 r2
  • centos mysql modify database directory
  • How to modify the storage directory of Mysql database?

<<:  Detailed deployment of docker+gitlab+gitlab-runner

>>:  Vue calls the PC camera to realize the photo function

Recommend

Vue practice of preventing multiple clicks

Generally, click events will be divided into diff...

The difference between html, xhtml and xml

Development Trends: html (Hypertext Markup Languag...

Detailed explanation of the difference between cesllspacing and cellpadding in table

What is a table? It is composed of cell cells. In...

base target="" controls the link's target open frame

<base target=_blank> changes the target fram...

ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: YES) Practical solution

There was no problem connecting to the database y...

MySQL error: Deadlock found when trying to get lock; try restarting transaction solution

Find the problem Recently, when I was filling in ...

Implementing a simple calculator based on JavaScript

This article shares the specific code of JavaScri...

Steps to set up Windows Server 2016 AD server (picture and text)

Introduction: AD is the abbreviation of Active Di...

Element-ui's built-in two remote search (fuzzy query) usage explanation

Problem Description There is a type of query call...

Solutions to black screen when installing Ubuntu (3 types)

My computer graphics card is Nvidia graphics card...

MySQL 5.5.27 installation graphic tutorial

1. Installation of MYSQL 1. Open the downloaded M...

How to deploy SpringBoot project using Dockerfile

1. Create a SpringBooot project and package it in...

A simple way to change the password in MySQL 5.7

This is an official screenshot. After MySQL 5.7 i...

Detailed explanation of the use of HTML header tags

HTML consists of two parts: head and body ** The ...

Use of js optional chaining operator

Preface The optional chaining operator (?.) allow...