下载安装包 :
地址 :https://dev.mysql.com/downloads/mysql/
选择 Red Hat ,CentOS 是基于红帽的,Select OS Version: 选择 linux 7
- mkdir /usr/local/mysql
- cd /usr/local/mysql
- 将下载好的安装包放入进 当前目录
-
通过 rpm -qa | grep mariadb 命令查看 mariadb 的安装包
-
如果存在 ,通过 rpm -e 第四步查出来的安装包 --nodeps 命令装卸 mariadb
-
通过 tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar 命令解压 tar 包
-
通过 rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm --nodeps --force 安装 common
-
通过 rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm --nodeps --force 安装 libs
-
通过 rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm --nodeps --force 安装 client
-
通过 rpm -ivh mysql-community-server-8.0.23-1.el7.x86_64.rpm --nodeps --force 安装server
-
mysqld --initialize 初始化Mysql
-
chown mysql:mysql /var/lib/mysql -R 设置文件所有者为mysql
-
systemctl start mysqld.service; 启动Mysql 服务
-
systemctl enable mysqld; 开机自动启动Mysql服务
-
cat /var/log/mysqld.log | grep password 查看数据库密码
-
进入Mysql后 通过 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; 修改密码
-
远程访问授权
-
create user 'root'@'%' identified with mysql_native_password by 'root';
-
grant all privileges on *.* to 'root'@'%' with grant option;
-
flush privileges;
-
-
修改加密规则 ,防止有些可视化页面不能登录 ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;
-
关闭防火墙
-
systemctl stop firewalld
-
systemctl disable firewalld
-