mysql5.6 centos7下安装之rpm安装

最新推荐文章于 2021-02-02 02:10:41 发布
最新推荐文章于 2021-02-02 02:10:41 发布
阅读量3.2k 收藏
点赞数 2
分类专栏： mysql-安装 文章标签： mysql centos rpm
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_21057321/article/details/51383786
版权

参考：mysql安装一 rpm包安装

一：下载与解压

  1. 下载地址：mysql-5.6-30 密码：mg0r 我放到了 /usr/local/mysql 传输的话可以考虑winscp

  2. 创建并解压至mysql目录

    mkdir mysql
tar xvf MySQL-5.6.30-1.linux_glibc2.5.x86_64.rpm-bundle.tar -C /usr/local/mysql/

二：安装前的准备

  1. 安装MySQL-shared-compat替换mysql-libs，如果不替换，在删除mysql-libs，会提示postfix依赖于mysql-libs：

    # rpm -ivh MySQL-shared-compat-5.6.21-1.el6.i686.rpm
# rpm -qa | grep -i mysql
mysql-libs-5.1.71-1.el6.i686
MySQL-shared-compat-5.6.21-1.el6.i686
# yum remove mysql-libs

  2. 测试MySQL-server安装，提示需要安装perl：

    # rpm -ivh --test MySQL-server-5.6.21-1.el6.i686.rpm
# yum install perl
    • –test 安装测试，并不实际安装,可以检查依赖关系
    • +

三：安装客户端与服务端

  1. cd /usr/local/mysql

  2. 安装客户端

    rpm -ivh  MySQL-client-5.6.30-1.linux_glibc2.5.x86_64.rpm

  3. 安装server

     yum install MySQL-server-5.6.30-1.linux_glibc2.5.x86_64.rpm

    注意：yum install 和rpm -ivh差不多，猜想差别是yum会自动安装依赖吧。
    我遇到的问题，由于我之前编译安装过mysql报了:

      Transaction check error:
         file /usr/share/mysql/charsets/README from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts      with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
  file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
  file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
  file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.6.30-1.linux_glibc2.5.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64...

    解决方法执行：yum remove mariadb-libs 和yum remove mysql-libs 也不知哪个起到了作用

  4. 安装成功会出现以下日志（会产生一个随机的root密码保存在/root/.mysql_secret中）：如果没有这句话顺利安装了，那么密码就是空，初始化让输入旧密码的时候直接回车即可

            A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
（一个随机的root密码已经生成被放在'/root/.mysql_secret文件中）
You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
  /usr/bin/mysql_secure_installation
which will also give you the option of removing the test database.
This is strongly recommended for production servers.
See the manual for more instructions.
Please report any problems at http://bugs.mysql.com/
The latest information about MySQL is available on the web at
  http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
  验证中      : MySQL-server-5.6.30-1.linux_glibc2.5.x86_64                                                                                                                                                  1/1 
已安装:
  MySQL-server.x86_64 0:5.6.30-1.linux_glibc2.5                                                                                                                                                                  
完毕！

  5. copy配置文件 没有这一步也可以按内置参数

    [root@host2 mysql_rpm]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf
    [root@host2 mysql_rpm]#

四：初始化

  1. 查看刚才产生的密码：

    cat /root/.mysql_secret

    输出：

    The random password set for the root user at Thu Apr 28 03:43:28 2016 (local time): TtuLj3wmj345xpmX

  2. 启动mysql：

      service mysql start

  3. 通过mysql_secure_installation执行mysql初始化

    [root@localhost xiaoli]# 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.
（下面的意思，输入mysql生成的密码）
Enter current password for root (enter for none): 

输入密码：TtuLj3wmj345xpmX

 The random password set for the root user at Thu Apr 28 03:43:28 2016 (local time): TtuLj3wmj345xpmX

    再次执行：

    [root@localhost xiaoli]# 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.

You already have a root password set, so you can safely answer 'n'.
（是否要修改root密码）
Change the root password? [Y/n] y
          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.
（禁止用户远程登录？开发环境安全要求不严格 n，生产环境要求严格 y,我是个严格的人，y）
Disallow root login remotely? [Y/n] y
 ... Success!

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.
（是否删掉测试数据库，果断y）
Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
（重载权限让权限立即生效？y）
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...

    安装完毕 ！！！

  4. RPM安装方式文件分布

DirectoryContentsof Directory
/usr/binClientprograms and scripts
/usr/sbinThemysqldserver
/var/lib/mysqlLogfiles, databases
/usr/share/infoManualin Info format
/usr/share/manUnixmanual pages
/usr/include/mysqlInclude(header) files
/usr/lib/mysqlLibraries
/usr/share/mysqlMiscellaneoussupport files, including error messages, character set files,sample configuration files, SQL for database installation
/usr/share/sql-benchBenchmarks
小李飞菜刀
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MySQL5.6 RPM安装包文件
01-21
MySQL 5.6 RPM安装包文件，具体安装方式详见博客：http://blog.csdn.net/l1028386804/article/details/53934656
Centos 6.5下安装MySQL 5.6教程
09-09
在本文中，我们将深入探讨如何在CentOS 6.5操作系统上安装MySQL 5.6。MySQL是一个流行的开源关系型数据库管理系统（RDBMS），它为开发者提供了强大的数据存储和管理能力。下面是安装MySQL 5.6的详细步骤： 1. **...
CentOS6.5系统下RPM包安装MySQL5.6
我只是一个简单的Coder，为了兴趣和理想奋斗在生活的道路上
07-27 601
1.查看操作系统相关信息。 [root@linuxidc ~]# cat /etc/issue  CentOS release 6.5 (Final)  Kernel \r on an \m  [root@linuxidc ~]# uname -a  Linux linuxidc 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC
RPM方式安装MySQL5.6
guanyi的博客
01-13 862
RPM方式安装MySQL5.6 a. 检查MySQL及相关RPM包，是否安装，如果有安装，则移除（rpm –e 名称） 1 [root@localhost ~]# rpm -qa | grep -i mysql 2 mysql-libs-5.1.66-2.el6_3.x86_64 3 [root@localhost ~]# yum -y remove mysql-li...
MySQL5.6 安装（CentOS7 RPM方式安装）
dlt77585211314的博客
01-16 2135
一、下载MySql 1、官网下载地址：https://dev.mysql.com/downloads/mysql/ 2、选择老版本mysql 3、根据具体需求选要下载的mysql 版本 4、下载 server和client 的rpm安装包 5、不需要登录直接下载即可 二、安装MySQL 1、centos7 会自带mariadb（mysql 完全开源版本）相关的组件，首...
centos7rpm安装mysql5.6
牵佳一诺的博客
12-18 519
rpm -qa | grep -i mariadb 检查自带的mysql rpm -e --nodeps mariadb-libs.. 删除自带mysql rpm -qa | grep -i mysql rpm
CentOS下RPM方式安装MySQL5.6教程
09-09
在本文中，我们将深入探讨如何在CentOS操作系统中使用RPM包管理器来安装MySQL 5.6。RPM（Red Hat Package Manager）是Linux发行版如CentOS中广泛使用的软件包管理工具，用于安装、升级和卸载软件。以下是详细步骤： ...
centos7下mysql 5.6离线安装包，附操作手册
11-13
总结来说，离线安装MySQL 5.6在CentOS 7上需要下载RPM包，解决依赖，然后逐个安装RPM文件，并进行安全初始化。附带的操作手册是整个过程的关键，它为用户提供详细的步骤指导，确保无网络环境下的安装也能顺利完成。
CentOS 7 安装并配置 MySQL 5.6的步骤详解
09-09
以上就是CentOS 7环境下安装和配置MySQL 5.6的详细步骤。遵循这些步骤，你应该能够成功地在你的系统上安装并开始使用MySQL 5.6数据库服务器。记得在生产环境中，还需要考虑备份策略、性能调优和安全策略等高级配置。
CentOS6.5一键安装Mysql5.6
08-28
本文将详细介绍如何在CentOS 6.5上进行MySQL 5.6的一键安装过程，包括必要的环境准备、安装步骤、配置优化以及安全设置。 一、环境准备 在开始安装之前，确保你的CentOS 6.5系统已经更新到最新，运行以下命令进行...
mysql5.6.36的rpm安装包
03-07
mysql5.6.36的rpm安装包。MySQL 是最流行的关系型数据库管理系统之一，在 WEB 应用方面，MySQL是最好的 RDBMS (Relational Database Management System，关系数据库管理系统) 应用软件。
mysql-community-server-5.6.43-2.el6.x86_64.rpm
11-21
Mysql安装包，for Linux 64位 开源 rpm包，文件名mysql-community-server-5.6.43-2.el6.x86_64.rpm
MySQL-shared-compat-5.6.45-1.el7.x86_64.rpm
10-02
Linux Mysql 5.6.45版本64位通用版shared rpm包 MySQL-shared-5.6.45-1.el7.x86_64.rpm
MySQL-client-5.6.46-1.el7.x86_64.rpm
08-11
Linux安装MySQL客户端所需文件
mysql-community-server-5.5.62-2.el6.x86_64 for Linux 64位 rpm包
11-21
mysql安装包，for Linux 64位rpm开源版本。文件名为mysql-community-server-5.5.62-2.el6.x86_64.rpm
centos rpm安装mysql5.6_centos7 RPM方式安装MySQL5.6
weixin_35696092的博客
01-26 113
a) 查看centos版本cat /etc/redhat-releaseb) 卸载MariaDB (centos7默认自带)查看当前安装的mariadb包： rpm -qa | grep mariadb强制卸载： rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64c) 查看是否已经安装了MySQLrpm -qa | grep -i mys...
centos rpm安装mysql5.6_在CentOS中安装MySQL5.6的rpm包
weixin_35688303的博客
01-18 94
没想到MySQL5.6和5.7的差别还是挺大的，rpm包的安装也不一样。本文记录在CentOS上安装MySQL5.6的过程。卸载mariadb-libs：$sudo yum remove mariadb-libs首先区官网下载MySQL5.6的rpm包：mysql-5.6.44-1.el7.x86_64.rpm-bundle.tar，然后解压。安装client：$sudo yum install ...
mysql5.6 rpm_centos6.5 mysql5.6 RPM安装
weixin_39605345的博客
02-02 147
#rpm -ivhMySQL-server-5.6.31-1.el6.x86_64.rpm#rpm -ivhMySQL-client-5.6.31-1.el6.x86_64.rpm#rpm -ivhMySQL-devel-5.6.31-1.el6.x86_64.rpm#rpm -ivhMySQL-embedded-5.6.31-1.el6.x86_64.rpm#rpm -ivhMySQL-...
Centos7下使用rpm包安装mysql5.6数据库
lswzw的博客
04-23 1809
Centos7下使用rpm包安装mysql数据库 环境 [root@mysql01 ~]# uname -r 3.10.0-514.el7.x86_64 [root@mysql01 ~]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) 1.卸载MariaDB（CentOS7 默认自带） rpm -qa | grep ...
centos7 离线安装mysql5.6
最新发布
04-25
很好，对于您的问题，以下是在 CentOS 7 上离线安装 MySQL 5.6 的步骤： 步骤 1：下载 MySQL 5.6 的安装包 您可以从官方网站下载 MySQL 5.6 的二进制版本，并将其上传到 CentOS 7 服务器上。 步骤 2：安装 MySQL 5.6 执行以下命令安装 MySQL 5.6： sudo rpm -Uvh MySQL-server-5.6.50-1.el7.x86_64.rpm sudo rpm -Uvh MySQL-client-5.6.50-1.el7.x86_64.rpm 步骤 3：启用 MySQL 5.6 执行以下命令启用 MySQL 5.6： sudo systemctl enable mysqld.service sudo systemctl start mysqld.service 步骤 4：设置 MySQL 5.6 密码 执行以下命令设置 MySQL 5.6 的 root 密码： sudo mysql_secure_installation 此命令将提示您设置 root 密码，并关闭匿名用户访问、删除测试数据库，并在 MySQL 中删除任何不必要的用户帐户。 现在，您已经成功地在 CentOS 7 上离线安装了 MySQL 5.6！

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值