Centos7安装MySQL数据库

查看mariadb版本
[root@node1 ~]# rpm -qa | grep mariadb                 
mariadb-libs-5.5.56-2.el7.x86_64
卸载mariadb
[root@node1 ~]# rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
重启机器
[root@node1 ~]# reboot
安装依赖
yum install numactl
yum install openssl-devel.x86_64 openssl.x86_64 -y
yum -y install autoconf
yum install perl.x86_64 perl-devel.x86_64 -y
yum install perl-JSON.noarch -y
yum install gcc

下载数据库安装包
进官网找readhat板的
mysql-*.x86_64.rpm-bundle.tar 强调别搞别的


tar -xvf mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar 


按顺序安装  注意看清楚版本 用tab 补全 不要手敲
rpm -ivh mysql-community-common-8.0.13-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.13-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.13-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.13-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-8.0.13-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.13-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.13-1.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.13-1.el7.x86_64.rpm

初始化数据库

mysqld --initialize --console

目录授权，否则启动失败

chown -R mysql:mysql /var/lib/mysql/

启动msyql服务

systemctl start mysqld

将mysql服务设置为开机启动

systemctl enable mysqld
systemctl daemon-reload

查看msyql服务的状态
service mysqld status

在/var/log/mysqld.log下查看临时密码
cat /var/log/mysqld.log
仔细找这一句
A temporary password is generated for root@localhost: hpToQ.9stkn


用临时密码登录到数据库
mysql -u root -p 

执行下列mysql命令 修改密码
alter USER 'root'@'localhost' IDENTIFIED BY '新密码';


依次执行下列mysql命令 授权远程连接

查看所有用户是否可以远程连接，依次执行下列命令：
show databases;
use mysql;
select host, user, authentication_string, plugin from user;
host为localhsot，说明用户只能本地连接msyql服务

修改root用户host值，使root用户可以远程登录
update user set host = "%" where user='root';

刷新
flush privileges;

开启mysql远程访问权限
use mysql;
alter USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root用户的密码';
flush privileges;