Linux下快速部署MySQL數(shù)據(jù)庫
2018-02-03 05:04:54
10078
一.下載對(duì)應(yīng)的軟件版本
下載地址:http://www.tjdsmy.cn/mysql/MySQL-5.6/
[root@localhost ~]# wget -q http://www.tjdsmy.cn/mysql/MySQL-5.6/sql-5.6.36-linux-glibc2.5-x86_64.tar.gz
二、解壓、配置用戶和權(quán)限
[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
三、初始化數(shù)據(jù)庫
[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環(huán)境變量
[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
五、測(cè)試登錄
root@localhost mysql-5.6.36]# mysql
六、配置安全策略
[root@localhost mysql-5.6.36]# mysql_secure_installation