Centos7安装MySQL5.7

centos安装MySQL，我用过的主要有3种：tar解压安装、yum安装、rpm安装。tar安装太麻烦

而且centos7默认安装了MaraiaDB，所以要先卸载，否则会有冲突

卸载原生MariaDB

rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

一、yum安装mysql

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
systemctl status mysqld
systemctl start mysqld

二、rpm安装mysql
下载需要的rpm包
mysql-community-client-5.7.22-1.el7.x86_64.rpm
mysql-community-common-5.7.22-1.el7.x86_64.rpm
mysql-community-libs-5.7.22-1.el7.x86_64.rpm
mysql-community-server-5.7.22-1.el7.x86_64.rpm

rpm -ivh *.rpm
systemctl status mysqld
systemctl start mysqld

三、MySQL登录管理

查看原始密码

grep "password" /var/log/mysqld.log

登陆修改密码
mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

修改远程登录权限

show databases;
use mysql;
select host, user from user;
update user set user.Host='%' where user.User='root';
flush privileges;