centos 7 安裝mysql社区版

背景介绍

  学习falsk需要用到数据库，flask虽然有内置SQLite但是自己不熟悉，于是选择MYSQL。

目录

• 安装版本选择
• 安装MYSQL
• 登录MYSQL

版本选择

• 查看centos系统版本（ el7 为7.0版本）

[root@localhost ~]# uname -a
Linux localhost.localdomain 3.10.0-1160.6.1.el7.x86_64 #1 SMP Tue Nov 17 13:59:11 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

• 到MYSQL官网下载7.0版本的yum rpm包
  
  noarch任意硬件平台通用
  

• 查看rpm包内容, mysql-community.repo为MYSQL yum源

[root@localhost sql]# rpm2cpio mysql80-community-release-el7-7.noarch.rpm | cpio -div
./etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
./etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
./etc/yum.repos.d/mysql-community-debuginfo.repo
./etc/yum.repos.d/mysql-community-source.repo
./etc/yum.repos.d/mysql-community.repo
23 blocks

• 安装MYSQL yum源

[root@localhost ~]# rpm -ivh mysql80-community-release-el7-7.noarch.rpm
warning: mysql80-community-release-el7-7.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql80-community-release-el7-7  ################################# [100%]

• 检查MYSQL yum源是否安装成功, 存在以下几项，表示yum源安装成功

[root@localhost ~]# yum search mysql
mysql-community-server.x86_64 : A very fast and reliable SQL database server
mysql-community-client.x86_64 : MySQL database client applications and tools
mysql-community-client-plugins.x86_64 : Shared plugins for MySQL client applications
mysql-community-common.x86_64 : MySQL database common files for server and client libs
mysql-community-libs.x86_64 : Shared libraries for MySQL database client applications
mysql-community-devel.x86_64 : Development header files and libraries for MySQL database client applications

安装MYSQL

[root@localhost ~]# yum install -y mysql-community-server.x86_64
...
Installed:
  mysql-community-libs.x86_64 0:8.0.30-1.el7        mysql-community-libs-compat.x86_64 0:8.0.30-1.el7        mysql-community-server.x86_64 0:8.0.30-1.el7

Dependency Installed:
  mysql-community-client.x86_64 0:8.0.30-1.el7            mysql-community-client-plugins.x86_64 0:8.0.30-1.el7    mysql-community-common.x86_64 0:8.0.30-1.el7
  mysql-community-icu-data-files.x86_64 0:8.0.30-1.el7

登录MYSQL

• 查看MYSQL服务

systemctl status mysqld 查看mysql服务
systemctl start mysqld 启动mysql服务
systemctl stop mysqld 停止mysql服务

• 查看登录密码，mysql安装时，会设置默认密码并写入到/var/log/mysqld.log中

[root@localhost ~]# cat /var/log/mysqld.log | grep password
2022-09-12T03:25:24.898112Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: uwdaLnTal2<B

• 登录mysql, 请先启动mysql服务

[root@localhost ~]# mysql -u root -p
Enter password:

• 修改root用户密码

mysql> alter user 'root'@'localhost' IDENTIFIED BY 'Huawei12#$';
Query OK, 0 rows affected (0.01 sec)

常见错误

• 主机地址拼写错误

1. 主机地址拼写错误

mysql> ALTER USER 'root'@'localhosst' IDENTIFIED BY 'Huawei12#$';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.