CentOS安装MySQL_centos rpm安装mysql5.1.43

一、下载mysql rpm 包

  wge https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
1

二、使用rpm命令安装MySQL

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm 
1

2.1、cd /etc/yum.repos.d/

2.2、yum repolist enabled | grep ‘mysql’

2.3、yum repolist all | grep mysql

三、选择MySQL部署版本（可默认）

3.1、 yum repolist all | grep mysql

3.2、sudo yum-config-manager --disable mysql80-community

3.3、选择5.7版本：sudo yum-config-manager --enable mysql57-community

四、安装MySQL服务：sudo yum install mysql-community-server

报错：

五、解决方式

5.1、使用网络安装

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

失败：error: https://repo.mysql.com/RPM-GPG-KEY-mysql-2022: import read failed(2).

5.2、更新秘钥

wge -q -O - https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | apt-key add -
1

失败：-bash: apt-key: command not found

5.3、查看 https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 的内容发现是MySQL的秘钥；

5.4、查看/etc/yum.repos.d/mysql-community.repo文件获得MySQL秘钥的存放地址，并备份原秘钥文件

5.5、将 https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 的内容写入RPM-GPG-KEY-mysql当做秘钥

命令：wge -q -O - https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 > RPM-GPG-KEY-mysql
1

六、重新安装MySQL

七、启动、查看、关闭MySQL服务：

sudo service mysqld status\status\stop
1

八、修改密码：

MySQL第一次启动后会创建超级管理员账号root@localhost，初始密码存储在日志文件中：

grep ‘temporary password’ /var/log/mysqld.log
1

九、设置root用户远程访问

1、GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root@MySQL2022' WITH GRANT OPTION;
2、FLUSH PRIVILEGES;
1
2

执行命令报错：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
则先修改初始化密码

 ALTER USER USER() IDENTIFIED BY 'Admin2023';
1

十、设置编码UFT-8

SHOW VARIABLES LIKE 'character%';
1