linux安装mysql(rpm安装方式)

mysql安装包下载地址
https://dev.mysql.com/downloa...

1. centos默认会安装mariadb所以要先卸载一下，防止出现冲突
   rpm -qa | grep mariadb
   
   卸载：rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps
   
   2.在usr/local下创建mysql目录
   cd /usr/local&mkdir&&mysql
   3.解压文件
   tar -xvf mysql-8.0.23-1.el7.x86_64.rpm-bundle.tar
2. 安装
   rpm -ivh mysql-community-common-8.0.23-1.el7.x86_64.rpm --nodeps --force
   rpm -ivh mysql-community-libs-8.0.23-1.el7.x86_64.rpm --nodeps --force
   rpm -ivh mysql-community-client-8.0.23-1.el7.x86_64.rpm --nodeps --force
   rpm -ivh mysql-community-server-8.0.23-1.el7.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.登录
mysql -uroot -p
然后输入密码
8.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'
9.远程访问授权
create user 'root'@'%'identified with mysql_native_password by '123456';
grant all privileges on . to 'root'@'%' with grant option;
(.显示有问题所以再贴个图片)

flush privileges;
10.重启mysql服务
service mysqld restart
11.开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload