1. MySQL安装

1. 使用yum安装

shell
[root@marshal05 software]# yum -y install mysql57-community-release-el7-10.noarch.rpm

2. 如果出现如下错误

Loaded plugins: fastestmirrorLoading mirror speeds from cached hostfile * base: mirrors.bfsu.edu.cn * extras: mirrors.bfsu.edu.cn * updates: mirrors.bfsu.edu.cnbase                                                                | 3.6 kB  00:00:00     extras                                                              | 2.9 kB  00:00:00     updates                                                             | 2.9 kB  00:00:00     No package mysql57-community-release-el7-10.noarch.rpm available.Error: Nothing to do

3. 这是因为我们本地yum仓库中没有可用的mysql-server rpm包。执行下面的命令下载即可：

shell
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

4. 重新执行命令，进行安装

shell
yum -y install mysql57-community-release-el7-10.noarch.rpm

5. 安装mysql服务器

shell
yum -y install mysql-community-server

6. 出现错误

shell
warning: /var/cache/yum/x86_64/2.1903/mysql57-community/packages/mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql


The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.


 Failing package is: mysql-community-libs-compat-5.7.37-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

大致意思就是MySQL的GPG升级了，需要更新，如果是新安装的MySQL，执行以下脚本即可：

shell
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

然后再进行安装就好了

2.MySQL数据库设置

1. 首先启动MySQL

shell
systemctl start  mysqld.service

2. 查看MySQL运行状态，运行状态如图：

shell
systemctl status mysqld.service

3. 此时MySQL已经开始正常运行，不过要想进入MySQL还得先找出此时root用户的密码，通过如下命令可以在日志文件中找出密码：

shell
grep "password" /var/log/mysqld.log

4. 如下命令登录数据库：

shell
mysql -uroot -p

5. 此时不能做任何事情，因为MySQL默认必须修改密码之后才能操作数据库，如下命令修改密码：

shell
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

其中'new password'替换成你要设置的密码，注意:密码设置必须要大小写字母数字和特殊符号（,/';:等）,不然不能配置成功。

3. 开启mysql的远程访问

执行以下命令开启远程访问限制（注意：下面命令开启的IP是 192.168.19.128，如要开启所有的，用%代替IP）：

shell
grant all privileges on *.* to 'root'@'192.168.0.1' identified by 'password' with grant option;
flush privileges;

4. 更改mysql的语言

https://img.php.cn/upload/article/000/000/020/1c5e17ddef9c7c75af5ff6c96182ab64-14.png