共計 6015 個字符，預計需要花費 16 分鐘才能閱讀完成。
這篇文章主要介紹“mysql 數據庫安裝和修改默認存儲路徑的方法”，在日常操作中，相信很多人在 mysql 數據庫安裝和修改默認存儲路徑的方法問題上存在疑惑，丸趣 TV 小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”mysql 數據庫安裝和修改默認存儲路徑的方法”的疑惑有所幫助！接下來，請跟著丸趣 TV 小編一起來學習吧！
1、mysql 數據庫安裝
[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、修改 mysql 數據庫默認路徑
[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 —- 修改默認路徑到指定位置
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 停止 mysql 數據
[root@zrbapp mysql]#
systemctl stop mysqld
2.2 將 mysql 數據庫打包
[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 創建 mysql 數據庫目標存儲路徑并賦屬組權限
[root@zrbapp mysql]#
mkdir -p /mysqldb
[root@zrbapp mysql]#
chown -R mysql:mysql /mysqldb
[root@zrbapp mysql]# chown -R 755 /mysqldb
2.4 將打包好的 mysql 數據庫移動到目標存儲路徑（mysqldb)
[root@zrbapp mysql]#
mv /var/lib/mysql.tar /mysqldb
2.5 進入目標存儲路徑解壓 mysql 數據庫
[root@zrbapp mysql]#
cd /mysqldb
[root@zrbapp mysql]# tar -xvf mysqldb.tar
2.6 修改 mysql 數據庫配置文件 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 —- 注銷掉原來 mysql 數據庫路徑
datadir=/mysqldb/mysql —- 增加目標 mysql 數據庫路徑
#socket=/mysqldb/mysql/mysql.sock
#socket 路徑若修改則在刪除 /var/lib/mysql 數據時則不用考慮保留 mysql.sock 文件，本例保持默認！
socket=/var/lib/mysql/mysql.sock
#socket 路徑可以保持不變，但注意在刪除 /var/lib/mysql 目錄的 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
wq! —- 并保存退出即可
刪除 /var/lib/mysql 目錄下除 mysql.sock 和 mysql.sock.lock 以外的所有文件，當前也可以選擇不刪除不影響
[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 啟動數據庫并查看狀態
[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 —- 數據庫啟動正常；
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]#
到此，關于“mysql 數據庫安裝和修改默認存儲路徑的方法”的學習就結束了，希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學習，快去試試吧！若想繼續學習更多相關知識，請繼續關注丸趣 TV 網站，丸趣 TV 小編會繼續努力為大家帶來更多實用的文章！
