亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb

首頁 > 服務器 > 管理維護 > 正文

CentOS服務器中安裝MySQL數據庫

2024-09-10 14:20:06
字體:
來源:轉載
供稿:網友

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中的數據庫中去。

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb
亚洲美腿欧美激情另类| 永久免费看mv网站入口亚洲| 精品视频—区二区三区免费| 亚洲人成电影在线播放| 国产视频精品va久久久久久| 91精品国产91久久久久久吃药| 久久久国产91| 久久夜色撩人精品| 欧美在线视频一二三| 91精品久久久久久久久中文字幕| 91黑丝在线观看| 亚洲国产精品va在线看黑人| 久久久综合免费视频| 精品久久久久久久久久久久久久| 亚洲精品欧美日韩专区| 日韩中文字幕av| 欧美一级片久久久久久久| 日韩极品精品视频免费观看| 欧美成人精品xxx| 欧美日韩免费在线观看| www.亚洲一二| 综合av色偷偷网| 国产精品情侣自拍| 国产一区二区黑人欧美xxxx| 米奇精品一区二区三区在线观看| 久久久久久中文字幕| 欧美电影在线免费观看网站| 国产精品久久电影观看| 久久国产色av| 成人黄色大片在线免费观看| 国产精品久久久久久av福利软件| 国产精品美女网站| 国产精品视频久久久| 久久久久久久久综合| 久久激情视频免费观看| 成人妇女淫片aaaa视频| 永久免费毛片在线播放不卡| 亚洲欧美日韩一区在线| 欧美日韩国产综合视频在线观看中文| 日韩视频免费大全中文字幕| 国产色婷婷国产综合在线理论片a| 琪琪亚洲精品午夜在线| 91视频-88av| www日韩欧美| 日韩在线观看免费网站| 韩日欧美一区二区| 亚洲影院色无极综合| 日韩精品在线视频| 亚洲视频在线观看网站| 性视频1819p久久| 91视频免费在线| 国产aⅴ夜夜欢一区二区三区| 日韩亚洲第一页| 国产日韩欧美电影在线观看| 欧美日韩国产第一页| 国产欧美在线观看| 亚洲人成网站777色婷婷| 欧美在线一级va免费观看| 日韩精品极品毛片系列视频| 中文字幕国产精品| 黑人巨大精品欧美一区二区免费| 欧美重口另类videos人妖| 国产精品电影在线观看| 欧美激情精品久久久久久| 欧美一区二区视频97| 欧美精品日韩www.p站| 92国产精品久久久久首页| 欧美成人sm免费视频| 亚洲成人黄色网| 成人国产在线视频| 亚洲精品久久7777777| 成人免费福利视频| 国产精品中文字幕在线| 亚洲电影免费观看高清完整版在线| 欧美激情伊人电影| 美女福利精品视频| 日本一区二区在线免费播放| 色综合久久天天综线观看| 久久久精品国产网站| 精品电影在线观看| 成人av番号网| 亚洲成人动漫在线播放| 国产婷婷成人久久av免费高清| 国产欧美日韩免费看aⅴ视频| 2019亚洲日韩新视频| 亚洲精品日韩av| 中文综合在线观看| 日韩成人av网址| 久久久精品久久久久| 91中文字幕在线观看| 亚洲成人黄色在线| 日本久久久久久久久久久| 精品日韩视频在线观看| 日韩av一卡二卡| 一区二区三区国产在线观看| 亚洲成人网av| 欧美精品videos另类日本| 亚洲国产精品成人av| 亚洲一区二区三区在线免费观看| 欧美乱大交xxxxx另类电影| 色噜噜狠狠狠综合曰曰曰| 久久精品国产亚洲精品| 热久久这里只有| 亚洲精品日产aⅴ| 国产精品777| 富二代精品短视频| 国产精品久久久久久久av电影| 第一福利永久视频精品| 日本午夜人人精品| 91产国在线观看动作片喷水| 欧美小视频在线观看| 久久久久国产精品一区| 国产日产亚洲精品| 97精品久久久中文字幕免费| 欧美日韩爱爱视频| 97超级碰碰人国产在线观看| 性欧美亚洲xxxx乳在线观看| 色先锋久久影院av| 亚洲热线99精品视频| 久久福利视频网| 亚洲人成网在线播放| 精品久久久久久国产91| 日韩精品在线视频| 久久亚洲影音av资源网| 亚洲第一av在线| 中文字幕综合在线| 亚洲精品中文字幕av| 琪琪第一精品导航| 国模视频一区二区三区| 欧美性极品少妇精品网站| 欧美贵妇videos办公室| 91免费看片在线| 久久久久久九九九| 中文字幕不卡在线视频极品| 久久免费在线观看| 欧美一区二区.| 亚洲精品美女在线观看| 91av视频导航| 91精品视频在线免费观看| 成人性生交大片免费观看嘿嘿视频| 爱福利视频一区| 日韩不卡中文字幕| 亚洲男人天堂古典| 亚洲人成在线播放| 亚洲字幕一区二区| 97在线精品视频| 中文字幕亚洲一区二区三区五十路| 91po在线观看91精品国产性色| 日韩小视频在线| 91在线免费看网站| 色777狠狠综合秋免鲁丝| 成人在线激情视频| 久热精品视频在线观看一区| 国产69精品久久久久9| 欧美性感美女h网站在线观看免费| 欧美亚洲另类视频| 亚洲精品国产福利| xx视频.9999.com| 国产美女直播视频一区| 亚洲人成网站免费播放| 日本欧美爱爱爱| 亚洲国产天堂久久综合| 亚洲成人av在线| 久久中文字幕视频|