linux_centos7_mysql-8.0.15安装-CSDN博客

本文链接：https://blog.csdn.net/tan1015956962/article/details/88619517

mysql的安装脚本,如果报缺依赖的话就手动补上,
我这是root下执行的,如果不是,脚本一些行记得前面加sudo

#!/bin/bash
sleep 1
echo "1秒后开始下载安装"
# 因为centos自带mysql分支mariadb,需要清一下
rpm -e --nodeps `rpm -qa | grep -i mariadb-libs`
sleep 1
mkdir mysqlpak ;cd mysqlpak

wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-common-8.0.15-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-libs-8.0.15-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-client-8.0.15-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-server-8.0.15-1.el7.x86_64.rpm

sleep 1
echo "开始安装"
rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm \
mysql-community-libs-8.0.15-1.el7.x86_64.rpm \
mysql-community-server-8.0.15-1.el7.x86_64.rpm \
mysql-community-client-8.0.15-1.el7.x86_64.rpm

systemctl start  mysqld.service
echo "初始密码"
grep "password" /var/log/mysqld.log

exit

下载mysqlrpm包
https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/
mysql-community-common-8.0.15-1.el7.x86_64.rpm
mysql-community-libs-8.0.15-1.el7.x86_64.rpm
mysql-community-server-8.0.15-1.el7.x86_64.rpm
mysql-community-client-8.0.15-1.el7.x86_64.rpm
用fileZilla上传,安装
如果有内置mariadb（mysql分支）
就会有mysql-community-libs-8.0.15与mariadb-libs冲突
删除mariadb-libs就可以正常安装，
今天在阿里云上安装使提示缺libaio,用yum install libaio.x86_64 libaio.x86_64

[root@node3 mysql]# rpm -qa | grep -i mariadb-libs
mariadb-libs-5.5.60-1.el7_5.x86_64
[root@node3 mysql]#  rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

[root@node3 mysql]# rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm mysql-community-libs-8.0.15-1.el7.x86_64.rpm mysql-community-server-8.0.15-1.el7.x86_64.rpm mysql-community-client-8.0.15-1.el7.x86_64.rpm

启动并查看状态

[root@node3 mysql]# systemctl start  mysqld.service
[root@node3 mysql]# systemctl status  mysqld.service

查看mysql的初始密码

[root@node3 mysql]# grep "password" /var/log/mysqld.log
2019 temporary password is generated for root@localhost: aqe-qat,-9hM    //临时密码 aqe-qat,-9hM

登录进mysql

[root@node3 mysql]# mysql -uroot -p
Enter password:

进数据库，修改密码
设置新密码：3种不同字符不少于8位否则报错error:1819

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';

开放数据库远程登录

mysql> use mysql;
mysql> create user 'root'@'%' identified by '我设置的原来的数据库密码';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

设置自动启动

[root@node3 mysql]# systemctl enable mysqld
[root@node3 mysql]# systemctl daemon-reload

服务器记得打开3306端口才能连接上
centos是
添加3306端口开放

firewall-cmd --zone=public --add-port=3306/tcp --permanent    （--permanent永久生效，没有此参数重启后失效）

重新载入

firewall-cmd --reload

参考这CentOS7使用firewalld打开关闭防火墙与端口
远程导入个小数据库过去，测试好使，写个先存着，下回我就直接用了。

redis安装

可以参考这个Redis的安装和部署

官网下载redis，或者用wget直接下载
http://download.redis.io/releases/redis-5.0.3.tar.gz
1.安装gcc，

yum install gcc

2.解压

tar  -zxvf redis-5.0.3.tar.gz

3.编译

cd redis-5.0.3
make

4.安装

make install PREFIX=/usr/local/redis

5.复制配置文件，慎用rm与mv命令

 cp redis.conf /usr/local/redis

6.后端启动

 vim /usr/local/redis/redis.conf  #将daemonize的值改为yes
 /usr/local/redis/bin/redis-server /usr/local/redis/redis.conf #启动

7.查看是否启动成功

ps -ef | grep -i redis

8.设置开机启动l

vim /etc/rc.local

添加

/usr/local/redis/bin/redis-server /usr/local/redis/redis.conf

最下面有用docker容器安装mysql的脚本,这个最简单(网速要好才行)
mysql-8.0.15安装脚本
创建脚本
vi docker_mysql_install.sh
将以下内容复制到新建脚本docker_mysql_install.sh里

#!/bin/bash
echo "2秒后安装docker"
sleep 2
yum -y install docker
#启动docker服务
systemctl start docker
#设置开机启动
systemctl enable docker
echo "查看docker状态"
systemctl status docker
echo "开放端口3306"
firewall-cmd --zone=public --add-port=3306/tcp --permanent
# 重启防火墙
firewall-cmd --reload
echo "开始拉取mysql镜像"
docker pull mysql
echo "创建MySQL容器"
# MYSQL_ROOT_PASSWORD=定义自己的root密码
docker run -di --name=d_mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql
docker ps -a
echo "docker,mysql安装完毕"
exit

授权chmod -755 docker_mysql_install.sh ; ./docker_mysql_install.sh
回车开始安装

参考官方安装文档更好更便捷