linux环境mysql安装配置

1 、将mysql拷贝到usr/local/mysql 目录
解压 tar -xvf mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar
2、 //查看是否有mariadb 有卸载
rpm -qa | grep mariadb
3、卸载mariadb
rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
4、安装commom
rpm -ivh mysql-community-common-5.7.36-1.el7.x86_64.rpm --nodeps --force
5、安装libs
rpm -ivh mysql-community-libs-5.7.36-1.el7.x86_64.rpm --nodeps --force
6、安装client
rpm -ivh mysql-community-client-5.7.36-1.el7.x86_64.rpm --nodeps --force
7、安装server
rpm -ivh mysql-community-server-5.7.36-1.el7.x86_64.rpm --nodeps --force
8、检查安装的数据包
rpm -qa | grep mysql

9、初始化
mysqld --initialize

10、授权启动服务
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;

11、查看数据库密码
cat /var/log/mysqld.log | grep password

12、登录mysql
mysql -u root -p
13 、修改密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘111111’

14、授权远程访问
create user ‘root’@’%’ identified with mysql_native_password by ‘dpoa365@1211’;
grant all privileges on . to ‘root’@’%’ with grant option;
flush privileges;

15、查看防火墙开启状态
systemctl status firewalld
16、放行3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --add-port=8080/tcp --permanent
firewall-cmd --reload

17、service mysqld status