wget mysql 5.7_centos7 安装 mysql5.7 (复制粘贴系列)

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

# 用来存储我们下载好的一些文件或者软件

mkdir -p /home/service

# 用来存储配置文件

mkdir -p /home/config

# 用来存储日志

mkdir -p /home/logs

# sh脚本

mkdir -p /home/sh

安装wget：yum install wget

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

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 < /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

EOF

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

# 创建mysql安装脚本

cat < /home/sh/mysql_install.sh

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 <> /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;

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

flush privileges;