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查询结果
