Centos7_安装Mysql

(安西)

　　环境

[iyunv@centos ~]# lsb_release -a
LSB Version:     :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1amd64:desktop-4.1-noarch
:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch
Distributor ID:  CentOS
Description:     CentOS Linux release 7.2.1511 (Core)
Release:         7.2.1511
Codename:        Core

　　一、下载mysql

https://dev.mysql.com/downloads/mysql/

　　二、查看linux系统里是否已安装mysql

> rpm  -qa | grep mysql

　　三、如果存在rpm方式安装的mysql先卸载

> rpm -e --nodeps mysql-community-libs-5.7.18-1.el7.x86_64

　　四、安装解压mysql

> mkdir -p /usr/local/java/mysql-5.7
> tar -xf mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar -C /usr/local/java/mysql-5.7/

　　五、卸载系统自带的 mariadb-lib

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

　　六、依次执行安装mysql文件

> rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm
> rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm
> rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm
> rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm
# 安装server报错，提示需要安装net-tools依赖时，先安装net-tools依赖后再安装server即可
> yum install net-tools

　　七、初始化数据库

# 为了保证数据库目录为与文件的所有者为 mysql 登陆用户，是以 root 身份运行 mysql 服务
> mysqld --initialize --user=mysql

　　八、启动数据库

> systemctl start mysqld.service

　　九、登录数据库

# --initialize 初始化后，会生成一个 root 账户密码，密码在/var/log/mysqld.log文件里
# 如：2017-11-02T10:12:34.026991Z 1 [Note] A temporary password is generated for root@localhost: *jG.h1PnG>CZ
> cat /var/log/mysqld.log
> mysql -uroot -p（如密码为*jG.h1PnG>CZ）

　　十、登录后需要修改密码

# 密码过于简单会报ERROR 1819 (HY000): Your password does not satisfy the current policy requirements异常
> ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

　　十一、开启远程服务

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