MySQL 5.7 单实例搭建

一、检查当前系统是否安装过MySQL

[root@henry ~]# rpm -qa | grep mariadb

mariadb-5.5.65-1.el7.x86_64

mariadb-server-5.5.65-1.el7.x86_64

// 如果存在通过如下命令卸载

[root@henry ~]# sudo rpm -e --nodeps mariadb-libs

二、创建 MySQL 安装包拷贝目录

[root@henry ~]# mkdir -p /opt/software/

2.1 将MySQL 安装包拷贝到/opt/software 目录下

[root@henry software]# ll

total 0

三、解压 MySQL 安装包

[root@henry software]# tar -xf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

mysql-community-client-5.7.28-1.el7.x86_64.rpm

mysql-community-common-5.7.28-1.el7.x86_64.rpm

mysql-community-devel-5.7.28-1.el7.x86_64.rpm

mysql-community-embedded-5.7.28-1.el7.x86_64.rpm

mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm

mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm

mysql-community-libs-5.7.28-1.el7.x86_64.rpm

mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm

mysql-community-server-5.7.28-1.el7.x86_64.rpm

mysql-community-test-5.7.28-1.el7.x86_64.rpm

四、在安装目录下执行 rpm 安装

sudo rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm --force --nodeps

sudo rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm --force --nodeps

sudo rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm --force --nodeps

sudo rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm --force --nodeps

sudo rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm --force --nodeps

五、删除/etc/my.cnf 文件中 datadir 指向的目录下所有内容，如果有内容的情况下：

[root@henry ~]# cd /var/lib/mysql

root@henry mysql]# sudo rm -rf ./*

进到 /etc/my.cnf

[root@henry ~]# vi /etc/my.cnf

添加

[mysqld]

datadir=/var/lib/mysql

六、初始化数据库

[root@henry software]# sudo mysqld --initialize --user=mysql

七、查看临时生产的 root 用户密码

[root@henry software]# sudo cat /var/log/mysqld.log

密码在末尾

八、启动MySQL 服务

[root@henry software]# sudo systemctl start mysqld

九、登录MySQL 数据库

[root@henry software]# mysql -uroot -p

Enter password:输入临时生成的密码

十、必须先修改 root 用户的密码，否则执行其他的操作会报错

mysql> set password = password("新密码”);

十一、修改MySQL 库下的 user 表中的 root 用户允许任意 ip连接

mysql> update mysql.user set host='&' where user='root';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;

-------------------------------------------------MySQL 搭建成功-----------------------------------------------