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

首頁 > 系統 > CentOS > 正文

centos安裝mysql數據庫的方法

2020-06-21 13:08:07
字體:
來源:轉載
供稿:網友

1、首先下載MySQL的安裝文件,我這里安裝的是MySQL5.1.7版本的,

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
欧美极品少妇xxxxⅹ喷水| 欧美亚洲日本黄色| 亚洲xxxxx| 欧美裸身视频免费观看| 国产精品网红直播| 日韩中文字幕网站| 国产午夜精品麻豆| 久久久久久久色| 国产91色在线| 91麻豆桃色免费看| 欧美黄色小视频| 热门国产精品亚洲第一区在线| 亚洲第一网中文字幕| 美女999久久久精品视频| 欧美午夜电影在线| 欧美视频中文在线看| 亚洲精品色婷婷福利天堂| 一本色道久久88亚洲综合88| 日韩中文在线中文网三级| 欧美精品一区二区三区国产精品| 亚洲免费av网址| 亚洲国产精品久久| 国产在线拍揄自揄视频不卡99| 中文在线资源观看视频网站免费不卡| 久久久国产精品x99av| 欧美一级电影免费在线观看| 国产成人精品在线| 成人黄色网免费| 一区二区三区精品99久久| 91在线观看免费观看| 国产精品狠色婷| 日韩第一页在线| 综合网中文字幕| 成人自拍性视频| 日韩精品一区二区视频| 欧美午夜片在线免费观看| 欧美亚洲另类视频| 欧美激情一级欧美精品| 亚洲欧美日韩另类| 欧美一级视频一区二区| 亚洲男人的天堂在线| 欧美激情精品久久久久久变态| 色诱女教师一区二区三区| 日韩av在线一区二区| 91久热免费在线视频| 日韩欧美亚洲范冰冰与中字| 欧美日韩精品二区| 欧美—级a级欧美特级ar全黄| 成人欧美一区二区三区在线湿哒哒| 久久久噜噜噜久久久| 亚洲美女www午夜| 成人有码在线视频| 91香蕉国产在线观看| 亚州国产精品久久久| 久久色精品视频| 正在播放国产一区| 国产久一一精品| 97av在线视频免费播放| 91精品国产91久久久久久最新| 成人精品一区二区三区| 国产精品久久综合av爱欲tv| 国产精品678| 欧美成人亚洲成人日韩成人| 欧美孕妇毛茸茸xxxx| 亚洲黄色成人网| 日韩免费av片在线观看| 亚洲欧美激情另类校园| 国模叶桐国产精品一区| 亚洲第一男人av| 欧美国产欧美亚洲国产日韩mv天天看完整| 欧美成人免费va影院高清| 久久噜噜噜精品国产亚洲综合| 亚洲在线视频观看| 亚洲va欧美va国产综合久久| 一夜七次郎国产精品亚洲| 中文字幕一区电影| 日韩免费中文字幕| 亚洲精品98久久久久久中文字幕| 亚洲а∨天堂久久精品喷水| 性亚洲最疯狂xxxx高清| 久久精品91久久久久久再现| 日韩精品视频在线观看网址| 久久激情五月丁香伊人| 国产成人一区二区三区电影| 国产精品极品美女在线观看免费| 中国人与牲禽动交精品| 2019中文字幕全在线观看| 亚洲伊人久久综合| 国产精品毛片a∨一区二区三区|国| 精品久久久久久电影| 岛国av一区二区在线在线观看| 色妞在线综合亚洲欧美| 国产精品亚洲片夜色在线| 成人h猎奇视频网站| 欧美不卡视频一区发布| 亚洲另类图片色| 成人久久精品视频| 国产a级全部精品| 亚洲精品中文字幕女同| 91精品久久久久久久久久另类| 清纯唯美日韩制服另类| 欧美黄色小视频| 久久精品国产一区| 97超级碰碰碰| 精品精品国产国产自在线| 日本免费一区二区三区视频观看| 欧美一级片免费在线| 国产大片精品免费永久看nba| 午夜精品蜜臀一区二区三区免费| 国产成人精品久久二区二区| 国产精品丝袜久久久久久不卡| 欧美精品久久一区二区| 欧美午夜性色大片在线观看| 91成人福利在线| 久久久久久久一区二区| 国产亚洲精品激情久久| 国产日韩欧美日韩大片| 欧美限制级电影在线观看| 啊v视频在线一区二区三区| 亚洲一级片在线看| 亚洲视频欧美视频| 久久亚洲精品中文字幕冲田杏梨| 国产成人高清激情视频在线观看| 亚洲国产97在线精品一区| 亚洲国产精品久久精品怡红院| 久久在线观看视频| 成人黄色在线免费| 91在线观看免费观看| 亚洲国产婷婷香蕉久久久久久| 国产欧美精品在线播放| 亚洲自拍中文字幕| 亚洲成人黄色网| 7m第一福利500精品视频| 欧美日韩成人免费| 在线成人中文字幕| 成人激情视频免费在线| 亚洲精品福利视频| 国产亚洲精品久久久久久| 精品久久久久久久久国产字幕| 成人黄色av播放免费| 日韩av手机在线| 亚洲综合中文字幕在线观看| 亚洲视频在线看| 成人免费视频a| 国产97人人超碰caoprom| 91精品国产91久久久久久久久| 色悠悠久久88| 久久91亚洲人成电影网站| 亚洲香蕉成视频在线观看| 欧美激情乱人伦| 亚洲福利视频在线| 久热精品视频在线免费观看| 日本不卡高字幕在线2019| 日韩精品在线免费观看视频| 国内精品小视频| 日韩h在线观看| 欧美成人精品h版在线观看| 国产亚洲精品美女| 国产一区二区欧美日韩| 国产999精品久久久| 成人a在线观看| 精品久久香蕉国产线看观看gif| 国内精品一区二区三区| 日韩在线激情视频|