5.7.20 下载页面 https://dev.mysql.com/downloads/file/?id=473559
# 创建用户组
检查 id mysql
groupadd mysql
useradd -r -g mysql mysql
# 解压
tar -xvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
cd /usr/local/
mv mysql-5.7.20-linux-glibc2.12-x86_64 mysql
chown -R mysql.mysql /usr/local/mysql
yum -y install libaio
# 初始化数据库
cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US
# 获取初始登录密码 【shell界面会出现,或者相关日志可以查到】
root@localhost: tZAnKmkch8
# 配置cnf
cd /usr/local/mysql/support-files/
cp -rp my-default.cnf /etc/my.cnf
vim /etc/my.cnf
[mysqld]
collation-server =utf8_general_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
# 设置开机启动项
cp -rp mysql.server /etc/init.d/mysqld
# 使用service 提供服务
service mysqld start
export PATH="/usr/local/mysql/bin:$PATH"
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
mysql -uroot -p tZAnKmkch8
alter user root@'localhost' identified by '123456';