centos7 安装 mysql5.7 (复制粘贴系列)

• mysql 下载链接：MySQL :: Download MySQL Community Server (Archived Versions)
• centos7 镜像下载链接：Index of /centos/7/isos/x86_64/
• 也可以在服务器上面：wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
• centos7两行命令部署(mysql+redis+nginx+jdk+mongodb)：centos7两行命令部署测试环境(mysql+redis+nginx+jdk+mongodb)_itjavaee的博客-优快云博客

1.创建基础目录（已经有的话，请跳过）

# 用来存储我们下载好的一些文件或者软件
mkdir -p /home/service
# 用来存储配置文件
mkdir -p /home/config
# 用来存储日志
mkdir -p /home/logs
# sh脚本
mkdir -p /home/sh

2. 下载或者上传mysql5.7的文件

yum install -y wget
cd /home/service
# 如果没有安装wget， yum install wget
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

3. 创建mysql配置文件（复制全部，粘贴运行就好了）

mkdir -p /home/config/mysql
mkdir -p /home/logs/mysql

# 创建mysql配置文件
cat <<'EOF'> /home/config/mysql/my.cnf
[mysqld]
character_set_server=utf8mb4
basedir=/home/service/mysql
datadir=/home/service/mysql/data
port = 3306
log-error=/home/logs/mysql/mysqld.log
#不开启sql严格模式
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
slow_query_log=ON
slow_query_log_file=/home/logs/mysql/slowquery.log
long_query_time=3
log-queries-not-using-indexes=ON
lower_case_table_names=1
#开启binlog
log-bin = /home/service/mysql/mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1
EOF

4.创建安装脚本（复制全部，粘贴运行就好了）

# 创建mysql安装脚本
cat <<'EOF'> /home/sh/mysql_install.sh
#避免error while loading shared libraries: libnuma.so.1: cannot open shared object file
yum -y install numactl.x86_64
cd /home/service
tar -zxvf /home/service/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
mv /home/service/mysql-5.7.30-linux-glibc2.12-x86_64 /home/service/mysql
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /home/service/mysql
chown -R mysql:mysql /home/logs/mysql
cp -rf /home/config/mysql/my.cnf /etc/my.cnf
/home/service/mysql/bin/mysqld --initialize --user=mysql --datadir=/home/service/mysql/data --basedir=/home/service/mysql
cp /home/service/mysql/support-files/mysql.server /etc/init.d/mysql
sed -i "s/^basedir=$/basedir=\/home\/service\/mysql/g" /etc/init.d/mysql
sed -i "s/^datadir=$/datadir=\/home\/service\/mysql\/data/g" /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
chkconfig --level 345 mysql on
service mysql start
EOF

5.执行脚本（复制全部，粘贴运行就好了）

sh /home/sh/mysql_install.sh

6. 添加到系统环境（复制全部，粘贴运行就好了）

cat <<'EOF'>> /etc/profile
export MYSQL_HOME=/home/service/mysql
export PATH=$PATH:$MYSQL_HOME/bin
EOF

7. 重新加载环境（复制全部，粘贴运行就好了）

source /etc/profile
# 检测是否安装完成
mysql -V

8.查看初始密码（复制全部，粘贴运行就好了）

grep 'password' /home/logs/mysql/mysqld.log
#2020-08-31T04:56:25.142596Z 1 [Note] A temporary password is generated for root@localhost: u6whd?esl0dI

安装完成啦，如果能帮到您，多多关注哦，谢谢，点个赞呗

题外话：mysql 停止，启动，重启

service stop mysql
service start mysql
service restart mysql

题外话：mysql 登录

mysql -u root -p
# 或者
/home/service/mysql/bin/mysql -u root -p

题外话：修改mysql 初始密码

SET PASSWORD = PASSWORD('123123');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;

或者
ALTER USER 'root'@'%' IDENTIFIED BY '123456';
flush privileges;

set password for root@localhost = password('123123');
flush privileges;

题外话：修改mysql授权IP登录

update user set host = '%' where user ='root';
flush privileges;