mysql 5.6.35 my.cnf_3分钟内快速部署MySQL5.6.35数据库实践

1、下载软件

wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz

2、解压移动

1.useradd -s /sbin/nologin -M mysql

2.tar xf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz

3.mkdir -p /application

4.mv mysql-5.6.35-linux-glibc2.5-x86_64 /application/mysql-5.6.35-linux-glibc2.5-x86_64

5.cd /application/mysql-5.6.35/

3、初始化数据库

1. ./scripts/mysql_install_db   --basedir=/application/mysql-5.6.35/

--datadir=/application/mysql-5.6.35/data/ --user=mysql

2. sed -i 's#/usr/local/mysql#/application/mysql-5.6.35#g'          /application/mysql/bin/mysqld_safe       /application/mysql/support-files/mysql.server

3. cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld

4. chown -R mysql.mysql /application/

4.设置环境变量

第一种：cp /application/mysql/bin/*  /usr/local/sbin/

第二种：vim /etc/profile 添加如下：

PATH=/application/mysql/bin:$PATH

source  /etc/profile

5.设置/etc/my.cnf,在[mysqld]里添加如下：

[mysqld]

datadir=/application/mysql/data

basedir=/application/mysql

socket=/tmp/mysql.sock

user=mysql

6、启动登录

/application/mysql-5.6.35/bin/mysqld_safe &

lsof -i :3306