CentOS服务器中安装MySQL数据库

作者：西西点击：29次评论：1次标签： CentOS MySQL数据库

迅雷7v7.9.44.5056 官方最新版

类型：下载工具大小：40.0M语言：中文评分：9.7
标签：

立即下载

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