开发者社区> lauren_liuling> 正文

CentOS中安装MySQL数据库

简介:
+关注继续查看

1、首先下载MySQL的安装文件,我这里安装的是MySQL5.1.7版本的,

  下载链接:http://pan.baidu.com/share/link?shareid=255483056&uk=924063144

         http://pan.baidu.com/share/link?shareid=269901909&uk=924063144

2、安装MySQL数据库服务器

  进入安装包所在文件夹,执行命令 rpm -ivh MySQL-server-5.1.7-0.i386.rpm 安装MySQL服务器。

  如果报了与原先版本冲突的话,就执行rpm -qa|grep -i mysql命令,会显示已安装的Mysql版本,我的显示mysql-libs-5.1.61-4.el6.i686
这时如果有的话就强制删除:rpm -e –nodeps mysql-libs-5.1.61-4.el6.i686(因为有包依赖,所以要强制删除)

我的报错提示如下:

MySQL-server-5.1.7-0.i386.rpm
Preparing…                ########################################### [100%]
    file /usr/share/mysql/charsets/README from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/dutch/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/greek/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/hungarian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/italian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/japanese/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/korean/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/norwegian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/polish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/portuguese/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/romanian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/russian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/serbian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/slovak/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686
    file /usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm  conflicts with file from package mysql-libs-5.1.61-4.el6.i686

这时候再执行rpm -ivh MySQL-server-5.1.7-0.i386.rpm安装即可安装成功。
我这里安装成功了,但是mysql服务无法启动,总是启动失败,后来百度了一下,是因为selinux的原因,只要将selinux关闭就OK了。
关闭selinux:vi /etc/selinux/config 将SELINUX=enforcing 改成SELINUX=disabled 然后重启
关闭selinux之后还是无法启动mysql服务,因为安装的mysql所有者是root,在安装mysql的时候会创建一个用户mysql,只要将/var/lib/mysql
的所有者改为mysql就OK了,执行命令chown -R mysql:mysql /var/lib/mysql
现在执行service mysql start终于可以启动mysql服务了。

 

3.安装MySQL客户端
执行命令rpm -ivh MySQL-client-5.1.7-0.i386.rpm进行安装。

 

4.安装成功

  成功安装MySQL后将sql文件导入到数据库,步骤如下:

  进入MYSQL Command Line Client
1、先创建数据库:create database test 注:test是创建数据库的名称
2、再切换到当前数据库:use test
3、再输入:. /root/test.sql 或 souce /root/test.sql

  按照以上步骤就可以将备份的sql脚本导入到linux中的数据库中去。

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Linux安装MySQL 【重新认识MySQL上篇】
本文摘录自 ▪ 小孩子4919《MySQL是怎样运行的:从根儿上理解MySQL》 该篇文章初心是介绍MySQL的安装,但是随着后面不断的学习,遇到的坑越来越多,导致本篇文章不断的更新,敬请谅解!
18 0
MySQL-索引优化篇(1)_安装演示库 & [前缀索引、联合索引、覆盖索引] & explain参数
MySQL-索引优化篇(1)_安装演示库 & [前缀索引、联合索引、覆盖索引] & explain参数
10 0
从零开始学MYSQL - MYSQL安装
​ 这个专栏也可以认为是学习笔记,由于之前的专栏学习的是网络上的培训机构教程,学习完成之后发现虽然讲到一些有一些深入的东西,但是讲的都不是特别深,所以从这一节开始将会从零开始来全盘了解MYSQL,这里找了一本书《从根上理解Mysql》,个人也十分推荐读者去看看这边书,不仅有新特性对接讲解,也有很多的干货,同时讲的也十分好,作为支持个人后面也买了一本实体书(虽然基本都是拿pdf看的)。
15 0
【MySQL新手到通关】第二章 MySQL卸载安装
【MySQL新手到通关】第二章 MySQL卸载安装
60 0
【MySQL学习笔记】系列二:MySQL环境搭建(卸载、下载、安装、配置、登录)(三)
【MySQL学习笔记】系列二:MySQL环境搭建(卸载、下载、安装、配置、登录)(三)
41 0
【MySQL学习笔记】系列二:MySQL环境搭建(卸载、下载、安装、配置、登录)(二)
【MySQL学习笔记】系列二:MySQL环境搭建(卸载、下载、安装、配置、登录)(二)
48 0
【MySQL学习笔记】系列二:MySQL环境搭建(卸载、下载、安装、配置、登录)(一)
【MySQL学习笔记】系列二:MySQL环境搭建(卸载、下载、安装、配置、登录)(一)
50 0
Mysql 三种安装方式
Mysql 三种安装方式
56 0
Linux 安装 JDK、MySQL、Tomcat(图文并茂)
Linux 安装 JDK、MySQL、Tomcat(图文并茂)
37 0
+关注
lauren_liuling
文章
问答
视频
文章排行榜
最热
最新
相关电子书
更多
高效MySQL的N个习惯
立即下载
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
相关镜像