Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the method of installing and modifying the default storage path of mysql database". In daily operation, I believe that many people have doubts about the method of installing and modifying the default storage path of mysql database. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "installation of mysql database and modification of default storage path". Next, please follow the editor to study!

1. Mysql database installation

[root@zrbapp ~] #

[root@zrbapp ~] # ll / soft/mysql_software/

Total 196380

-rw-r--r-- 1 root root 25402568 Oct 31 23:51 mysql-community-client-5.7.25-1.el7.x86_64.rpm

-rw-r--r-- 1 root root 280904 Oct 31 23:51 mysql-community-common-5.7.25-1.el7.x86_64.rpm

-rw-r--r-- 1 root root 2271668 Oct 31 23:51 mysql-community-libs-5.7.25-1.el7.x86_64.rpm

-rw-r--r-- 1 root root 173130520 Oct 31 23:52 mysql-community-server-5.7.25-1.el7.x86_64.rpm

Drwxr-xr-x 2 root root 245 Oct 31 23:52 tool

[root@zrbapp ~] #

[root@zrbapp ~] # rpm-ivh / soft/mysql_software/*.rpm

Warning: / soft/mysql_software/mysql-community-client-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... # # [100%]

Updating / installing...

1:mysql-community-common-5.7.25-1.e## [25%]

2:mysql-community-libs-5.7.25-1.el7## [50%]

3:mysql-community-client-5.7.25-1.e## [75%]

4:mysql-community-server-5.7.25-1.e## [100%]

[root@zrbapp ~] #

[root@zrbapp ~] # systemctl start mysqld

[root@zrbapp ~] #

[root@zrbapp ~] # systemctl status mysqld

● mysqld.service-MySQL Server

Loaded: loaded (/ usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since Fri 2019-11-01 04:36:09 CST; 17s ago

Docs: man:mysqld (8)

Http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 10148 ExecStart=/usr/sbin/mysqld-daemonize-pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

Process: 10074 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 10151 (mysqld)

CGroup: / system.slice/mysqld.service

└─ 10151 / usr/sbin/mysqld-daemonize-pid-file=/var/run/mysqld/mysqld.pid

Nov 01 04:35:50 zrbapp02 systemd [1]: Starting MySQL Server...

Nov 01 04:36:09 zrbapp02 systemd [1]: Started MySQL Server.

[root@zrbapp ~] #

[root@zrbapp ~] #

2. Modify the default path of mysql database

[root@zrbapp mysql] #

[root@zrbapp mysql] # cat / etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128m

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128m

# sort_buffer_size = 2m

# read_rnd_buffer_size = 2m

Datadir=/var/lib/mysql-modify the default path to the specified location

Socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

Symbolic-links=0

Log-error=/var/log/mysqld.log

Pid-file=/var/run/mysqld/mysqld.pid

[root@zrbapp mysql] #

2.1 stop mysql data

[root@zrbapp mysql] # systemctl stop mysqld

2.2 package the mysql database

[root@zrbapp mysql] # cd / var/lib

[root@zrbapp mysql] # tar-cvf mysql.tar mysql

[root@zrbapp mysql] # ll / var/lib/mysql.tar

-rw-r--r-- 1 root root 126791680 Nov 1 06:03 / var/lib/mysql.tar

[root@zrbapp mysql] #

2.3 create the target storage path of the mysql database and assign group permissions

[root@zrbapp mysql] # mkdir-p / mysqldb

[root@zrbapp mysql] # chown-R mysql:mysql / mysqldb

[root@zrbapp mysql] # chown-R 755 / mysqldb

2.4 move the packaged mysql database to the target storage path (mysqldb)

[root@zrbapp mysql] # mv / var/lib/mysql.tar / mysqldb

2.5 enter the target storage path and extract the mysql database

[root@zrbapp mysql] # cd / mysqldb

[root@zrbapp mysql] # tar-xvf mysqldb.tar

2.6 modify the mysql database configuration file my.cnf

[root@zrbapp mysql] # vi / etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128m

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128m

# sort_buffer_size = 2m

# read_rnd_buffer_size = 2m

# datadir=/var/lib/mysql-Log out the original mysql database path

Datadir=/mysqldb/mysql-increase the target mysql database path

# socket=/mysqldb/mysql/mysql.sock

# if the socket path is modified, there is no need to consider keeping the mysql.sock file when deleting / var/lib/mysql data. This example remains the default!

Socket=/var/lib/mysql/mysql.sock

# socket path can remain the same, but note that when deleting the mysql file in the / var/lib/mysql directory, you need to keep the mysql.sock file, otherwise it will cause database startup failure.

# Disabling symbolic-links is recommended to prevent assorted security risks

Symbolic-links=0

Log-error=/var/log/mysqld.log

Pid-file=/var/run/mysqld/mysqld.pid

Wq!-and save the exit.

Delete all files except mysql.sock and mysql.sock.lock in the / var/lib/mysql directory. Currently, you can also choose not to delete them.

[root@zrbapp mysql] # ls

Auto.cnf ca.pem client-key.pem ibdata1 ib_logfile1 mysql.sock performance_schema public_key.pem server-key.pem

Ca-key.pem client-cert.pem ib_buffer_pool ib_logfile0 mysql mysql.sock.lock private_key.pem server-cert.pem sys

[root@zrbapp mysql] #

2.7 start the database and view the status

[root@zrbapp mysql] #

[root@zrbapp mysql] # systemctl start mysqld

[root@zrbapp mysql] #

[root@zrbapp mysql] # systemctl status mysqld

● mysqld.service-MySQL Server

Loaded: loaded (/ usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since Fri 2019-11-01 06:20:36 CST; 6s ago-the database starts normally

Docs: man:mysqld (8)

Http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 10348 ExecStart=/usr/sbin/mysqld-daemonize-pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

Process: 10331 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 10351 (mysqld)

CGroup: / system.slice/mysqld.service

└─ 10351 / usr/sbin/mysqld-daemonize-pid-file=/var/run/mysqld/mysqld.pid

Nov 01 06:20:33 zrbapp systemd [1]: Starting MySQL Server...

Nov 01 06:20:36 zrbapp systemd [1]: Started MySQL Server.

[root@zrbapp mysql] #

[root@zrbapp mysql] #

At this point, the study on "mysql database installation and modification of the default storage path" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.