目录
CentOS 7 安装 MySQL
下载MySQL Yum Repository
选择Archived版本
https://downloads.mysql.com/archives/community/
页面下载Repository
https://dev.mysql.com/downloads/repo/yum/
wget下载Repository
[root@centos ~]#wget -i -c http://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
[root@centos ~]# ll
-rw-r--r--. 1 root root 25820 Apr 18 13:24 mysql80-community-release-el7-1.noarch.rpm
下载repository可能遇到的问题
可能出现的错误 [root@centos ~]# wget -i -c http://dev.mysql.com/get/mysql80-community-release-el --2018-01-01 00:26:03-- http://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11 Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:80... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm [following] --2018-01-01 00:26:04-- https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected. ERROR: cannot verify dev.mysql.com's certificate, issued by ‘/C=US/O=DigiCert Inc/CN=DigiCert SHA2 Secure Server CA’: Issued certificate not yet valid. To connect to dev.mysql.com insecurely, use `--no-check-certificate'. -c: No such file or directory No URLs found in -c. 因为时间不准确 [root@centos ~]# date Mon Jan 1 00:34:09 CST 2018 [root@centos ~]# 时间实际上是2019年 根据提示加入--no-check-certificate wget --no-check-certificate -i -c https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
安装MySQL Yum Repository
[root@centos ~]# ll /etc/yum.repos.d/ total 32 -rw-r--r--. 1 root root 1664 May 17 21:53 CentOS-Base.repo -rw-r--r--. 1 root root 1309 May 17 21:53 CentOS-CR.repo -rw-r--r--. 1 root root 649 May 17 21:53 CentOS-Debuginfo.repo -rw-r--r--. 1 root root 314 May 17 21:53 CentOS-fasttrack.repo -rw-r--r--. 1 root root 630 May 17 21:53 CentOS-Media.repo -rw-r--r--. 1 root root 1331 May 17 21:53 CentOS-Sources.repo -rw-r--r--. 1 root root 4768 May 17 21:53 CentOS-Vault.repo [root@centos ~]# yum install mysql80-community-release-el7-1.noarch.rpm Loaded plugins: fastestmirror Examining mysql80-community-release-el7-1.noarch.rpm: mysql80-community-release-el7-1.noarch Marking mysql80-community-release-el7-1.noarch.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package mysql80-community-release.noarch 0:el7-1 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: mysql80-community-release noarch el7-1 /mysql80-community-release-el7-1.noarch 31 k Transaction Summary ================================================================================ Install 1 Package Total size: 31 k Installed size: 31 k Is this ok [y/d/N]: y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : mysql80-community-release-el7-1.noarch 1/1 Verifying : mysql80-community-release-el7-1.noarch 1/1 Installed: mysql80-community-release.noarch 0:el7-1 Complete! [root@centos ~]# [root@centos ~]# [root@centos ~]# [root@centos ~]# [root@centos ~]# [root@centos ~]# ll /etc/yum.repos.d/ total 40 -rw-r--r--. 1 root root 1664 May 17 21:53 CentOS-Base.repo -rw-r--r--. 1 root root 1309 May 17 21:53 CentOS-CR.repo -rw-r--r--. 1 root root 649 May 17 21:53 CentOS-Debuginfo.repo -rw-r--r--. 1 root root 314 May 17 21:53 CentOS-fasttrack.repo -rw-r--r--. 1 root root 630 May 17 21:53 CentOS-Media.repo -rw-r--r--. 1 root root 1331 May 17 21:53 CentOS-Sources.repo -rw-r--r--. 1 root root 4768 May 17 21:53 CentOS-Vault.repo -rw-r--r--. 1 root root 1864 Feb 22 16:49 mysql-community.repo -rw-r--r--. 1 root root 1885 Feb 22 16:49 mysql-community-source.repo
安装MySQL Server
[root@centos ~]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: centos.ustc.edu.cn
* extras: centos.ustc.edu.cn
* updates: centos.ustc.edu.cn
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql80-community | 2.5 kB 00:00
(1/3): mysql-connectors-community/x86_64/primary_db | 24 kB 00:00
(2/3): mysql-tools-community/x86_64/primary_db | 45 kB 00:00
(3/3): mysql80-community/x86_64/primary_db | 26 kB 00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.12-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.12-1.el7 for package: mysql-community-server-8.0.12-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.12-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.12-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.0 for package: mysql-community-client-8.0.12-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.12-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
---> Package mysql-community-libs.x86_64 0:8.0.12-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.12-1.el7 will be obsoleting
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-libs x86_64 8.0.12-1.el7 mysql80-community 2.2 M
replacing mariadb-libs.x86_64 1:5.5.56-2.el7
mysql-community-libs-compat x86_64 8.0.12-1.el7 mysql80-community 2.1 M
replacing mariadb-libs.x86_64 1:5.5.56-2.el7
mysql-community-server x86_64 8.0.12-1.el7 mysql80-community 349 M
Installing for dependencies:
mysql-community-client x86_64 8.0.12-1.el7 mysql80-community 26 M
mysql-community-common x86_64 8.0.12-1.el7 mysql80-community 541 k
Transaction Summary
================================================================================
Install 3 Packages (+2 Dependent packages)
Total download size: 379 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-common-8.0.12-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-8.0.12-1.el7.x86_64.rpm is not installed
(1/5): mysql-community-common-8.0.12-1.el7.x86_64.rpm | 541 kB 00:01
(2/5): mysql-community-libs-8.0.12-1.el7.x86_64.rpm | 2.2 MB 00:02
(3/5): mysql-community-libs-compat-8.0.12-1.el7.x86_64.rpm | 2.1 MB 00:02
(4/5): mysql-community-client-8.0.12-1.el7.x86_64.rpm | 26 MB 00:16
(5/5): mysql-community-server-8.0.12-1.el7.x86_64.rpm | 349 MB 03:15
--------------------------------------------------------------------------------
Total 1.9 MB/s | 379 MB 03:21
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql80-community-release-el7-1.noarch (installed)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-common-8.0.12-1.el7.x86_64 1/6
Installing : mysql-community-libs-8.0.12-1.el7.x86_64 2/6
Installing : mysql-community-client-8.0.12-1.el7.x86_64 3/6
Installing : mysql-community-server-8.0.12-1.el7.x86_64 4/6
Installing : mysql-community-libs-compat-8.0.12-1.el7.x86_64 5/6
Erasing : 1:mariadb-libs-5.5.56-2.el7.x86_64 6/6
Verifying : mysql-community-libs-8.0.12-1.el7.x86_64 1/6
Verifying : mysql-community-common-8.0.12-1.el7.x86_64 2/6
Verifying : mysql-community-server-8.0.12-1.el7.x86_64 3/6
Verifying : mysql-community-client-8.0.12-1.el7.x86_64 4/6
Verifying : mysql-community-libs-compat-8.0.12-1.el7.x86_64 5/6
Verifying : 1:mariadb-libs-5.5.56-2.el7.x86_64 6/6
Installed:
mysql-community-libs.x86_64 0:8.0.12-1.el7
mysql-community-libs-compat.x86_64 0:8.0.12-1.el7
mysql-community-server.x86_64 0:8.0.12-1.el7
Dependency Installed:
mysql-community-client.x86_64 0:8.0.12-1.el7
mysql-community-common.x86_64 0:8.0.12-1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.56-2.el7
Complete!
[root@centos ~]#
启动MySQL Server
启动MySQL Server
[root@centos ~]# systemctl start mysqld
开机启动MySQL Server
[root@centos ~]# systemctl enable mysqld
查看MySQL Server状态
[root@centos ~]# systemctl status mysqld ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Sat 2018-07-28 15:12:53 CST; 28s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Main PID: 24130 (mysqld) Status: "SERVER_OPERATING" CGroup: /system.slice/mysqld.service └─24130 /usr/sbin/mysqld Jul 28 15:12:33 centos systemd[1]: Starting MySQL Server... Jul 28 15:12:53 centos systemd[1]: Started MySQL Server.
修改MySQL root用户密码
MySQL默认有一个root用户,并且有默认密码,密码保存在/var/log/mysqld.log文件中
这个root用户并不是Linux系统的用户
查看root默认密码
[root@centos ~]# grep 'temporary password' /var/log/mysqld.log 2018-07-28T07:12:39.615794Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 8P*k!ws,Od5n [root@centos ~]#
修改root密码
[root@centos ~]# mysql -uroot -p 使用上面查询到的密码登录 Enter password: mysql> 修改密码,默认的密码要求为:包含大写字母/小写字母、数字、特殊字符、最少8位 mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; Query OK, 0 rows affected (0.06 sec) mysql> flush privileges; Query OK, 0 rows affected (0.02 sec) mysql> quit Bye [root@centos ~]#
密码要求
如果密码不符合要求,会提示错误,并且设置的密码不会生效
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements mysql> 查看密码要求 mysql> SHOW VARIABLES LIKE 'validate_password%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | validate_password.check_user_name | ON | | validate_password.dictionary_file | | | validate_password.length | 8 | | validate_password.mixed_case_count | 1 | | validate_password.number_count | 1 | | validate_password.policy | MEDIUM | | validate_password.special_char_count | 1 | +--------------------------------------+--------+ 7 rows in set (0.15 sec) 修改密码规则 mysql> mysql> set global validate_password.policy=0; Query OK, 0 rows affected (0.00 sec)
参考资料
安装MySQL(MySQL官网):https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
MySQL密码要求(MySQL官网):https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
文章评论