Mysql--004--离线安装单机版MySql

下载地址

快速下载：http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar

解压缩

tar -xf mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar -C /home/app/

卸载系统自带的Mariadb

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

卸载系统自带的MySql

rpm -qa | grep mysql

安装

rpm -ivh ./mysql-community-common-5.7.35-1.el7.x86_64.rpm
rpm -ivh ./mysql-community-libs-5.7.35-1.el7.x86_64.rpm
rpm -ivh ./mysql-community-devel-5.7.35-1.el7.x86_64.rpm
rpm -ivh ./mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm
rpm -ivh ./mysql-community-client-5.7.35-1.el7.x86_64.rpm
rpm -ivh ./mysql-community-server-5.7.35-1.el7.x86_64.rpm

启动MySql

启动：systemctl start mysqld
查看状态：service mysqld status

启动成功！！！

重置root密码

查看默认密码：grep ‘temporary password’ /var/log/mysqld.log
登录mysql：mysql -u root -p 输入密码
设置密码校验策略最低：set global validate_password_policy=LOW;
修改密码:SET PASSWORD FOR ‘root’@‘localhost’= “root@123456”; 密码长度需要大于8，本例设置为root@123456

配置远程登录

登录mysql：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'konglcwqy' WITH GRANT OPTION;
FLUSH PRIVILEGES;

远程登录

mysql安装成功！！！