mysql5.7.28-Linux安装

mysql版本
mysql5.7.28

下载地址
https://downloads.mysql.com/archives/community/

依赖组件依次安装（rpm方式安装）
common>>libs>>client>>>>server

安装步骤

• 检查是否安装mysql，和mariadb（如果存在）

  rpm -qa|grep mysql
  rpm -qa|grep mariadb 若存在，则把原先的删除

rpm -e --nodeps mysql
rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

• 组件的名称及版本如下

  查看自己Linux版本，不要下错哦~

uname -a
3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

mysql-community-common-5.7.28-1.el7.x86_64.rpm
mysql-community-libs-5.7.28-1.el7.x86_64.rpm
mysql-community-client-5.7.28-1.el7.x86_64.rpm
mysql-community-server-5.7.28-1.el7.x86_64.rpm

• 安装下载的组件

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm 

• 成功的页面如下
  

• 启动mysql服务

service mysqld  start

• 查看mysql服务和端口是否正常

ps -ef|grep mysql
netstat -an|grep 3306 

• mysql的root用户，默认了一个临时密码

grep 'temporary password' /var/log/mysqld.log

• 使用临时密码登录进去，修改root的密码

set global validate_password_policy=0;
set global validate_password_length=1;
alter user root@localhost identified by 'root';
或者
update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';

• 远程访问root

  默认只有本机访问的权限，要通过其他机器访问，必须授权

grant all privileges on *.* to root@'%' identified by 'root';
flush privileges;

• 遇到过的报错

  安装mysql-community-common-5.7.28-1.el7.x86_64.rpm出现冲突