CentOS 7 yum 安装 MySQL5.7

时间:2021-06-17 00:17:19

1、下载 MySQL 官方的 Yum Repository ,官网地址:https://dev.mysql.com/downloads/repo/yum/

CentOS 7 yum 安装 MySQL5.7

从 MySQL 官网选取合适的 MySQL 版本,获取下载地址。

然后使用 wget 下载:

[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
--2017-10-19 04:44:56-- http://dev.mysql.com/get/mysql57-community-release
-el7-7.noarch.rpm
Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11

2、安装 yum Repository

[root@localhost ~]# ll
total 12
-rw-r--r--. 1 root root 8984 Nov 12 2015 mysql57-community-release-el7-7.noarch.rpm
[root@localhost ~]# yum -y install mysql57-community-release-el7-8.noarch.rpm
Loaded plugins: fastestmirror
Examining mysql57-community-release-el7-8.noarch.rpm: mysql57-community-rel
ease-el7-8.noarch
Marking mysql57-community-release-el7-8.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql57-community-release.noarch 0:el7-8 will be installed
--> Finished Dependency Resolution Dependencies Resolved ===========================================================================
Package Arch Version
Repository Size
===========================================================================
Installing:
mysql57-community-release
noarch el7-8 /mysql57-community-release-el7-8.noarch 8.2 k Transaction Summary
===========================================================================
Install 1 Package Total size: 8.2 k
Installed size: 8.2 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql57-community-release-el7-8.noarch 1/1
Verifying : mysql57-community-release-el7-8.noarch 1/1 Installed:
mysql57-community-release.noarch 0:el7-8 Complete!

3、安装 MySQL 服务端

查看 mysql server

[root@localhost ~]# yum search mysql-com
Loaded plugins: fastestmirror
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql57-community | 2.5 kB 00:00
(1/3): mysql-connectors-community/x86_64/primary_db | 16 kB 00:00
(2/3): mysql-tools-community/x86_64/primary_db | 35 kB 00:00
(3/3): mysql57-community/x86_64/primary_db | 124 kB 00:00
Loading mirror speeds from cached hostfile
* base: mirrors.btte.net
* extras: mirrors.cn99.com
* updates: mirrors.sohu.com
========================= N/S matched: mysql-com ==========================
mysql-community-client.i686 : MySQL database client applications and tools
mysql-community-client.x86_64 : MySQL database client applications and
: tools
mysql-community-common.i686 : MySQL database common files for server and
: client libs
mysql-community-common.x86_64 : MySQL database common files for server and
: client libs
mysql-community-devel.i686 : Development header files and libraries for
: MySQL database client applications
mysql-community-devel.x86_64 : Development header files and libraries for
: MySQL database client applications
mysql-community-embedded.i686 : MySQL embedded library
mysql-community-embedded.x86_64 : MySQL embedded library
mysql-community-embedded-compat.i686 : MySQL embedded compat library
mysql-community-embedded-compat.x86_64 : MySQL embedded compat library
mysql-community-embedded-devel.i686 : Development header files and
...: libraries for MySQL as an embeddable library
mysql-community-embedded-devel.x86_64 : Development header files and
...: libraries for MySQL as an embeddable library
mysql-community-libs.i686 : Shared libraries for MySQL database client
: applications
mysql-community-libs.x86_64 : Shared libraries for MySQL database client
: applications
mysql-community-libs-compat.i686 : Shared compat libraries for MySQL 5.6.25
: database client applications
mysql-community-libs-compat.x86_64 : Shared compat libraries for MySQL
: 5.6.37 database client applications
mysql-community-release.noarch : MySQL repository configuration for yum
mysql-community-server.x86_64 : A very fast and reliable SQL database
: server
mysql-community-test.x86_64 : Test suite for the MySQL database server Name and summary matches only, use "search all" for everything.

安装

[root@localhost ~]# yum -y install mysql-community-server.x86_64
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.btte.net
* extras: mirrors.cn99.com
* updates: mirrors.sohu.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.56-2.el7 will be obsoleted

等待执行安装完成。

4、启动 mysql 服务

然后启动,注意 CentOS7 的启动方式和以前不一样,CentOS7 使用了 systemctl

[root@localhost ~]# systemctl start mysqld.service

查看启动是否成功

[root@localhost ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor
preset: disabled)
Active: active (running) since Thu 2017-10-19 04:55:02 CST; 11s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 4346 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/
mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 4271 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, stat
us=0/SUCCESS)
Main PID: 4349 (mysqld)
CGroup: /system.slice/mysqld.service
└─4349 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysql... Oct 19 04:54:58 localhost.localdomain systemd[1]: Starting MySQL Server...
Oct 19 04:55:02 localhost.localdomain systemd[1]: Started MySQL Server.
Hint: Some lines were ellipsized, use -l to show in full.

上面显示 active (running) 则表示已经正常启动。

5、登陆数据库

然后就可以进入数据库了,这里注意一点,MySQL5.7.6 之后会在启动 mysql 进程的时候生成一个用户密码,首次登陆需要这个密码才行。密码保存在 mysql 进程的日志里,即(/var/log/mysqld.log)

查看登陆密码

[root@localhost ~]# cat /var/log/mysqld.log | grep 'password'
2017-10-18T20:54:59.169015Z 1 [Note] A temporary password is generated for root@localhost: I-<k&>wb&0h*

然后登陆

[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.20 Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved
. Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input stateme
nt. mysql>

到这里 MySQL 就完全安装完成了。

6、修改 root 密码

但是如果想正常使用还需要修改密码,以前的 password()函数将会被抛弃,官方建议使用下面的命令来修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
ERROR 1819 (HY000): Your password does not satisfy the current policy requi
rements

密码不能太简单

这里我们注意设置密码 长度要大于8,同时要有数字,大小写,特殊字符。

最后,安装完了可以删除 MySQL 的 Repository ,这样可以减少 yum 检查更新的时间,使用下面的命令。

[root@localhost ~]# yum -y remove mysql57-community-release-el7-8

CentOS 7 yum 安装 MySQL5.7的更多相关文章

  1. CentOS 7 yum 安装mysql5&period;6

    到mysql社区安装当前可用包 Centos  7  命令 # rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noar ...

  2. centos下yum安装mysql5&period;6后,无法启动 MySQL Daemon failed to start

    如果是全新安装应该就不会出现这个问题,升级安装的话,要运行 mysql_upgrade ,但是启动MYSQL就报错MySQL Daemon failed to start 如此就没办法运行mysql_ ...

  3. Centos 升级MySQL版本或者Yum安装Mysql5&period;6

    Centos 升级MySQL版本或者Yum安装Mysql5.6 1.从MySQL Yum仓库下载最新的rpm文件:http://dev.mysql.com/downloads/repo/yum/Cen ...

  4. &lbrack;转&rsqb;阿里云CentOS 7&period;1使用yum安装MySql5&period;6&period;24

    阿里云CentOS 7.1使用yum安装MySql5.6.24 作者:vfhky | 时间:2015-06-25 09:43 | 分类:web 在前面两篇文章<2015博客升级记(四):Cent ...

  5. 阿里云Centos7使用yum安装MySQL5&period;6的正确姿势

    阿里云Centos7使用yum安装MySQL5.6 阿里云Centos7使用yum安装MySQL5.6 前言:由于某些不可抗力,我要在自己的阿里云服务器上搭建hadoop+hive+mysql+tom ...

  6. CentOS7&period;4使用yum安装MySQL5&period;6

    CentOS默认数据库为mariadb可以使用yum安装MySQL5.6 系统版本查看 下载yum源安装 wget http://dev.mysql.com/get/mysql-community-r ...

  7. centos下yum安装lamp和lnmp轻松搞定

    centos下yum安装lamp和lnmp轻松搞定.究竟多轻松你看就知道了.妈妈再也不操心不会装lamp了. 非常辛苦整理的安装方法,会持续更新下去.凡无法安装的在评论里贴出问题来,会尽快解决.共同维 ...

  8. centos7&period;6 yum安装mysql5&period;7版本

    由于mysql5.5及之前的版本一些项目上线报错 卸载: 首先删除centos上原来的mysql老版本,注意备份,清理干净. 之前怎么安装的清理,防止卸载不干净会有冲突. 我之前yum安装mysql5 ...

  9. Centos 7&period;6 安装Mysql5&period;7&lpar;离线&rpar;

    Centos 7.6 安装Mysql5.7(离线) 标签(空格分隔): mysql 安装包下载 https://dev.mysql.com/downloads/mysql/ [image.png-14 ...

随机推荐

  1. EF架构~EF异步改造之路~仓储接口的改造~续

    回到目录 返回异步与并行目录 在写完仓储接口的改造改造后,总觉得有个代码的坏味道,这种味道源于它的DRP,即重复的代码太多了,即异步操作和同步操作其实只是在insert,update和delete上有 ...

  2. sublime简书安装配置

    sublime-text3编辑器 安装 sudo add-apt-repository ppa:webupd8team/sublime-text-3 sudo apt-get update sudo ...

  3. 使用Firefox user agent进行移动端网页测试

    Selenium 真是个强大的网页测试工具,设置Firefox user agent, 就可以轻松模拟手机端浏览器进行网页测试. Demo Code # -*- coding:utf8 -*- imp ...

  4. PyPI镜像网站

    镜像列表:http://www.pypi-mirrors.org/ 清华镜像:http://e.pypi.python.org/

  5. hdu 5461 Largest Point 暴力

    Largest Point Time Limit: 1 Sec Memory Limit: 256 MB 题目连接 http://acm.hdu.edu.cn/showproblem.php?pid= ...

  6. iOS开发——UI篇OC篇&amp&semi;UIDynamic详解

    iOS开发拓展篇—UIDynamic(简单介绍) 一.简单介绍 1.什么是UIDynamic UIDynamic是从iOS 7开始引入的一种新技术,隶属于UIKit框架 可以认为是一种物理引擎,能模拟 ...

  7. zedboard--Opencv移植和zedboard测试(十一)

    继上次生成了ARM架构的链接库之后,我们要把他们拷贝到装载有文件系统的SD卡中即可,在拷贝时,最好是/usr/lib下 实践一:将那些lib拷贝到U盘里面,因为之前跑过demo,里面就是一个简易的li ...

  8. &lpar;8&rpar; Xamarin使用Jar檔

    原文 Xamarin使用Jar檔 这个范例是如何在Xamarin.Android中去使用一个我们自行在开发的JAR档案. 主要会执行的步骤如下 在Xamarin建立一个Android Java Bin ...

  9. lucene全文搜索之三:生成索引字段,创建索引文档(给索引字段加权)基于lucene5&period;5&period;3

    前言:上一章中我们已经实现了索引器的创建,但是我们没有索引文档,本章将会讲解如何生成字段.创建索引文档,给字段加权以及保存文档到索引器目录 luncene5.5.3集合jar包下载地址:http:// ...

  10. 【Kafka】

    KafkaProducer Kafka消息发布客户端. 线程安全,跨线程共享单个生产者实例通常比拥有多个实例的速度更快. 例子,使用生产者发送包含序列号的字符串作为键/值对的记录: Propertie ...