CentOS 7.2 Yum 安装 MySQL 5.6 教程与步骤

193 浏览量更新于2024-08-30 收藏 53KB PDF 举报

在本文中，我们将详细介绍如何在CentOS 7.2环境中使用Yum编译安装MySQL 5.6版本。首先，文章强调了配置CentOS SCL (Software Collections) 源的重要性，因为SCL提供了对不同软件版本的支持，这里我们关注的是MySQL 5.6。步骤如下： 1. 配置CentOS SCLo源：在命令行中，用户需要安装`centos-release-scl-rh`和`centos-release-scl`，这将允许系统访问SCL仓库。然后，通过`sed`命令修改`/etc/yum.repos.d/CentOS-SCLo-scl.repo`和`/etc/yum.repos.d/CentOS-SCLo-scl-rh.repo`文件，增加`priority=10`，确保SCL仓库的优先级高于默认仓库，以便于安装MySQL 5.6。 2. 安装MySQL：使用`yum`命令，启用`centos-sclo-rh`仓库，并安装`rh-mysql56`中的`mysql-server`组件。这一步骤会下载并安装MySQL 5.6的源代码，而不是预编译的二进制包。 3. 加载MySQL环境变量：执行`scl enable rh-mysql56 bash`命令来激活MySQL 5.6的运行时环境，这将更改PATH以指向MySQL 5.6的bin目录，便于使用。 4. 验证安装和启动MySQL：进入MySQL shell运行`mysql -V`，确认安装的MySQL版本。通过`which mysql`查看MySQL可执行文件的路径。此外，为了实现MySQL的自动启动，用户需要编辑`/etc/profile.d/rh-mysql56.sh`文件，添加相应的启动命令。本文提供了在CentOS 7.2环境下使用Yum进行MySQL 5.6的源码编译安装和环境配置的详细步骤。这对于那些需要特定版本或定制化MySQL安装的用户来说是非常实用的指南。通过遵循这些步骤，用户可以确保在该系统上正确地安装、管理和维护MySQL服务器。

CentOS 7.2 Yum编译安装编译安装MySQL 5.6

本文实例为大家分享CentOS 7.2 Yum安装mysql5.6的方法，供大家参考，具体内容如下

配置配置CentOS SCLo源源

[3] 添加 CentOS SCLo Software collections Repository.

[root@linuxprobe~]# yum -y install centos-release-scl-rh centos-release-scl

# set [priority=10] [root@linuxprobe~]# sed -i -e "s/\]$/\]priority=10/g" /etc/yum.repos.d/CentOS-SCLo-scl.repo

[root@linuxprobe~]# sed -i -e "s/\]$/\]priority=10/g" /etc/yum.repos.d/CentOS-SCLo-scl-rh.repo

# for another way, change to [enabled=0] and use it only when needed

[root@linuxprobe~]# sed -i -e "s/enabled=1/enabled=0/g" /etc/yum.repos.d/CentOS-SCLo-scl.repo

[root@dlp ~]# sed -i -e "s/enabled=1/enabled=0/g" /etc/yum.repos.d/CentOS-SCLo-scl-rh.repo

yum安装安装MySQL

# 安装mysql

[root@linuxprobe~]# yum --enablerepo=centos-sclo-rh -y install rh-mysql56-mysql-server

# 加载环境变量

[root@linuxprobe ~]# scl enable rh-mysql56 bash

[root@linuxprobe ~]# mysql -V

mysql Ver 14.14 Distrib 5.6.26, for Linux (x86_64) using EditLine wrapper

[root@linuxprobe ~]# which mysql

/opt/rh/rh-mysql56/root/usr/bin/mysql

# 设置mysql开机自启动

root@linuxprobe ~]# vi /etc/profile.d/rh-mysql56.sh

#!/bin/bash

source /opt/rh/rh-mysql56/enable

export X_SCLS="`scl enable rh-mysql56 'echo $X_SCLS'`"

[4] Enable MySQL 5.6 and Configure initial settings.

[root@linuxprobe ~]# vi /etc/opt/rh/rh-mysql56/my.cnf.d/mysql-server.cnf

# add follows within [mysqld] section

[mysqld] character-set-server=utf8

[root@linuxprobe ~]# systemctl start rh-mysql56-mysqld

[root@linuxprobe ~]# systemctl enable rh-mysql56-mysqld

[root@linuxprobe ~]# 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

Set 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

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

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.

# remove test database

Remove test database and access to it? [Y/n] - Dropping test database...

... Success!

- Removing privileges on test database...

... Success!

下载后可阅读完整内容，剩余4页未读，立即下载

weixin_38592611

粉丝: 8
资源: 879

CentOS 7.2 Yum 安装 MySQL 5.6 教程与步骤

最新资源