Linux安装Mysql

1，先检查是否安装mysql或mariadb
rpm -qa | grep mysql
rpm -qa | grep mariadb

2，卸载存在的mariadb或者mysql

3，安装yum源
rpm -ivh mysql57-community-release-el7-8.noarch.rpm
#去掉域名源 rpm -e --nodeps mysql-community-release xxxx
yum update //更新yum

4，安装mysql
yum install mysql-server

5，安装成功后需要重置密码
首先查看mysql安装的路径 which mysql
赋予指定权限 chmod -R 777 /usr/bin/mysql
关闭mysql服务 service mysqld stop
修改配置文件 vi /etc/my.cnf 在[mysqld]下面添加一行代码 skip-grant-tables
启动mysql服务 service mysqld start
直接进入mysql修改 update mysql.user set authentication_string=password(‘New Password’) where user=‘root’ ;
更新权限 flush privileges;
exit退出再修改配置文件 vi /etc/my.cnf 删掉[mysqld]下面的这一行代码 skip-grant-tables
启动mysql服务 service mysqld start
进mysql最后一次修改密码 ALTER USER USER() IDENTIFIED BY ‘newPassword’;
更新权限 flush privileges;

6，设置远程连接
修改mysql的user表，update mysql.user set host=’%’ where user=‘root’ and host=‘localhost’;
更新权限 flush privileges;
(注意防火墙)