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 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环境变量

五、测试登录