Linux下快速部署MySQL資料庫 - WordPress 多站點站群

一. 下載對應的站群軟體版本
下載地址：http://mirrors.sohu.com/mysql/MySQL-5.6/

[root@localhost ~]# wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/sql-5.6.36-linux-glibc2.5-x86_64.tar.gz

二、解壓、配置使用者和許可權

[root@localhost ~]# mkdir -pv /Data/apps
[root@localhost ~]# tar xf mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz -C /Data/apps/
[root@localhost ~]# cd /Data/apps/
[root@localhost apps]# mv mysql-5.6.36-linux-glibc2.5-x86_64/ mysql-5.6.36
[root@localhost ~]# useradd -s /sbin/nologin -M mysql
[root@localhost ~]# chown -R mysql.mysql /Data/apps/mysql-5.6.36
[root@localhost ~]# cd /Data/apps/mysql-5.6.36

三、初始化資料庫

[root@localhost mysql-5.6.36]# cp support-files/my-default.cnf /etc/my.cnf
[root@localhost mysql-5.6.36]# ./scripts/mysql_install_db –basedir=/Data/apps/mysql-5.6.36/ –datadir=/Data/apps/mysql-5.6.36/data/ –user=mysql
[root@localhost mysql-5.6.36]# cp support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql-5.6.36]# chmod +x /etc/init.d/mysqld
[root@localhost mysql-5.6.36]# sed -i ‘s#/usr/local/mysql#/Data/apps/mysql-5.6.36#g’ /etc/init.d/mysqld #主要最後都沒有’/’
[root@localhost mysql-5.6.36]# service mysqld start
Starting MySQL.Logging to ‘/Data/apps/mysql-5.6.36/data/localhost.localdomain.err’.
.. [確定]
[root@localhost mysql-5.6.36]# netstat -tnlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 947/sshd
tcp 0 0 :::22 :::* LISTEN 947/sshd
tcp 0 0 :::3306

四、配置 MySQL 環境變數

[root@localhost mysql-5.6.36]# echo “export PATH=/Data/apps/mysql-5.6.36/bin:$PATH” > /etc/profile.d/mysql.sh
[root@localhost mysql-5.6.36]# . /etc/profile.d/mysql.sh

五、測試登入

root@localhost mysql-5.6.36]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.6.36 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.

mysql> select version();
+———–+
| version() |
+———–+
| 5.6.36 |
+———–+
1 row in set (0.05 sec)

六、配置安全策略 (建議)

[root@localhost mysql-5.6.36]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we’ll need the current
password for the root user. If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.

Linux 下快速部署 MySQL 資料庫

Linux 下快速部署 MySQL 資料庫