1 在线安装

1.1 下载 mysql 的 yum 源

添加mysql的yum源存储库
wget https://dev.mysql.com/get/mysql80-community-release-el7-6.noarch.rpm
安装mysql的yum源存储库包
rpm -ivh mysql80-community-release-el7-6.noarch.rpm

1.2 安装并启动

yum -y install mysql-community-server
启动
systemctl restart mysqld.service
查看初始密码 a.Fhs cat /var/log/mysqld.log | grep “A temporary password”

1.3 初始化

mysql自己带的初始化程序
mysql_secure_installation
输入初始化密码

2 离线安装 RPM

2.1 https://dev.mysql.com/downloads/mysql/

2.2 安装并启动

解压
tar -xvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql
安装
cd /usr/local/mysql
yum install *.rpm
启动
systemctl restart mysqld.service
查看初始密码 a.Fhs cat /var/log/mysqld.log | grep “A temporary password”

3 初始化

mysql自己带的初始化程序
mysql_secure_installation
输入初始化密码

3 离线安装 TAR.XZ

https://dev.mysql.com/downloads/mysql/

xz -d mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
tar xvf mysql-8.0.20-linux-glibc2.12-x86_64.tar

tar -xvf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.20-linux-glibc2.12-x86_64 mysql
cd mysql
mkdir {data,etc,logs,tmp,sock}

groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql/

初始化基础信息 切记切记切记mysql8 一定要在初始化时设置 不区分大小写，不然后续修改和删除重装没区别
初始化后在原始my.con 下lower_case_table_names = 1 是无效的，所以一定要在初始化时加上 --lower-case-table-names=1
./mysqld --user=mysql --basedir=/app/mysql8 --datadir=/app/mysql8/data/ --initialize --lower-case-table-names=1

vim my.cnf

[mysqld]
user=mysql
port=3306
symbolic-links=0
bind-address=0.0.0.0
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/sock/mysql.sock
pid-file=/usr/local/mysql/tmp/mysqld.pid
log_error=/usr/local/mysql/logs/mysqld.log
max_connections=1000
lower_case_table_names=1
log_timestamps = SYSTEM
default-time_zone='+8:00'
character-set-server=utf8mb4
collation-server = utf8mb4_general_ci
default_storage_engine = innodb
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
innodb_file_per_table = 1
innodb_buffer_pool_size = 128M
#expire_logs_days = 3
#max_allowed_packet = 50M

[mysqld_safe]
pid-file=/usr/local/mysql/tmp/mysqld.pid
log_error=/usr/local/mysql/logs/mysqld.log

[client]
port=3306
default-character-set = utf8mb4
socket=/usr/local/mysql/sock/mysql.sock

[mysql]
default-character-set = utf8mb4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

./bin/mysqld --defaults-file=./etc/my.cnf --initialize

cp -a ./support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --add mysql

七、启动服务

service mysql start
service mysql status
ln -s /app/mysql8/bin/mysql /usr/bin
ls -l /usr/bin/mysql
/usr/bin/mysql -> /app/mysql8/bin/mysql

ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;
flush privileges;