yum安装MySQL5.7

MYSQL数据库安装

一、准备工作

---

1.还原快照

2.调整2G内存

3.请关闭防火墙和selinux

# systemctl stop  firewalld
# systemctl disable  firewalld
# setenforce 0
# vim  /etc/selinux/config——>SELINUX=disabled

4.下载必要的工具

# yum -y install lrzsz wget

二、安装Mysql

---

1.访问国内mysql镜像站

http://mirrors.ustc.edu.cn/（中国科学技术大学开源软件镜像）

2.下载软件包

# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-server-5.7.25-1.el7.x86_64.rpm
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-client-5.7.25-1.el7.x86_64.rpm
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-common-5.7.25-1.el7.x86_64.rpm
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-libs-5.7.25-1.el7.x86_64.rpm

已经有的话，通过rz上传到服务器。

3.安装相关软件

# yum install -y net-tools.x86_64 libaio.x86_64 perl.x86_64

4.安装Mysql服务器

# yum install -y mysql-community*
若存在报错，卸载冲突的软件包，再安装

# yum remove -y mariadb-libs.x86_64
# yum install -y mysql-community*

5.启动Mysql服务器

#systemctl start mysqld
#systemctl enable mysqld
#systemctl status mysqld

6.查询Mysql服务器默认密码

# grep 'password' /var/log/mysqld.log 

注：冒号和空格的后面，全都是密码

7.修改Mysql服务器密码

# mysqladmin -uroot -p'es,W;ya(K1Th' password  'QianFeng@123'

8.登录Mysql系统

# mysql -uroot -p'QianFeng@123'

9.查到默认数据库

10.关机快照

三、扩展：

通过配置文件设置密码强度

[root@mysql-server ~]# vim /etc/my.cnf   #在最后添加如下内容
validate_password=off

[root@mysql-server ~]# systemctl restart mysqld   #重启mysql生效
可以用第二种方式修改为简单的密码：

[root@mysql-server ~]# mysqladmin -uroot -p'QianFeng@123' password 'qf123'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
[root@mysql-server ~]# mysql -uroot -pqf123
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.27 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
Bye