主机安装[容器]部分可忽略
创建容器[容器]
docker run -itd --name mycat --privileged=true centos:7.9.2009 /usr/sbin/init
docker exec -it 26a7b7740b39 /bin/bash
准备工作
安装java[容器]
yum install java
[root@574ab73efc24 /]# java -version
openjdk version "1.8.0_332"
OpenJDK Runtime Environment (build 1.8.0_332-b09)
OpenJDK 64-Bit Server VM (build 25.332-b09, mixed mode)
安装wget[容器]
yum -y install wget
安装vim[容器]
yum -y install vim
卸载MariaDB
# 查看版本：
[root@localhost opt]# rpm -qa|grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
# 卸载
[root@localhost opt]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
# 检查是否卸载干净
rpm -qa|grep mariadb
卸载旧的mysql
rpm -qa | grep mysql
[root@localhost opt]# rpm -qa | grep mysql
mysql80-community-release-el8-4.noarch
[root@localhost opt]# yum remove mysql80-community-release-el8-4.noarch
[root@localhost opt]# find / -name mysql
/etc/selinux/targeted/active/modules/100/mysql
/usr/lib64/mysql
/usr/share/mysql
[root@localhost opt]# rm -rf /etc/selinux/targeted/active/modules/100/mysql
[root@localhost opt]# rm -rf /usr/lib64/mysql
[root@localhost opt]# rm -rf /usr/share/mysql
[root@localhost opt]# rpm -pa | grep mariadb
源码安装
下载mysql
加速站
yum update ca-certificates -y
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-8.0/mysql-8.0.29-el7-x86_64.tar
tar -xvf mysql-8.0.29-el7-x86_64.tar
tar -zxvf mysql-8.0.29-el7-x86_64.tar.gz
mv mysql-8.0.29-el7-x86_64 mysql
mv mysql /usr/local/
cd /usr/local/mysql
mkdir mysqldb
mysql安装目录赋予权限
chmod -R 777 /usr/local/mysql
创建组
[root@localhost mysql]# pwd
/usr/local/mysql
groupadd mysql
创建用户(-s /bin/false参数指定mysql用户仅拥有所有权，而没有登录权限)
useradd -r -g mysql -s /bin/false mysql
将用户添加到组中
chown -R mysql:mysql ./
解决中文乱码[容器]
[root@a8fedf6f30e8 mysql]# export LANG=en_ZW.utf8
[root@a8fedf6f30e8 mysql]# source /etc/profile
[root@a8fedf6f30e8 mysql]# vim /etc/profile
LANG=en_ZW.utf8
[root@a8fedf6f30e8 mysql]# source /etc/profile
修改mysql配置文件 vi /etc/my.cnf
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=/usr/local/mysql
# 设置mysql数据库的数据的存放目录
datadir=/usr/local/mysql/mysqldb
# 允许最大连接数
max_connections=10000
# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统
max_connect_errors=10
# 服务端使用的字符集默认为UTF8
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 默认使用“mysql_native_password”插件认证
default_authentication_plugin=mysql_native_password
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8
安装依赖库libaio[容器]
yum install -y libaio
yum -y install numactl.x86_64
rpm -qa|grep libaio
安装mysql
cd /usr/local/mysql/bin/
./mysqld --initialize --console
密码:S)oBeoS;q6LV
2022-07-02T09:04:18.017337Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: S)oBeoS;q6LV
启动mysql服务
cd /usr/local/mysql/support-files
chmod -R 777 /usr/local/mysql
./mysql.server start
将mysql添加到系统进程中
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
此时我们就可以使用服务进程操作mysql了
设置mysql自启动
chmod +x /etc/init.d/mysqld
systemctl enable mysqld
[root@localhost support-files]# chmod +x /etc/init.d/mysqld
[root@localhost support-files]# systemctl enable mysqld
mysqld.service is not a native service, redirecting to /sbin/chkconfig.
Executing /sbin/chkconfig mysqld on
设置环境变量
vim /etc/profile
MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
source /etc/profile
修改root用户登录密码
登录mysql
cd /usr/local/mysql/bin/
./mysql -u root -p
mysql> alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
设置允许远程登录
mysql> use mysql
mysql> update user set user.Host='%'where user.User='root';
mysql> flush privileges;
mysql> quit
重启服务且测试
systemctl restart mysql
systemctl status mysql
查看防火墙开放端口
firewall-cmd --list-all
在防火墙中将3306端口开放
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload
//--permanent为永久生效，没有此参数 服务器重启后配置失效
# 关闭防火墙
systemctl stop firewalld.service
# 查看防火墙状态
firewall-cmd --state
