3

CentOS7使用yum在线安装mysql5.7

 1 year ago
source link: https://blog.51cto.com/u_15867943/5994393
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

CentOS7使用yum在线安装mysql5.7

精选 原创

1.安装wget

​yum install -y wget

CentOS7使用yum在线安装mysql5.7_yum安装

2、下载rpm安装包

[root@nifi1 home]# wget  http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

2.1 yum安装mysql 5.7

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

CentOS7使用yum在线安装mysql5.7_MySQL_02

2.2yum安装mysql-community-server

yum -y install mysql-community-server

CentOS7使用yum在线安装mysql5.7_mysql_03

安装失败由于MySQL GPG 密钥已过期导致的需要运行命令, 以2022年为例

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

yum -y install mysql-community-server

CentOS7使用yum在线安装mysql5.7_MySQL_04
CentOS7使用yum在线安装mysql5.7_yum安装_05

至此yum安装MySQL服务结束!

3.MySQL数据库设置

3.1启动MySQL

systemctl start  mysqld.service

3.2查看MySQL运行状态

systemctl status mysqld.service

CentOS7使用yum在线安装mysql5.7_mysql_06

4.在日志文件中找出密码

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

5.进入数据库

mysql -uroot -p   # 回车后会提示输入密码

6.在日志文件中找出密码

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

7.进入数据库

mysql -uroot -p   # 回车后会提示输入密码

8.设置mysql密码

8.1修改变更,便于修改简单密码

set global validate_password_policy=0;

set global validate_password_length=1;

8.2修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

8.3远程授权,便于使用navicat等远程客户端连接

grant all on *.* to root@'%' identified by 'root';

9.登录测试

mysql -uroot -p

CentOS7使用yum在线安装mysql5.7_yum安装_07
  • 2
  • 2收藏
  • 评论
  • 分享
  • 举报

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK