centos7执行sh文件_centos7 安装 mysql5.7 (复制粘贴系列)

• mysql 下载链接：https://downloads.mysql.com/archives/community/
• centos7 镜像下载链接：http://mirrors.aliyun.com/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

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 wgetwget 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/mysqlmkdir -p /home/logs/mysql# 创建mysql配置文件cat < /home/config/mysql/my.cnf[mysqld]character_set_server=utf8mb4basedir=/home/service/mysqldatadir=/home/service/mysql/dataport = 3306log-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=ONslow_query_log_file=/home/logs/mysql/slowquery.loglong_query_time=3log-queries-not-using-indexes=ONlower_case_table_names=1EOF

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

# 创建mysql安装脚本cat < /home/sh/mysql_install.shcd /home/servicetar -zxvf /home/service/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gzmv /home/service/mysql-5.7.30-linux-glibc2.12-x86_64 /home/service/mysqlgroupadd mysqluseradd -r -g mysql mysqlchown -R mysql:mysql /home/service/mysqlchown -R mysql:mysql /home/logs/mysqlcp -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/mysqlcp /home/service/mysql/support-files/mysql.server /etc/init.d/mysqlsed -i "s/^basedir=$/basedir=/home/service/mysql/g" /etc/init.d/mysqlsed -i "s/^datadir=$/datadir=/home/service/mysql/data/g" /etc/init.d/mysqlchkconfig --add mysqlchkconfig mysql onchkconfig --level 345 mysql onservice mysql startEOF

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

sh /home/sh/mysql_install.sh

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

cat <> /etc/profileexport MYSQL_HOME=/home/service/mysqlexport PATH=$PATH:$MYSQL_HOME/binEOF

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 mysqlservice start mysqlservice 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;