MySql在Liunx下的安装教程

1.下载安装包

先打开https://dev.mysql.com/downloads/mysql/选择要下载的版本

2.检查环境有没有安装过mariadb

注意：centOs会默认安装，为了避免冲突，先行卸载

rpm -qa|grep mariadb

卸载命令：

rpm -e mariadb.XXX --nodeps

3.创建存放的文件夹，解压jar包

在/user/local下创建

mkdir mysql

将之前下载的jar包存放到该文件夹下面

tar -xvf mysql-8.0.27-1.el8.x86_64.rpm-bundle.tar

4.安装

都可以在解压的文件里面找到对应的，写法都是固定的
–nodeps 去掉依赖
–force 强制安装

rpm -ivh mysql-community-common-8.0.27-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.27-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.27-1.el8.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.27-1.el8.x86_64.rpm --nodeps --force

5.初始化和配置

mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld

6.查看修改密码

 cat /var/log/mysqld.log | grep password

7.修改密码

alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘123456’;

8.开启远程访问授权

 create user 'root'@'%' identified with mysql_native_password by '123456';
 grant all privileges on *.* to 'root'@'%' with grant option;
 flush privileges;

9. 重启mysql服务

退出

exit 

重启服务

 service mysqld restart

10. 开放防火墙端口

 firewall-cmd --zone=public --add-port=3306/tcp --permanent
 firewall-cmd --zone=public --remove-port=3306/tcp --permanent
 firewall-cmd --reload