濮阳杆衣贸易有限公司

主頁 > 知識庫 > centos安裝mysql數(shù)據(jù)庫的方法

centos安裝mysql數(shù)據(jù)庫的方法

熱門標(biāo)簽:電銷機器人自動撥號信息 洛陽外呼增值業(yè)務(wù)線路解決方案 用什么軟件做地圖標(biāo)注 昆明crm外呼系統(tǒng)價格 長沙呼叫中心外呼系統(tǒng)穩(wěn)定嗎 北京地圖標(biāo)注平臺注冊入駐 臨沂語音電話機器人公司 400電話申請安裝 騰沖銷售外呼管理系統(tǒng)服務(wù)

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

2、安裝MySQL數(shù)據(jù)庫服務(wù)器

進入安裝包所在文件夾,執(zhí)行命令 rpm -ivh MySQL-server-5.1.7-0.i386.rpm 安裝MySQL服務(wù)器。

如果報了與原先版本沖突的話,就執(zhí)行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(因為有包依賴,所以要強制刪除)

我的報錯提示如下:

復(fù)制代碼
代碼如下:

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

這時候再執(zhí)行rpm -ivh MySQL-server-5.1.7-0.i386.rpm安裝即可安裝成功。
我這里安裝成功了,但是mysql服務(wù)無法啟動,總是啟動失敗,后來百度了一下,是因為selinux的原因,只要將selinux關(guān)閉就OK了。
關(guān)閉selinux:vi /etc/selinux/config 將SELINUX=enforcing 改成SELINUX=disabled 然后重啟
關(guān)閉selinux之后還是無法啟動mysql服務(wù),因為安裝的mysql所有者是root,在安裝mysql的時候會創(chuàng)建一個用戶mysql,只要將/var/lib/mysql
的所有者改為mysql就OK了,執(zhí)行命令chown -R mysql:mysql /var/lib/mysql
現(xiàn)在執(zhí)行service mysql start終于可以啟動mysql服務(wù)了。

 

3.安裝MySQL客戶端
執(zhí)行命令rpm -ivh MySQL-client-5.1.7-0.i386.rpm進行安裝。

4.安裝成功

成功安裝MySQL后將sql文件導(dǎo)入到數(shù)據(jù)庫,步驟如下:

進入MYSQL Command Line Client
1、先創(chuàng)建數(shù)據(jù)庫:create database test 注:test是創(chuàng)建數(shù)據(jù)庫的名稱
2、再切換到當(dāng)前數(shù)據(jù)庫:use test
3、再輸入:\. /root/test.sql 或 souce /root/test.sql

按照以上步驟就可以將備份的sql腳本導(dǎo)入到linux中的數(shù)據(jù)庫中去。

標(biāo)簽:昌都 汕頭 南充 涼山 通化 濰坊 三亞 遼寧

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《centos安裝mysql數(shù)據(jù)庫的方法》,本文關(guān)鍵詞  centos,安裝,mysql,數(shù)據(jù)庫,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P(guān)信息告之我們,我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《centos安裝mysql數(shù)據(jù)庫的方法》相關(guān)的同類信息!
  • 本頁收集關(guān)于centos安裝mysql數(shù)據(jù)庫的方法的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章
    辰溪县| 搜索| 博湖县| 永宁县| 镇巴县| 东乡族自治县| 普格县| 治县。| 衡南县| 绩溪县| 新宁县| 安溪县| 武强县| 三原县| 松原市| 隆回县| 隆化县| 光山县| 益阳市| 满城县| 辛集市| 天台县| 宿州市| 宁阳县| 普格县| 昭苏县| 潼关县| 连州市| 民权县| 甘孜| 宁夏| 台南市| 海城市| 卓尼县| 达州市| 耒阳市| 鹿泉市| 宜川县| 宣武区| 牡丹江市| 中方县|