华为云centos 7 安装mysql

最新推荐文章于 2024-05-16 14:51:57 发布

doublelucklysnow

最新推荐文章于 2024-05-16 14:51:57 发布

阅读量305

点赞数

分类专栏： Linux 文章标签：华为云

本文链接：https://blog.csdn.net/doublelucklysnow/article/details/128112118

版权

Linux 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

重做系统后，先挂载盘

参照

CentOS 如何挂载硬盘 - 幻月无名 - 博客园

检查系统有没有安装mariadb

#检查mariadb是否安装
yum list installed | grep mariadb
#卸载mariadb
yum remove mariadb-libs
#删除文件
rm -rf /etc/my.cnf
rm -rf $(find / -name mysql)

安装mysql

wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

yum localinstall -y mysql57-community-release-el7-7.noarch.rpm

yum install -y mysql-community-server

最后报错了
Failing package is: mysql-community-client-5.7.40-1.el7.x86_64
GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

#在网上查
#原因：MySQL GPG 密钥已过期导致

#解决办法：执行一下命令，解决
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
#在重新安装
yum install -y mysql-community-server

启动修改密码

systemctl start mysqld.service

grep 'temporary password' /var/log/mysqld.log

mysql -u root -p

mysql> SET PASSWORD = PASSWORD('你的密码');

mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

mysql> flush privileges;

-- 远程允许访问
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;