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

-- The End --

原文地址:https://www.cnblogs.com/hxlasky/p/13992583.html