MySQL-安装教程

MySQL-安装教程

---

MySQL-安装教程

声明

包括但不限于本文所述内容（包括文字和图片），本文档作者拥有完全独立的唯一版权。未经作者书面同意或授权，任何单位和个人都不得将其复制、影印或引用。

文档修订

版本	日期	AMD	修订者	说明
1.0	2019年8月12日	A	寒枫(hanyist@163.com)	创建手册,仅供学习参考！

（A添加、M-修改、D-删除）

---

一、MySQL数据库单实例安装

1、二进制RPM包方式安装

1）基本信息

安装方式	软件包名称	操作系统版本
Yum Repository	https://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm	RHEL6/OEL6
Yum Repository	https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm	RHEL7/OEL7

2)安装过程

# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
# md5sum mysql80-community-release-el7-3.noarch.rpm 
893b55d5d885df5c4d4cf7c4f2f6c153  mysql80-community-release-el7-3.noarch.rpm

# sha1sum mysql80-community-release-el7-3.noarch.rpm 
0a1f32972cfd8eb947a2b359d7a885554c4e7512  mysql80-community-release-el7-3.noarch.rpm

# yum makecache
# vi /etc/yum.repos.d/mysql-community.repo
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# yum list|grep mysql-com

# yum list|grep mysql-com
# yum install mysql-community-server.x86_64 –y
# ls /var/lib/mysql
# systemctl start mysqld
[root@localhost setup]# ls /var/lib/mysql   
auto.cnf    client-cert.pem  ibdata1      ibtmp1      mysql.sock.lock     public_key.pem   sys
ca-key.pem  client-key.pem   ib_logfile0  mysql       performance_schema  server-cert.pem
ca.pem      ib_buffer_pool   ib_logfile1  mysql.sock  private_key.pem     server-key.pem
# sed -ri '/^SELINUX=/cSELINUX=disabled' /etc/selinux/config

[root@localhost setup]# systemctl stop firewalld
[root@localhost setup]# systemctl disable firewalld
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
Removed symlink /etc/systemd/system/basic.target.wants/firewalld.service.

安装完成后，MySQL5.7以前可以无密码直接登录，但是MySQL5.7开始无密码就禁止登录了。

[root@localhost setup]# grep 'password' /var/log/mysqld.log
2019-05-05T14:10:17.483708Z 1 [Note] A temporary password is generated for root@localhost: Ye=9boF3weXS
2019-05-05T14:17:28.586236Z 0 [Note] Shutting down plugin 'validate_password'
2019-05-05T14:17:30.314191Z 0 [Note] Shutting down plugin 'sha256_password'
2019-05-05T14:17:30.314193Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-05-05T14:18:43.313683Z 0 [Note] Shutting down plugin 'validate_password'
2019-05-05T14:18:45.031983Z 0 [Note] Shutting down plugin 'sha256_password'
2019-05-05T14:18:45.031985Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-05-05T14:20:31.750419Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)

[root@localhost setup]# mysql -uroot -p'9boF3weXS'