mysql安装-linux

参考来源：https://www.cnblogs.com/werr370/p/14633785.html

1、yum安装

1、卸载自带的数据库

rpm -qa|grep mari

rpm -e --nodeps ***

rpm -qa | grep mysql

2.下载MySQL仓库并安装

cd /etc/yum.repos.d/

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

yum -y install mysql80-community-release-el7-3.noarch.rpm

yum -y install mysql-community-server

上述命令报错，修改配置文件

vim mysql-community.repo

 

# 重新执行报错，错误：GPG 检查失败，

执行下列命令，

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

或者去官网去官网下载 Yum 资源包，下载地址为：https://dev.mysql.com/downloads/repo/yum/

 

 下载下来文件mysql80-community-release-el8-8.noarch.rpm

yum -y install mysql80-community-release-el8-8.noarch.rpm

　　

# 重新安装MySQL数据库即可

yum -y install mysql-community-server

 

问题1：cat /var/log/mysqld.log 查看日志出现：

Failed to initialize DD Storage Engine.
Data Dictionary initialization failed.

1、systemctl start mysqld 执行报错，查看日志

 参考来源：https://blog.csdn.net/qq_19394437/article/details/111409434

解决措施：

1、删除 mysql 数据库数据文件夹
>> rm -rf /var/lib/mysql

2、mysql 数据库初始化
>> mysqld --initialize --console

3、修改 /var/lib/mysql/ 权限
>> chown -R mysql:mysql /var/lib/mysql/

4、启动 MySQL 数据库
>> systemctl start mysqld

5、查看 MySQL数据库的状态
>> systemctl status mysqld

 顺便要先恢复配置文件，图上是默认情况

 

问题2：初始化MySQL数据库登录，密码如何查看？登不上？

# 查看初始密码

 cat /var/log/mysqld.log | grep password 

 # 初始密码登不上，配置文件加上skip-grant-tables，重启服务，登录成功

 

问题3：初始化MySQL数据库登录，默认密码修改失败？

mysql> alter user 'root'@'localhost' identified by 'Admin@888';

 报错：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

# 刷新MySQL的权限表

mysql> flush privileges;

重新执行成功

 

# 新建用户

mysql> CREATE USER 'mysql'@'localhost' IDENTIFIED BY 'Admin@888';

# 登录成功

 #为root用户赋予操作所有表的权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;

# 配置文件里去掉skip-grant-tables，重启服务，用户可以直接登录，不报错

2、 rpm安装

　# 通过rpm -ivh mysql-community-{模块名}-8.0.30-1.el7.x86_64.rpm --nodeps --force 按顺序安装common、libs、client、server，　

取包地址：

https://repo.mysql.com//

http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/

实际安装顺序：

mysql80-community-release-el7-3.noarch.rpm

mysql-community-common-8.0.34-1.el8.x86_64.rpm

mysql-community-client-plugins-8.0.34-1.el8.x86_64.rpm

mysql-community-libs-8.0.34-1.el8.x86_64.rpm

mysql-community-client-8.0.34-1.el8.x86_64.rpm

mysql-community-icu-data-files-8.0.34-1.el8.x86_64.rpm

mysql-community-server-8.0.34-1.el8.x86_64.rpm

# 安装完成后查看

3、mariadb安装

rpm -e --nodeps maridb*

rm -rf /var/lib/mysql/*

chown -R mysql:mysql /var/lib/mysql/

yum -y install mariadb*

systemctl start mariadb.service

systemctl status mariadb.service