阿里云CentOS7安装MySQL

最新推荐文章于 2024-05-14 23:03:45 发布
最新推荐文章于 2024-05-14 23:03:45 发布
阅读量2.9k 收藏 5
点赞数 2
文章标签： centos mysql yum
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qz_CSDN/article/details/78427465
版权

用yum -y install mysql mysql-server mysql-devel命令安装，出现如下提示：

# yum -y install mysql mysql-server mysql-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package 1:mariadb-5.5.56-2.el7.x86_64 already installed and latest version
No package mysql-server available.
Package 1:mariadb-devel-5.5.56-2.el7.x86_64 already installed and latest version
Nothing to do

从以上提示可以知道并没有安装MySQL，什么情况先不管了，总之这个方法不行。

于是按着网上找到的方法，步骤如下：

1.下载rpm包
[root@izwz ~]# rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
Retrieving http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-release-el7-5    ################################# [100%]
2.查看当前可用的mysql安装资源：
[root@izwz ~]# yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64 MySQL Connectors Community                  42
mysql-tools-community/x86_64      MySQL Tools Community                       51
mysql56-community/x86_64          MySQL 5.6 Community Server                 361
3.yum安装
[root@izwz ~]# yum -y install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.38-2.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.38-2.el7 for package: mysql-community-server-5.6.38-2.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.38-2.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.6.38-2.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package mariadb.x86_64 1:5.5.56-2.el7 will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.38-2.el7 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.38-2.el7.x86_64
---> Package mysql-community-common.x86_64 0:5.6.38-2.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.56-2.el7 for package: 1:mariadb-devel-5.5.56-2.el7.x86_64
---> Package mysql-community-libs.x86_64 0:5.6.38-2.el7 will be obsoleting
--> Running transaction check
---> Package mariadb-devel.x86_64 1:5.5.56-2.el7 will be obsoleted
---> Package mysql-community-devel.x86_64 0:5.6.38-2.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================
 Package                        Arch           Version                 Repository                 Size
=======================================================================================================
Installing:
 mysql-community-client         x86_64         5.6.38-2.el7            mysql56-community          19 M
     replacing  mariadb.x86_64 1:5.5.56-2.el7
 mysql-community-devel          x86_64         5.6.38-2.el7            mysql56-community         3.4 M
     replacing  mariadb-devel.x86_64 1:5.5.56-2.el7
 mysql-community-libs           x86_64         5.6.38-2.el7            mysql56-community         2.0 M
     replacing  mariadb-libs.x86_64 1:5.5.56-2.el7
 mysql-community-server         x86_64         5.6.38-2.el7            mysql56-community          59 M
Installing for dependencies:
 libaio                         x86_64         0.3.109-13.el7          base                       24 k
 mysql-community-common         x86_64         5.6.38-2.el7            mysql56-community         257 k

Transaction Summary
=======================================================================================================
Install  4 Packages (+2 Dependent packages)

Total download size: 84 M
Downloading packages:
(1/6): libaio-0.3.109-13.el7.x86_64.rpm                                         |  24 kB  00:00:00     
warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.38-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-5.6.38-2.el7.x86_64.rpm is not installed
(2/6): mysql-community-common-5.6.38-2.el7.x86_64.rpm                           | 257 kB  00:00:00     
(3/6): mysql-community-devel-5.6.38-2.el7.x86_64.rpm                            | 3.4 MB  00:00:00     
(4/6): mysql-community-libs-5.6.38-2.el7.x86_64.rpm                             | 2.0 MB  00:00:00     
(5/6): mysql-community-client-5.6.38-2.el7.x86_64.rpm                           |  19 MB  00:00:02     
(6/6): mysql-community-server-5.6.38-2.el7.x86_64.rpm                           |  59 MB  00:00:05     
-------------------------------------------------------------------------------------------------------
Total                                                                   12 MB/s |  84 MB  00:00:07     
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    : mysql-community-release-el7-5.noarch (installed)
 From       : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Installing : mysql-community-common-5.6.38-2.el7.x86_64                                          1/9 
  Installing : mysql-community-libs-5.6.38-2.el7.x86_64                                            2/9 
  Installing : mysql-community-client-5.6.38-2.el7.x86_64                                          3/9 
  Installing : libaio-0.3.109-13.el7.x86_64                                                        4/9 
  Installing : mysql-community-server-5.6.38-2.el7.x86_64                                          5/9 
  Installing : mysql-community-devel-5.6.38-2.el7.x86_64                                           6/9 
  Erasing    : 1:mariadb-devel-5.5.56-2.el7.x86_64                                                 7/9 
  Erasing    : 1:mariadb-5.5.56-2.el7.x86_64                                                       8/9 
  Erasing    : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                  9/9 
  Verifying  : mysql-community-libs-5.6.38-2.el7.x86_64                                            1/9 
  Verifying  : mysql-community-client-5.6.38-2.el7.x86_64                                          2/9 
  Verifying  : mysql-community-devel-5.6.38-2.el7.x86_64                                           3/9 
  Verifying  : mysql-community-server-5.6.38-2.el7.x86_64                                          4/9 
  Verifying  : mysql-community-common-5.6.38-2.el7.x86_64                                          5/9 
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                        6/9 
  Verifying  : 1:mariadb-devel-5.5.56-2.el7.x86_64                                                 7/9 
  Verifying  : 1:mariadb-libs-5.5.56-2.el7.x86_64                                                  8/9 
  Verifying  : 1:mariadb-5.5.56-2.el7.x86_64                                                       9/9 

Installed:
  mysql-community-client.x86_64 0:5.6.38-2.el7       mysql-community-devel.x86_64 0:5.6.38-2.el7       
  mysql-community-libs.x86_64 0:5.6.38-2.el7         mysql-community-server.x86_64 0:5.6.38-2.el7      

Dependency Installed:
  libaio.x86_64 0:0.3.109-13.el7              mysql-community-common.x86_64 0:5.6.38-2.el7             

Replaced:
  mariadb.x86_64 1:5.5.56-2.el7 mariadb-devel.x86_64 1:5.5.56-2.el7 mariadb-libs.x86_64 1:5.5.56-2.el7

Complete!

安装完成。

启动MySQL

[root@izwz ~]# service mysqld start
Redirecting to /bin/systemctl start  mysqld.service

查看运行状态

[root@izwz ~]# service mysqld status
Redirecting to /bin/systemctl status  mysqld.service
● mysqld.service - MySQL Community Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2017-11-02 18:53:14 CST; 11min ago
 Main PID: 13242 (mysqld_safe)
   CGroup: /system.slice/mysqld.service
           ├─13242 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─13409 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mysqld.log --pid-file=/var/run/mys...

Nov 02 18:53:12 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: which will also give you the option of removing the test
Nov 02 18:53:12 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: databases and anonymous user created by default.  This is
Nov 02 18:53:12 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: strongly recommended for production servers.
Nov 02 18:53:13 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: See the manual for more instructions.
Nov 02 18:53:13 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: Please report any problems at http://bugs.mysql.com/
Nov 02 18:53:13 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: The latest information about MySQL is available on the web at
Nov 02 18:53:13 izwz9f55c9f7l08ddn5qz7z mysql-systemd-start[13183]: http://www.mysql.com
Nov 02 18:53:13 izwz9f55c9f7l08ddn5qz7z mysqld_safe[13242]: 171102 18:53:13 mysqld_safe Logging to '/var/log/mysqld.log'.
Nov 02 18:53:13 izwz9f55c9f7l08ddn5qz7z mysqld_safe[13242]: 171102 18:53:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Nov 02 18:53:14 izwz9f55c9f7l08ddn5qz7z systemd[1]: Started MySQL Community Server.

到这应该没有问题了，接下来就是怎么配置的问题了。

配置mysql,设置密码等

#配置mysql

[root@izwz ~]# mysql_secure_installation

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...
[root@izwz ~]#
半吊子读书人
关注
  • 2
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
阿里云CentOS7安装MySql记录
willow的博客
07-23 550
参考文章:https://blog.csdn.net/xyang81/article/details/51759200 1.下载mysql源安装包 shell&gt; wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2.安装mysql源 shell&gt; yum localinstall mys...
阿里云centos7中安装MySQL8.0.13的方法步骤
09-08
主要介绍了阿里云centos7中安装MySQL8.0.13的方法步骤，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧
CentOS安装mysql-devel出错解决方案
reg183的专栏
11-21 1219
我在安装mysql-devel出错。 yum install -y mysql-devel 会有类似这样的提示： Error: Package: 1:mariadb-devel-5.5.50-1.el7_2.x86_64 (updates) Requires: libmysqlclient.so.18()(64bit) Available: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 (base) libmysqlclient.so.18()(64bit)
在阿里云服务器上安装MySQL
最新发布
decade777555的博客
05-14 790
在阿里云服务器上安装MySQL的基本教程，本次示例以Centos7来示例，具体安装可以根据系统适合的安装包来选择。
【开发工具】【make】make 3.82源码编译安装
诸葛一帆丶的博客
01-21 1万+
摘要： 通过下载make 3.82源码，再编译机上安装make 3.82版本。 解决make版本过高的问题。 1、下载make 3.82： 下载地址为： wget ftp://ftp.gnu.org/gnu/make/make-3.82.tar.gz 我们以gdb-8.3.tar.gz 这个文件为例。 2、解压缩： $ tar xvf make-3.82.tar.gz 注：小技巧：Linux下一般压缩文件后缀为.tar.bz2和.tar.gz，它们解压命令有两三个选项是一致的： xf（
Centos7 rpm 和 yum
zlh0816
04-26 290
Linux(十) rpm 和 yum 1、rpm 包管理 ( 一般用于卸载软件和查询是否安装 ) 介绍 一种用于互联网下载包的打包及安装工具，它包含在某些Linux分发版中。它生成具有.RPM扩展名的文件。 简单指令 - 查看已安装的 rpm 列表 rpm –qa|grep xx rpm包名基本格式 (包名：make-3.82-23.el7.x86_64) 名称 说明 ...
【Centos 使用rpm离线安装 make cmake gcc g++】
milanla的博客
07-26 2998
不能联网的centos离线安装make cmake gcc g++
阿里云centos7安装mysql8.0.22的详细教程
01-19
找到Linux7的版本； 这里会自动下载最新的版本的mysql，我这里是mysql8.0.22 然后去拼接网址： http://dev.mysql.com/get/ + xxx.rpm 比如说我的是...
阿里云Centos 7.5安装Mysql的教程
12-16
CentOS 7的yum源中貌似没有正常安装MySQL时的mysql-sever文件，需要去官网上下载。 # wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm # rpm -ivh mysql-community-release-el7-5.noarch....
阿里云服务器CentOS7.X安装MySQL
10-24
说明：本文主要描述在centos7上安装mysql5.7.2。文中出现的/data/mysql 为本次安装mysql的目录，可以根据自己需要进行修改。最好将系统/etc/selinux/config文件中设置SELINUX=disabled
centos 7中编译安装httpd-2.4.25.tar.gz
weixin_30735745的博客
01-19 344
检查是否已经安装了下载工具wget和编译环境gcc、make： [root@jianxiangqiao ~]# rpm -qa|grep -e wget -e ^gcc -e makegcc-4.8.3-9.el7.x86_64 make-3.82-21.el7.x86_64 wget-1.14-10.el7_0.1.x86_64 如果没有安装，则使用下面的命令安装：yum -y install...
阿里云 Centos7.3安装mysql5.7.18 rpm安装教程
12-16
卸载MariaDB CentOS7默认安装MariaDB而不是MySQL，而且yum服务器上也移除了MySQL相关的软件包。因为MariaDB和MySQL可能会冲突，故先卸载MariaDB。 1、安装新版mysql之前，我们需要将系统自带的mariadb-lib卸载 [root@iZwz94qazh62gk5ewl4ei2Z home]# rpm -qa | grep -i mariadb  mariadb-libs-5.5.52-1.el7.x86_64 [root@iZwz94qazh62gk5ewl4ei2Z home]# rpm -e –nodeps mariadb-libs-5.5.
阿里云centos7使用yum安装mysql的正确姿势（推荐）
09-09
主要介绍了阿里云centos7使用yum安装mysql的正确姿势,需要的朋友可以参考下
Package 2:docker-1.13.1-88.git07f3374.el7.centos.x86_64 already installed and latest version
热门推荐
玥玥的博客博客博客
01-19 1万+
小伙伴买了腾讯云服务器，安装docker出现了如下问题： 输入：yum install docker -y 然后返回了如下 Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile Package 2:docker-1.13.1-88.git07f3374.el7.centos.x...
wget命令安装 ：Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version
amoudanfeng的博客
11-13 5682
wget命令安装： 问题描述 使用wget时，发现命令不存在 解决办法 1、安装wget，命令yum -y install wget，发现wget已经存在， 2、查找wget发现确实存在 — 命令 rpm -qa | grep “wget” 3、卸载wget — 命令 yum remove wget 4、重新安装wget 5、验证 ...
安装nginx出现./configure: error: C compiler cc is not found
weixin_42117851的博客
03-13 5624
[root@localhost nginx-1.14.2]# ./configure --prefix=/usr/local/lnmp/nginx --user=nginx --group=nginx --with-http_ssl_module --with-http_stub_status_module checking for OS Linux 3.10.0-123.el7.x86_64 ...
centos mysql 安装_阿里云Centos安装mysql教程
weixin_39522103的博客
11-28 81
一、基本安装过程1.查看系统是否安装了mysql软件# rpm -qa|grep -i mysql2.将已经安装过的软件卸载掉。注意：这样的卸载是不彻底的。# yum remove '软件名'3.下载安装mysql的repo源CentOS 7的yum源中默认是没有mysql的。所以，为了解决这个问题我们首先下载安装mysql的repo源。# wget http://repo.mysql....
阿里云centOS7 安装MySQL
颜良文丑的博客
10-21 283
阿里云 centOS7 安装MySQL简易流程记录
在阿里云的centos7上安装mysql5.6的方法
干勾鱼的CSDN博客
09-14 9768
阿里云的商业化产品现在使用的不少，使用阿里云的ECS安装mysql就变得很普遍。今天来讲一下在阿里云的centos7上安装mysql5.6的方法。 1 下载 直接使用yum命令下载mysql5.6来进行安装是不能成功的，安装过程会有问题，这里我们需要使用rpm命令来先进下载。下载路径为：http://dev.mysql.com/get/mysql-community-release-el7-5
阿里云centos7安装mysql
08-22
- *3* [阿里云centos7安装mysql](https://blog.csdn.net/boywcx/article/details/97097162)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

半吊子读书人

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值