CentOS7安装mysql

yum安装

1.进入官网download页面

 

2.在cetnos7上安装

[root@localhost ~]# wget https://dev.mysql.com/get/mysql80-community-release-el7-4.noarch.rpm #下载mysql的yum源

[root@localhost ~]# rpm -ivh mysql80-community-release-el7-4.noarch.rpm #rpm安装mysql的yum源
警告：mysql80-community-release-el7-4.noarch.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...                          ################################# [100%]
正在升级/安装...
   1:mysql80-community-release-el7-4  ################################# [100%]

[root@localhost yum.repos.d]# ls #可以看到yum仓库有yum源了
CentOS-Base.repo       CentOS-fasttrack.repo  CentOS-Vault.repo
CentOS-CR.repo         CentOS-Media.repo      mysql-community.repo
CentOS-Debuginfo.repo  CentOS-Sources.repo    mysql-community-source.repo

[root@localhost yum.repos.d]# vim mysql-community.repo #把5.7的enabled打开8.0关闭，以5.7为例

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql


[root@localhost yum.repos.d]# yum -y install mysql-community-server #安装mysql5.7

 3.启动修改初始密码

[root@localhost yum.repos.d]# systemctl start mysqld 
[root@localhost yum.repos.d]# grep password /var/log/mysqld.log #过滤初始密码
2021-11-22T13:14:28.477117Z 1 [Note] A temporary password is generated for root@localhost: LtC5:r*WpyXg

[root@localhost yum.repos.d]# mysqladmin -u root -p'LtC5:r*WpyXg' password 'GG7g7#$%' 
#修改密码，注意密码的强度
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

 4.登录

[root@localhost yum.repos.d]# mysql -uroot -p'GG7g7#$%' #使用修改后的密码登录数据库
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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> alter user 'root'@'localhost' identified by 'GG77$$$'; #这是另一种修改root密码的方式