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

首頁 > 系統 > CentOS > 正文

centos安裝mysql數據庫的方法

2020-07-08 12:56:51
字體:
來源:轉載
供稿:網友

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
欧美在线一区二区三区四| 欧美综合激情网| 最近2019中文免费高清视频观看www99| 欧美激情亚洲一区| 亚洲欧洲国产一区| 美日韩丰满少妇在线观看| 国产精品美腿一区在线看| 国产精品999999| 91九色视频在线| 精品亚洲一区二区| 中文字幕日韩欧美精品在线观看| 欧美日韩国产999| 美女啪啪无遮挡免费久久网站| 日韩精品在线观| 久久久久久久一区二区| 在线视频免费一区二区| 国产精品视频免费观看www| 亚洲毛片在线观看| 高清一区二区三区四区五区| 久久精品99无色码中文字幕| 日韩一区视频在线| 亚洲爱爱爱爱爱| 欧美国产亚洲精品久久久8v| 亚洲最大av网| 日本精品va在线观看| 日韩在线视频播放| 伊人伊成久久人综合网站| 日韩在线一区二区三区免费视频| 国产成人福利夜色影视| www国产91| 91久久国产婷婷一区二区| 欧美国产在线视频| 日韩电影免费在线观看| 精品人伦一区二区三区蜜桃免费| …久久精品99久久香蕉国产| 日韩在线观看高清| 久久久女人电视剧免费播放下载| 久久成年人视频| 国产一区二区激情| 久久久噜噜噜久久| 奇米四色中文综合久久| 国产成人在线一区二区| 国产精品揄拍一区二区| 亚洲精品电影在线观看| 91深夜福利视频| 日本国产精品视频| 亚洲欧美一区二区三区情侣bbw| 成人自拍性视频| 精品美女久久久久久免费| 亚洲国产日韩欧美在线图片| 亚洲а∨天堂久久精品喷水| 91av在线看| 亚洲激情视频在线播放| 亚洲精品xxxx| 精品国产乱码久久久久久虫虫漫画| 日韩欧美成人区| 日韩高清人体午夜| 日韩精品在线电影| 欧美壮男野外gaytube| 91香蕉亚洲精品| 国产日产亚洲精品| 日韩av综合中文字幕| 亚洲精品日韩久久久| 一本色道久久88亚洲综合88| 国产精品久久久久久超碰| 欧美伊久线香蕉线新在线| 欧美孕妇孕交黑巨大网站| 午夜精品一区二区三区在线视| 成人免费直播live| 97精品欧美一区二区三区| 日本一区二区在线播放| 亚洲国产日韩欧美在线动漫| 清纯唯美日韩制服另类| 91久久久久久久久| 国产999精品视频| 国产精品中文字幕久久久| 成人免费视频a| 日韩在线视频观看正片免费网站| 国产激情久久久久| 美女视频黄免费的亚洲男人天堂| 国产日韩欧美在线播放| 亚洲欧美综合精品久久成人| 欧美精品一区二区三区国产精品| 精品美女永久免费视频| 国产精品极品尤物在线观看| 91探花福利精品国产自产在线| 国产精品久久久久久久久久久新郎| 一个人看的www欧美| 亚洲欧美福利视频| 中日韩美女免费视频网站在线观看| 亚洲第一网站免费视频| 精品国偷自产在线| 国产精品福利久久久| 精品视频在线播放免| 亚洲天堂网在线观看| 国产精品人成电影在线观看| 久热在线中文字幕色999舞| 久久久久五月天| 日本韩国欧美精品大片卡二| 亚洲性av网站| 欧美激情精品久久久久久蜜臀| 成人激情在线观看| 97久久精品人人澡人人爽缅北| 亚洲激情视频网| 欧美国产日本高清在线| 久久影视电视剧免费网站| 国产精品自拍网| 成人a在线视频| 97久久精品视频| 日韩精品丝袜在线| 亚洲精品日产aⅴ| 久久久久久久香蕉网| 国内精品小视频在线观看| 不卡毛片在线看| 日韩精品视频免费| 欧美高清视频在线观看| 国产精品毛片a∨一区二区三区|国| 亚洲第一精品夜夜躁人人爽| 免费av在线一区| 国产亚洲精品美女久久久久| 热久久美女精品天天吊色| 2019国产精品自在线拍国产不卡| 欧美乱大交xxxxx另类电影| 国产一区二区丝袜高跟鞋图片| 精品福利一区二区| 久久在线观看视频| 亚洲精品98久久久久久中文字幕| 日韩av一区在线观看| 欧美高清视频在线观看| 欧美日韩亚洲激情| 国产精品69精品一区二区三区| 亚洲理论在线a中文字幕| 在线播放日韩欧美| 日韩男女性生活视频| 欧美日产国产成人免费图片| 国产精选久久久久久| 岛国精品视频在线播放| 亚洲美女久久久| 一区二区欧美激情| 亚洲aaaaaa| 亚洲精品一区av在线播放| 懂色av一区二区三区| 日韩在线观看电影| 欧美日韩免费在线观看| 欧美一级高清免费播放| 91在线观看免费高清完整版在线观看| 欧日韩在线观看| 亚洲高清久久久久久| 久久偷看各类女兵18女厕嘘嘘| 国产午夜精品免费一区二区三区| 亚洲性69xxxbbb| 亚洲午夜精品久久久久久性色| 日本久久久久亚洲中字幕| 另类美女黄大片| 岛国av一区二区三区| 精品久久中文字幕| 国产精品爽爽ⅴa在线观看| 国产日韩欧美综合| 91精品视频在线看| 91欧美激情另类亚洲| 亚洲成人动漫在线播放| 欧美性xxxxhd| 欧美日韩国内自拍| 色综合亚洲精品激情狠狠|