Liunx服务器yum镜像安装mysql8数据库

qq_37129192

已于 2023-06-18 00:27:01 修改

阅读量211

点赞数 1

文章标签：数据库服务器 mysql

于 2023-06-17 23:21:40 首次发布

本文链接：https://blog.csdn.net/qq_37129192/article/details/131265926

版权

1.查看是否有mariadb
rpm -qa|grep mariadb

在这里插入图片描述

2.进行卸载mariadb
rpm -e --nodeps mariadb-server
rpm -e --nodeps mariadb
rpm -e --nodeps mariadb-libs

下载MySQL源

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

安装MySQL源

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

安装完成后会在/etc/yum.repos.d/目录下生成两个repo文件
mysql-community.repo
mysql-community-source.repo

默认情况下自动安装最新版的MySQL，即8.0.32

yum -y install mysql-community-server

如果安装过程中出现报错Public key for mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm is not installed
重新导入新的密钥来解决该问题
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
执行完之后再执行安装
yum -y install mysql-community-server

启动MySQL

systemctl start mysqld  #启动MySQL
systemctl status mysqld  # 查看MySQL运行状态
systemctl stop mysqld  # 停止MySQL
systemctl restart mysqld  #  重启MySQL
systemctl enable mysqld  # 设置开机自启动MySQL

修改MySQL密码

#查看默认密码
grep "password" /var/log/mysqld.log

#登录MySQL数据库
mysql -uroot -p (回车)
Enter password：（输入上面获取到的密码，是隐形的，输入完之后回车）

在这里插入图片描述

#修改用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'jwdlh@Zxc1';
开启远程访问授权
 create user 'root'@'%' identified with mysql_native_password by 'jwdlh@Zxc1';
 grant all privileges on *.* to 'root'@'%' with grant option;
 flush privileges;

退出

exit

开放防火墙端口

 firewall-cmd --zone=public --add-port=3306/tcp --permanent
 firewall-cmd --zone=public --remove-port=3306/tcp --permanent
 firewall-cmd --reload

创建新账号并且赋值权限

1.先查看当前账号有没有权限
SELECT host,user,Grant_priv,Super_priv FROM mysql.user;
2.确保自己又授权权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
3.创建账号并且设置密码
CREATE USER 'test'@'%' IDENTIFIED BY '123456';
4.授予用户权限
grant all privileges on 数据库名.* to '账号'@'连接地址';
5.刷新一哈
flush privileges;