mysql 5.7.29二进制安装

1.下载二进制msyql文件，解压，创建软链接

[root@localhost ~]# cd /usr/local/src/
[root@localhost ~]# wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# mv mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/
[root@localhost ~]# ln -sv /usr/local/mysql-5.7.29-linux-glibc2.12-x86_64/ /usr/local/mysql

 2.卸载老的mariadb-libs,并安装前置软件包

[root@localhost src]# rpm -qa | grep mariadb-libs
[root@localhost src]# yum remove mariadb-libs
[root@localhost src]# yum install libaio-devel

 3.配置环境变量

[root@localhost src]# vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH

[root@localhost src]# source /etc/profile

 4.建立用户，数据库目录及授权

[root@localhost src]# useradd -M -s /sbin/nologin mysql
[root@localhost src]# mkdir /data/mysql/data -p
[root@localhost src]# chown -R mysql.mysql /data/mysql/data/

 5.初始数据库

--initialize:对于密码复杂度进行定制，密码过期时间180天，为root@localhost设置临时密码
--initialize-insecure：无密码限制

# 默认方案
[root@localhost mysql]# mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data/

# 常规方案(推荐方法)
[root@localhost mysql]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data/

 6.配置my.conf

[root@localhost mysql]# vim /etc/my.cnf 

[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql/data
socket=/tmp/mysql.sock
server_id=6
port=3306
[mysql]
socket=/tmp/mysql.sock

 7.配置启动方案

# sys-v方法
[root@localhost mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

# systemd方法
[root@localhost mysql]# vim /usr/lib/systemd/system/mysqld.service 

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target

[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
#Restart=on-failure
#RestartPreventExitStatus=1
#PrivateTmp=false

 8.启动服务

# 创建数据库日志文件，授权
[root@localhost mysql]# mkdir /data/mysql/data/logs
[root@localhost mysql]# touch /data/mysql/data/logs/error.log 
[root@localhost mysql]# chown -R mysql.mysql /data/mysql/data/logs/


[root@localhost mysql]# systemctl start mysqld
[root@localhost mysql]# systemctl enable mysqld
[root@localhost mysql]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.29 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 

 9.修改root密码

# 登陆mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'P%^$^HUIHUIHH';