【无标题】

​
​

活动地址：优快云21天学习挑战赛

第二章, linux安装
参考文章
https://blog.youkuaiyun.com/weixin_41645135/article/details/123781576?app_version=5.6.0&code=app_1562916241&csdn_share_tail=%7B%22type%22%3A%22blog%22%2C%22rType%22%3A%22article%22%2C%22rId%22%3A%22123781576%22%2C%22source%22%3A%22weixin_41645135%22%7D&ctrtid=DV36f&uLinkId=usr1mkqgl919blen&utm_source=app
感谢邦德老师, 记录下来备用
前言
1.环境确认
1.1操作系统
[root@jeames -]# cat /etc/redhat-release
Red Hat Enterprise Linux release 8.1 (Ootpa)
1.2防火墙
[root@jeames ~]# systemctl status firewalld
关闭防火墙systemctl stop firewalld取消开机自启动
[root@jeames -]# systemctl disable firewalld
Removed letc/systemd/system/multi-user.target.wants/firewalld.service.
Removed letclsystemd/system/dbus-org.fedoraproject.FirewallD1.service.

1.3 selinux关闭
[root@jeames~]# more /etc/sysconfig/selinux
修改letc/selinux/config 文件
将SELINUX=enforcing改为SELINUX=disabled口
重启机器即可
[root@jeames ~]# sestatus
SELinux status: disabled
[root@jeames ~]# getenforce
Disabled

2.MySQL二进制包下载
官网: https:/ldev.mysql.com/downloads/mysql/
安装包:
mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz

3.安装MySQL 5.7
3.1安装包解压
[root@jeames~]# mkdir /soft #二进制包解压
[root@jeames~]# mkdir -p /usr/local/mysqlsoft
[root@jeames一]# cd /soft/
tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysqlsoft
tar -Jxf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz -C /usr/local/mysqlsoft#快捷方式创建
[root@jeames ~]# mkdir -p /usr/local/mysql57
[root@jeames 一]# mkdir -p /usr/local/mysql80

3.2创建用户组
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /usr/local/mysqlsoft
[root@jeames soft]#t passwd mysql

3.3.本地yum安装依赖

创建挂载路径

mkdir -p /mnt/cdrom

挂载系统镜像光盘到指定目录

mount -t iso9660 /dev/sr0 /mnt/cdrom

cd /etc/yum.repos.d

修改yum源配置文件

vi rhel8-local.repo
[localREPO]
name=localhost8
baseurl=file:///mnt/cdrom/BaseOS
enable=1
gpgcheck=0

[localREPO_APP]
name=localhost8_app
baseurl=file:///mnt/cdrom/AppStream
enable=1
gpgcheck=0

##安装依赖包
yum install libaio
yum -y install perl perl-devel
yum install libncurses*
yum -y install autoconf
yum -y install numactl.x86_64

3.4初始化(5.7版本)
chown -R mysql.mysql /usr/local/mysql50##静默安装
/usr/local/mysql57/mysql5730/bin/mysqld --initialize-insecure --user=mysql –
basedir=/usr/local/mysql57/mysql5730 --datadir=/usr/local/mysql57/mysql5730/data
##配环境变量
echo"export PATH=$PATH:/usr/local/mysql57/mysql5730/bin">>/root/.bashrc
source /root/.bashrc

3.5启动数据库
mysqld_safe &

新增用户及修改密码
mysql> select user,host,authentication_string from mysql.user;

新增远程用户

mysql> grant all on . to root@"%'identified by ‘root’ with grant option;
mysql> flush privileges;
lt修改本地密码
set password for root(@‘localhost’=password(‘root’);
mysql> flush privileges;

4.模拟数据,准备升级
mysql> show variables like ‘innodb_fast_shutdown%’;
士---------------------土------+
|Variable_name | Value |士---------------------士------十 innodb_fast_shutdown | 1 l士---------------------士------+1 row in set (0.01 sec)
内存数据全部落盘
mysql> set global innodb_fast_shutdown=0;
mysq> create database jeames;
Query OK, 1 row affected (0.00 sec)
#关闭Mysql
mysqladmin -uroot -proot shutdown

5.MySQL 5.0升级8.0
5.1安装MySQL8.0.19
chown -R mysql.mysql /usr/local/mysql80

静默安装MySQL

/usr/local/mysql80/mysql8019/bin/mysqld --initialize-insecure --user=mysql
-basedir=/usr/local/mysql80/mysql8019 --datadir=/usr/local/mysql80/mysql8019/data

5.2修改mysql8配置文件
指向5.7的数据文件及错误日志路径vi/etc/my.cnf
[mysqld]
basedir=/usr/local/mysql80/mysql8019datadir=/usr/local/mysql57/mysql5730/dataport=3306
log-error=/usr/local/mysql57/mysql5730/data/log.errserver_id=80193306
log-bin
default_authentication_plugin=mysql_native_passwordcharacter_set_server=utf8mb4

5.3启动Mysq8019
cd /usr/local/mysql80/mysql8019/binmysqld_safe &
输入密码为:5.7版本的密码(root)

echo"export PATH=$PATH:/usr/local/mysql80/mysql8019/bin">>/root/.bashrcsource /root/.bashrc
此处记得要删除原来的环境变量

6 MySQL 1卸载
yum remove -y mysql --nodeps
yum remove -y mysql-community-* --nodepsrpm -qalgrep mysql|xargs rpm -e --nodepsrpm -qa / grep mysql
rpm -e mysql-community-embedded-devel-5.7.30-1.el7.x86_64 --nodepsrpm -e mysql-community-libs-5.7.30-1.el7.x86_64 --nodeps
rpm -e mysql-community-embedded-5.7.30-1.el7.x86_64 --nodeps
rpm -e mysql-community-embedded-compat-5.7.30-1.el7.x86_64 --nodepsrpm -e mysql-community-common-5.7.30-1.el7.x86_64 --nodeps
rpm -e mysql-community-devel-5.7.30-1.el7.x86_64 --nodeps
rpm -e mysql-community-libs-compat-5.7.30-1.el7.x86_64 --nodeps
rm -rf /var/lib/mysql
rm -rf /var/log/mysqld.log
rm -rf /usr/lib/mysql
rm -rf /usrlinclude/mysql
rm -rf /etc/my.cnf
rm -rf /run/locklsubsys/mysql
find / -iname mysql

​