1. 查看操作系统是否有自带的mysql相干包并卸载
rpm -qa |grep mariadb||mysql||perconarpm -e mariadb-libs-5.5.68-1.el7.x86_64
如果报错依赖其余的什么包,也应用 rpm -e 卸载掉
2. 获取mysql的软件包
cd /opt; wget https://repo.huaweicloud.com/mysql/Downloads/MySQL-5.7/mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz
3. 装置和初始化mysql
# 解压并批改目录名称tar -zxvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gzmv mysql-5.7.31-linux-glibc2.12-x86_64 mysql# 创立用户及所属组groupadd mysql ; useradd -d /home/mysql -s /bin/bash -g mysql -m mysqlchown -R mysql:mysql /opt/mysql# 创立数据盘目录(有条件能够给/data01目录独自挂数据盘,没条件能够不挂)mkdir -p /data01/mysql-data/tmpmkdir -p /data01/mysql-data/logmkdir -p /data01/mysql-data/workdbschown -R mysql:mysql /data01/mysql-data/# 创立my.cnf文件,并输出以下内容:cd /opt/mysql;vim my.cnf### 以下为文件内容[mysqld]basedir = /opt/mysql/bind-address = 192.168.74.129datadir = /data01/mysql-data/workdbstmpdir = /data01/mysql-data/tmpport = 3306socket = /opt/mysql/lib/mysql.socklower_case_table_names = 1character-set-server = utf8 max_allowed_packet = 150Msql_mode = STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTIONlog-error = /data01/mysql-data/log/mysql-3306.logmax_connections = 1000event_scheduler = ON[mysql]default-character-set = utf8 socket = /opt/mysql/lib/mysql.sock# 批改文件权限chown mysql:mysql /opt/mysql/my.cnfcp -fr /opt/mysql/my.cnf /etc/my.cnf# 批改零碎配置文件,行尾申明path# vim /etc/profileexport PATH=$PATH:/opt/mysql/binexport PATH=$PATH:/etc/init.d# 加载环境变量source /etc/profile# 拷贝support文件cd /opt/mysql; cp -a ./support-files/mysql.server /etc/init.d/mysql.server# 初始化mysqlcd /opt/mysql; ./bin/mysqld --initialize --user=mysql --basedir=/opt/mysql --datadir=/data01/mysql-data/workdbs# 获取mysql初始密码相似于上面这样cat /data01/mysql-data/log/mysql-3306.log### 2021-03-04T02:13:45.980203Z 1 [Note] A temporary password is generated for root@localhost: gRaEoQl)z3eQ# 创立软连贯ln -s /opt/mysql /usr/local/mysqlln -s /opt/mysql/lib/mysql.sock /tmp/mysql.sock# 启动mysql服务systemctl enable mysql.servercd /opt/mysql/support-files ; mysql.server start; # 批改root用户名和明码mysql -uroot -pset password=password("123");grant all privileges on *.* to 'root'@'%' identified by '123' with grant option;flush privileges;use mysql;# 查看受权正确select host,user from user;exit
以上装置结束