Linux下快速部署MySQL資料庫

Linux下快速部署MySQL資料庫
一.下載對應的軟體版本

：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 startStarting MySQL.Logging to '/Data/apps/mysql-5.6.36/data/localhost.localdomain.err'...                                                         [確定][root@localhost mysql-5.6.36]# netstat -tnlpActive 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]# mysqlWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.6.36 MySQL Community Server (GPL)Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.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)mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || test               |+--------------------+4 rows in set (0.15 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 currentpassword for the root user.  If you've just installed MySQL, andyou haven't set the root password yet, the password will be blank,so you should just press enter here.Enter current password for root (enter for none): ...............................................................略