Centos7下安装mysql5.7

解压缩放倒目录下，改压缩包会生成多个文件
tar -xvf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar 


删除 mariadb
rpm -qa | grep mariadb  --查看是否有mariadb
rpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps --删除


安装
rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm


修改配置文件
cd /etc
vi my.cnf
增加服务端和客户端编码
服务端
[mysqld]
character-set-server=utf8
客户端
[client]
default-character-set=utf8


启动mysql
进入到/etc/init.d目录下
systemctl start mysqld --启动
systemctl start mysqld --停止
ps -ef|grep mysql      --查看mysql进程


第一次登录密码的查看
more /var/log/mysqld.log 
显示密码在下面的行，并记录下来
A temporary password is generated for root@localhost: 8O8TkU#mEqre


登录mysql
第一次登录mysql不能使用远程，需要进行设置
登录命令如下
mysql -uroot -p8O8TkU\#mEqre


修改root的密码
alter  user 'root'@'localhost' identified by 'password';
flush privileges;


关闭防火墙，允许3306端口
systemctl status firewalld --查看状态
systemctl stop firewalld -- 关闭
systemctl start firewalld --打开防火墙


设置允许远程登录
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;