yum安装mysql5.7

yum安装mysql5.7

1.安装wget

yum install -y wget

2.下载并安装MySQL官方的 Yum Repository

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

3.MySQL数据库设置

#启动MySQL
systemctl start  mysqld.service
#查看MySQL运行状态
systemctl status mysqld.service

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

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

5.进入数据库

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

6.设置mysql密码
6.1修改变更，便于修改简单密码

set global validate_password_policy=0;
set global validate_password_length=1;

6.2修改密码

--修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Simple@123';

6.3远程授权，便于使用navicat等远程客户端连接

--远程授权
grant all on *.* to root@'%' identified by 'Simple@123';

7.移除Yum Repository

yum -y remove mysql57-community-release-el7-10.noarch

8.登录测试

mysql -uroot -pSimple@123

9mysql简单应用
9.1mysql创建数据库，指定编码格式

create database MyDB_two character set utf8;

9.2创建表

create table tb_user(
id int(10) PRIMARY KEY AUTO_INCREMENT,
user_name varchar(20),
password varchar(20),
name varchar(20),
age int(10),
sex int(10),
birthday date,
created date,
updated date
)character set utf8 collate utf8_general_ci;

9.3数据插入

insert into tb_user(id,user_name,password,name,age,sex,birthday,created,updated)
values(1,'zhangsan','Simple@1234','张三',20,1,'2001-01-01','2021-08-07','2021-09-10');

9.4查询结果