MySQL的安装

MySQL安装

1. 服务器配置信息

ip: 192.168.10.131
hostname: hufu04
os: CentOS Linux release 7.6.1810 (Core) 

2.安装MySQL

##2.1 下载
[root@hufu04 ~]# wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
[root@hufu04 ~]# ls
anaconda-ks.cfg  mysql80-community-release-el7-3.noarch.rpm


##2.2安装
[root@hufu04 ~]# rpm -Uvh mysql80-community-release-el7-3.noarch.rpm 
warning: mysql80-community-release-el7-3.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql80-community-release-el7-3  ################################# [100%]


##2.3 查看（这里默认enable 是 80 版本）
[root@hufu04 ~]# yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community   disabled
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community   disabled
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled
mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community   disabled
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - disabled
mysql-connectors-community/x86_64  MySQL Connectors Community    enabled:    118
mysql-connectors-community-source  MySQL Connectors Community -  disabled
mysql-tools-community/x86_64       MySQL Tools Community         enabled:     95
mysql-tools-community-source       MySQL Tools Community - Sourc disabled
mysql-tools-preview/x86_64         MySQL Tools Preview           disabled
mysql-tools-preview-source         MySQL Tools Preview - Source  disabled
mysql55-community/x86_64           MySQL 5.5 Community Server    disabled
mysql55-community-source           MySQL 5.5 Community Server -  disabled
mysql56-community/x86_64           MySQL 5.6 Community Server    disabled
mysql56-community-source           MySQL 5.6 Community Server -  disabled
mysql57-community/x86_64           MySQL 5.7 Community Server    disabled
mysql57-community-source           MySQL 5.7 Community Server -  disabled
mysql80-community/x86_64           MySQL 8.0 Community Server    enabled:    129
mysql80-community-source           MySQL 8.0 Community Server -  disabled

##2.4 选择5.7 版本
[root@hufu04 ~]# sudo yum-config-manager --disable mysql80-community
[root@hufu04 ~]# sudo yum-config-manager --enable mysql57-community

##2.5 查看可安装的版本
[root@hufu04 ~]# yum repolist enabled | grep mysql
mysql-connectors-community/x86_64       MySQL Connectors Community           118
mysql-tools-community/x86_64            MySQL Tools Community                 95
mysql57-community/x86_64                MySQL 5.7 Community Server           364

## 2.6 安装(取决于网速)
[root@hufu04 ~]# sudo yum install mysql-community-server -y

##2.7 开启服务，查看状态

## 开启服务
[root@hufu04 ~]# sudo systemctl start mysqld.service

## 查看状态
[root@hufu04 ~]# sudo systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2019-08-16 04:29:52 EDT; 12s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 9127 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 9050 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 9130 (mysqld)
    Tasks: 27
   Memory: 287.9M
   CGroup: /system.slice/mysqld.service
           └─9130 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Aug 16 04:29:48 hufu04 systemd[1]: Starting MySQL Server...
Aug 16 04:29:52 hufu04 systemd[1]: Started MySQL Server.

## 加入开启启动
[root@hufu04 ~]# sudo systemctl enable mysqld.service

## 2.8 查看root密码
[root@hufu04 ~]# sudo grep 'temporary password' /var/log/mysqld.log
2019-08-16T08:29:50.493121Z 1 [Note] A temporary password is generated for root@localhost: p.s25f4yrqlY

## 2.9 登录
[root@hufu04 ~]# mysql -uroot -p

##2.10 修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

##2.11 开启远程链接

#允许所有用户远程访问 修改用户名和密码为你自己的
mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
#允许单个ip 修改用户名和密码为你自己的
mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
#最后
mysql> FLUSH PRIVILEGES;