centos7卸载自带maridb,安装mysql5.6

本文介绍了如何在CentOS7系统中卸载默认的MariaDB,然后通过RPM和YUM安装MySQL5.6的过程,包括解决yum锁问题、配置启动项、设置密码和开放防火墙端口。

1.列出安装的包

# rpm -qa | grep mariadb

mariadb-libs-5.5.41-2.el7_0.x86_64


2.卸载包

# rpm -e --nodeps mariadb-libs-5.5.41-2.el7_0.x86_64


3.安装rpm包

# rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

[root@localhost ~]# 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
curl: (7) Failed connect to dev.mysql.com:443; Connection refused
error: skipping http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm - transfer failed
[root@localhost ~]# 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%]


4.查看当前可用的mysql安装资源

[root@localhost ~]# yum repolist enabled | grep "mysql.*-community.*"
Existing lock /var/run/yum.pid: another copy is running as pid 48035.
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: PackageKit
    Memory : 152 M RSS (557 MB VSZ)
    Started: Sat Nov 25 18:27:02 2017 - 37:44 ago
    State  : Sleeping, pid: 48035


5.原因就是yum在自动更新 只要关掉他就可以了

[root@localhost ~]#  rm -f&nbs

CentOS 7系统下使用tar.gz包安装MySQL 5.6,可按以下步骤进行: ### 1. 创建MySQL用户组和用户 ```bash [root@localhost ~]# useradd -g mysql mysql ``` 此步骤创建了一个名为`mysql`的用户组和用户,用于后续MySQL的运行和管理[^3]。 ### 2. 下载MySQL 5.6的tar.gz包 ```bash [root@local-test ~]# wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz ``` 使用`wget`命令从指定链接下载MySQL 5.6的tar.gz安装包[^1]。 ### 3. 移动并解压安装包 将下载的压缩包移动到`/usr/local/`目录下并解压: ```bash mv mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz /usr/local/ cd /usr/local/ tar -zxvf mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz ``` 将安装包移动到`/usr/local/`目录,然后在该目录下进行解压操作。 ### 4. 安装数据库 ```bash /usr/local/mysql5.6/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql5.6 --datadir=/usr/local/mysql5.6/data ``` 执行该命令来初始化MySQL数据库,指定了用户为`mysql`,基础目录和数据目录[^2]。 ### 5. 配置`/etc/my.cnf`文件 编辑`/etc/my.cnf`文件,内容如下: ```ini [mysqld] datadir=/usr/local/mysql socket=/usr/local/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd [mysqld_safe] log-error=/usr/local/mysql/log/localhost.localdomain.log pid-file=/usr/local/mysql/pid/localhost.localdomain.pid # # include all files from the config directory # !includedir /etc/my.cnf.d ``` 此配置文件指定了数据目录、套接字文件位置、日志文件位置等重要参数[^4]。 ### 6. 启动MySQL服务 完成上述步骤后,就可以启动MySQL服务,开始使用数据库。具体启动命令需根据实际情况进一步查找相关资料确定。
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值