- 准备安装包
在中间件安装包中或下载如下版本的mysql安装文件:
mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar |
将文件上传到目标Linux系统的/opt/mysql/目录,没有此目录时,执行以下命令创建mysql目录:
mkdir mysql |
- 安装
cd /opt/mysql/ tar -xvf ./mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar #解压后内容如下所示: mysql-community-client-5.7.35-1.el7.x86_64.rpm mysql-community-common-5.7.35-1.el7.x86_64.rpm mysql-community-devel-5.7.35-1.el7.x86_64.rpm mysql-community-embedded-5.7.35-1.el7.x86_64.rpm mysql-community-embedded-compat-5.7.35-1.el7.x86_64.rpm mysql-community-embedded-devel-5.7.35-1.el7.x86_64.rpm mysql-community-libs-5.7.35-1.el7.x86_64.rpm mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm mysql-community-server-5.7.35-1.el7.x86_64.rpm mysql-community-test-5.7.35-1.el7.x86_64.rpm |
rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm --force --nodeps rpm -ivh mysql-community-client-5.7.35-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm --force --nodeps rpm -ivh mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm --force --nodeps |
如果报mariadb-libs错,先卸载mariadb-libs
rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm rpm -qa |grep mariadb mariadb-libs-5.5.68-1.el7.x86_64 rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64 |
初始化Mysql
mysqld --initialize --user=mysql |
查看生成的随机密码(最后一行)
cat /var/log/mysqld.log 记录下此密码,后面会用到,如下所示(每次密码并不相同): A temporary password is generated for root@localhost: Shd>sP:I<5ye |
启动数据库:
systemctl start mysqld.service |
查看状态:
service mysqld status #显示如下内容,表示运行中: Active: active (running) |
- 优化配置
#执行: sudo find / -name my.cnf #如下 /etc/my.cnf 编辑如上文件: vi /etc/my.cnf 在 [mysqld] 下加上: # 大小写不敏感为1 lower_case_table_names=1 # 修改最大连接数 max_connections=1000 |