mysql 5.7 rpm 安装_mysql5.7 rpm方式安装

tar -xvf mysql-5.7.32-1.el7.x86_64.rpm-bundle.tar

得到如下各文件:

mysql-community-client-5.7.32-1.el7.x86_64.rpm

mysql-community-common-5.7.32-1.el7.x86_64.rpm

mysql-community-devel-5.7.32-1.el7.x86_64.rpm

mysql-community-embedded-5.7.32-1.el7.x86_64.rpm

mysql-community-embedded-compat-5.7.32-1.el7.x86_64.rpm

mysql-community-embedded-devel-5.7.32-1.el7.x86_64.rpm

mysql-community-libs-5.7.32-1.el7.x86_64.rpm

mysql-community-libs-compat-5.7.32-1.el7.x86_64.rpm

mysql-community-server-5.7.32-1.el7.x86_64.rpm

mysql-community-test-5.7.32-1.el7.x86_64.rpm

1.删除掉mysql-libs

[root@hxlhost mysql]# mount /dev/cdrom /mnt

mount: /dev/sr0 is write-protected, mounting read-only

[root@hxlhost mysql]#  yum remove mysql-libs

2.按照如下顺序进行安装

rpm -ivh mysql-community-common-5.7.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.32-1.el7.x86_64.rpm

3.安装路径

[root@hxlhost mysql]# which mysql

/usr/bin/mysql

4.启动

[root@hxlhost mysql]# systemctl start mysqld

查看状态：

# systemctl status mysqld

5.登陆：

这种方式安装好后，会再my.cnf文件中自动生成一个密码，执行看一下吧：

[root@hxlhost mysql]# cat /var/log/mysqld.log | grep password

2020-11-17T01:26:13.319001Z 1 [Note] A temporary password is generated for root@localhost: _(V4*%4x.3&T

[root@hxlhost mysql]# mysql -h localhost -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.32

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

6.my.cnf文件

该文件路径为/etc/my.cnf

内容如下:

[root@hxlhost mysql]# more /etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid