前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Centos7使用yum安装Mysql5.6版本

Centos7使用yum安装Mysql5.6版本

作者头像
华创信息技术
发布2019-11-08 15:50:39
6680
发布2019-11-08 15:50:39
举报
文章被收录于专栏:华创信息技术华创信息技术

文章时间:2019年7月12日 15:41:52 解决问题:快速在centos系统上安装5.6版本的mysql 基于版本:Cent os 7.6

第一步:安装社区资源rpm包

代码语言:javascript
复制
rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

第二步:查看当前可用的mysql安装资源

代码语言:javascript
复制
yum repolist enabled | grep "mysql.*-community.*"

回显:

代码语言:javascript
复制
mysql-connectors-community/x86_64 MySQL Connectors Community                  17
mysql-tools-community/x86_64      MySQL Tools Community                       31
mysql56-community/x86_64          MySQL 5.6 Community Server                 199

第三步:执行安装命令

代码语言:javascript
复制
yum -y install mysql-community-server

第四步:加入开机启动

代码语言:javascript
复制
systemctl enable mysqld

第五步:启动mysql服务进程

代码语言:javascript
复制
systemctl start mysqld

第六步:重置一个新密码(全部按照代码操作输入y和n即可)

代码语言:javascript
复制
mysql_secure_installation
代码语言:javascript
复制
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] y        [设置root用户密码]
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!

By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y            [删除匿名用户]
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n            [禁止root远程登录]
 ... skipping.

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y       [删除test数据库]
 - Dropping test database...
ERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist
 ... Failed!  Not critical, keep moving...
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y        [刷新权限]
 ... Success!

All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

Cleaning up...

第七步:登录测试

代码语言:javascript
复制
mysql -uroot -p
本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
原始发表:2019-07-12 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 第一步:安装社区资源rpm包
  • 第二步:查看当前可用的mysql安装资源
  • 第三步:执行安装命令
  • 第四步:加入开机启动
  • 第五步:启动mysql服务进程
  • 第六步:重置一个新密码(全部按照代码操作输入y和n即可)
  • 第七步:登录测试
相关产品与服务
云数据库 SQL Server
腾讯云数据库 SQL Server (TencentDB for SQL Server)是业界最常用的商用数据库之一,对基于 Windows 架构的应用程序具有完美的支持。TencentDB for SQL Server 拥有微软正版授权,可持续为用户提供最新的功能,避免未授权使用软件的风险。具有即开即用、稳定可靠、安全运行、弹性扩缩等特点。
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档