建站
咨詢
售后
建站咨詢
新聞中心
隨著現(xiàn)代計(jì)算機(jī)技術(shù)的不斷發(fā)展，數(shù)據(jù)管理系統(tǒng)已經(jīng)成為企業(yè)、組織、甚至家庭必不可少的組成部分。然而，要想高效地利用數(shù)據(jù)，需要正確地為數(shù)據(jù)庫(kù)管理系統(tǒng)（即DBMS）部署軟件。本文將介紹DBMS部署的幾種方式。
1.本地部署
首先是本地部署。本地部署是指將DBMS軟件安裝在本地計(jì)算機(jī)上的部署方式。它極大地節(jié)約了網(wǎng)絡(luò)資源和部署時(shí)間，并且對(duì)安全性和可靠性有極高的要求。而且，如果要在多個(gè)計(jì)算機(jī)上共享數(shù)據(jù)，也需要同步更新，使用本地部署方式就顯得比較困難。
2.遠(yuǎn)程部署
遠(yuǎn)程部署指的是將DBMS軟件安裝在遠(yuǎn)程服務(wù)器上的部署方式。它可以通過(guò)Internet或局域網(wǎng)來(lái)進(jìn)行訪問(wèn)。遠(yuǎn)程部署具有很高的靈活性和可擴(kuò)展性。它可以跨越不同的操作系統(tǒng)和硬件平臺(tái)，并且可以實(shí)現(xiàn)由用戶完全掌控。但是，遠(yuǎn)程部署的缺點(diǎn)是它需要消耗額外的帶寬和服務(wù)器資源，還需要保證網(wǎng)絡(luò)連接的穩(wěn)定性和快速響應(yīng)時(shí)間。
3.云端部署
云端部署指的是將DBMS放在云端，并通過(guò)網(wǎng)絡(luò)連接使用它的部署方式，這是一種新興的部署方式。云端部署最重要的優(yōu)點(diǎn)是靈活性和可擴(kuò)展性。用戶可以使用按需計(jì)算的模式高效地進(jìn)行數(shù)據(jù)處理，而不需要在服務(wù)器硬件和軟件上投入大量資金。另外，云端部署還提供了快速部署軟件、快速調(diào)整運(yùn)行環(huán)境、易于擴(kuò)展等多個(gè)優(yōu)點(diǎn)，而且這些優(yōu)點(diǎn)在數(shù)據(jù)處理方面顯得十分明顯。
DBMS部署方式的選擇取決于眾多的因素，例如企業(yè)組織的尺寸和特點(diǎn)、數(shù)據(jù)庫(kù)大小和發(fā)展方向等等。安裝的位置、成本、可擴(kuò)展性、控制權(quán)和數(shù)據(jù)安全都是需要考慮的產(chǎn)品因素。無(wú)論選擇什么樣的部署方式，都需要考慮到數(shù)據(jù)和軟件的保護(hù)。因此，在實(shí)施DBMS部署之前，請(qǐng)確保您的數(shù)據(jù)和軟件都得到了恰當(dāng)?shù)陌踩Ｗo(hù)，以防止任何可能的安全威脅。
相關(guān)問(wèn)題拓展閱讀：
- 鎬庢牱鍦↙inux鐜?澧冧笅瀹夎?呴儴緗睲ySQL鏁版嵁搴撶郴緇焈鐧懼害鐭ラ亾
鎬庢牱鍦↙inux鐜?澧冧笅瀹夎?呴儴緗睲ySQL鏁版嵁搴撶郴緇焈鐧懼害鐭ラ亾
鍒涘緩鐢ㄤ簬鎵ц?宮ysql鏈嶅姟紼嬪簭鐨勫笎鍙鳳細(xì)
鐢熸垚緋葷粺鏁版嵁搴擄紙鐢熸垚淇℃伅宸茬渷鐣ワ級(jí)錛?
灝唌ysqld鏈嶅姟紼嬪簭娣誨姞鍒板紑鏈鴻?滄枟鍒ゅ惎鍔ㄩ」錛?
# cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 755 /etc/init.d/mysqld
# chkconfig mysqld on
緙栬緫鍚?鍔ㄩ」鐨勯攢閿嬮厤緗?鏂囦歡錛?
# vim /etc/rc.d/init.d/mysqld
//鍒嗗埆淇?鏀圭??46涓?47琛岋紝basedir涓虹▼搴忓畨瑁呰礬寰勶紝datadir涓烘暟鎹?搴撳瓨鏀劇洰褰曘??
basedir=/usr/local/mysql
datadir=/usr/local/mysql/var
閲嶅惎mysqld鏈嶅姟紼嬪簭錛?
# service mysqld start
Starting MySQL. SUCCESS!
鎶妋ysql鏈嶅姟紼嬪簭鍛戒護(hù)鐩?褰曟坊鍔犲埌鐜?澧冨彉閲忎腑錛堟案涔呯敓鏁堬級(jí)錛?
# vim /etc/profile
//鍦ㄩ厤緗?鏂囦歡鐨勬渶鍛婃敼涓嬮潰榪藉姞錛?
export PATH=$PATH:/usr/local/mysql/bin
# source /etc/profile
灝唌ysqld鏈嶅姟紼嬪簭鐨勫簱鏂囦歡閾炬帴鍒伴粯璁ょ殑浣嶇疆錛?
# mkdir /var/lib/mysql
# ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
# ln -s /usr/local/mysql/include/mysql /usr/include/mysql
# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
鍒濆?嬪寲mysqld鏈嶅姟紼嬪簭錛?
# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFUL!
In order to log into MySQL to secure it, we’ll need the current
password for the root user. If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? y
New password: 杈撳叆瑕佷負(fù)root鐢ㄦ埛璁劇疆鐨勬暟鎹?搴撳瘑鐮併??
Re-enter new password: 閲嶅?嶅啀杈撳叆涓?嬈″瘑鐮併??
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit oother. You should remove them before moving into a
production environment.
Remove anonymous users? y錛堝垹闄ゅ尶鍚嶅笎鍙鳳級(jí)
… Success!
Normally, root should only be allowed to connect from ‘localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? y(紱佹??root鐢ㄦ埛浠庤繙紼嬬櫥闄?)
… Success!
By default, MySQL comes with a database named ‘test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? y(鍒犻櫎test鏁版嵁搴撳茍鍙栨秷瀵瑰叾鐨勮?塊棶鏉冮檺)
– Dropping test database…
… Success!
– Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? y(鍒鋒柊鎺堟潈琛?錛岃?╁垵濮嬪寲鍚庣殑璁懼畾绔嬪嵆鐢熸晥)
… Success!
All done! If you’ve completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Cleaning up…
鍙?浠ョ櫨搴︽悳绱?Linux灝辮?ヨ繖涔堝?︼紝絎?9绔? 浣跨敤Apache鏈嶅姟閮ㄧ講闈?rùn)?佺綉绔欙紝閲岄潰鏈夐儴緗瞞ysql鐨勮祫鏂?
銆?銆?濡備綍鍦╨inux涓嬪畨瑁卪ysql鏁版嵁搴撳茍閰嶇疆
鍏充簬鏈?鏂?
銆?銆?鏈?鏂囧皢浠?MySQL 5.0.51涓轟緥錛屼互CentOS 5涓哄鉤鍙幫紝璁茶堪MySQL鏁版嵁搴撶殑瀹夎?呭拰璁劇疆銆?
銆?銆?2. 鍏充簬MySQL
銆?銆?MySQL鏄?鏈?嫻佽?岀殑寮?婧怱QL鏁版嵁搴撶?＄悊緋葷粺錛屽畠鐢盡ySQL AB寮?鍙戙?佸彂甯冨拰鏀?鎸併?侻ySQL AB鏄?涓?瀹剁敱MySQL寮?鍙戜漢鍛樺垱寤虹殑鍟嗕笟鍏?鍙革紝瀹冩槸涓?瀹朵嬌鐢ㄤ簡(jiǎn)涓?縐嶆垚鍔熺殑鍟嗕笟寮婃父妯″紡鏉ョ粨鍚堝紑婧愪環(huán)鍊煎拰鏂規(guī)硶璁虹殑絎?浜屼唬寮?婧愬叕鍙搞?侻ySQL鏄疢ySQL AB鐨勬敞鍐屽晢鏍囥??
銆?銆?MySQL鏄?涓?涓?蹇?閫熺殑銆佸?氱嚎紼嬨?佸?氱敤鎴峰拰鍋ュ．鐨凷QL鏁版嵁搴撴湇鍔″櫒縐熻皚閿?銆侻ySQL鏈嶅姟鍣ㄦ敮鎸佸叧閿?浠誨姟銆侀噸璐熻澆鐢熶駭緋葷粺鐨勪嬌鐢?錛屼篃鍙?浠ュ皢瀹冨祵鍏ュ埌涓?涓?澶ч厤緗?(mass-deployed)鐨勮蔣浠朵腑鍘匯??
銆?銆?MySQL鐨勫畼鏂瑰彂闊蟲(chóng)槸鈥淢y Ess Que Ell鈥濓紝鑰屼笉鏄?鈥淢y sequel鈥濄?備絾鏄?浣犱篃鍙?浠ヤ嬌鐢ㄢ?淢y sequel鈥濆拰鍏朵粬鐨勬柟璦?銆?
銆?銆?MySQL緗戠珯(
)鎻愪緵浜?jiǎn)鍏充簬MySQL鍜孧ySQL AB鐨勬渶鏂扮殑娑堟伅銆?
銆?銆?MySQL鍏鋒湁濡備笅鐗圭偣鎴栫壒鎬э細(xì)
銆?銆?MySQL鏄?涓?涓?鏁版嵁搴撶?＄悊緋葷粺錛?
銆?銆?MySQL鏄?涓?涓?鍏崇郴鏁版嵁搴撶?＄悊緋葷粺錛?
銆?銆?MySQL鏄?寮?婧愮殑錛?
銆?銆?MySQL鏈嶅姟鍣ㄦ槸涓?涓?蹇?鐨勩?佸彲闈犵殑鏅屾帢鍜屾槗浜庝嬌鐢ㄧ殑鏁版嵁搴撴湇鍔″櫒錛?
銆?銆?MySQL鏈嶅姟鍣ㄥ伐浣滃湪瀹㈡埛/鏈嶅姟鍣ㄦ垨宓屽叆緋葷粺涓?錛?
銆?銆?鏈夊ぇ閲忕殑MySQL杞?浠跺彲浠ヤ嬌鐢ㄣ??
銆?銆?3. MySQL鐨勫畨瑁?
銆?銆?MySQL鏈変袱縐嶅畨瑁呮柟寮忥細(xì)婧愮爜鍖呭畨瑁呭拰浜岃繘鍒跺寘瀹夎?呫?傝繖涓ょ?嶆柟寮忓悇鏈夌壒鑹詫細(xì)浜屼綅鍒跺寘瀹夎?呬笉闇?緙栬瘧錛岄拡瀵逛笉鍚岀殑騫沖彴鏈夌粡榪囦紭鍖栫紪璇戠殑涓嶅悓鐨勪簩榪涘埗鏂囦歡浠ュ強(qiáng)鍖呮牸寮忥紝瀹夎?呯畝鍗曟柟渚匡紱婧愮爜鍖呭垯蹇呴』鍏堥厤緗?緙栬瘧鍐嶅畨瑁咃紝鍙?浠ユ牴鎹?浣犳墍鐢ㄧ殑涓繪満鐜?澧冭繘琛屼紭鍖栵紝閫夋嫨鏈?浣崇殑閰嶇疆鍊鹼紝瀹夎?呭畾鍒舵洿鐏墊椿銆備笅闈㈠垎鍒?浠嬬粛榪欎袱縐嶅畨瑁呮柟寮忋??
銆?銆?3.1 婧愮爜鍖呮柟寮忓畨瑁?
銆?銆?3.1.1 鍦╨inux緋葷粺涓?娣誨姞榪愯?孧ysql鐨勭敤鎴峰拰緇?
銆?銆?/usr/in/groupadd mysql
銆?銆?/usr/in/useradd -d /var/lib/mysql -s /in/nologin -g mysql mysql
銆?銆?3.1.2 涓嬭澆鏈?鏂扮ǔ瀹氬彂琛岀増(GA)鐨凪ySQL杞?浠?
銆?銆?璁塊棶MySQL緗戠珯
涓嬭澆鏈?鏂扮ǔ瀹氬彂琛岀増鐨凪ySQL婧愮爜鍖呫?傛湰鏂囦嬌鐢ㄧ殑鏄?5.0.51鐗堟湰錛屽湪linux緋葷粺涓嬬敤涓嬮潰鐨勫懡浠や笅杞斤細(xì)
銆?銆?wget
銆?銆?3.1.3 瑙ｅ帇緙╀笅杞界殑婧愮爜鍖?
銆?銆?棣栧厛寤虹珛涓?涓?宸ヤ綔鐩?褰?( 絎旇?呭緩璁?鐨勭洰褰曚負(fù)/usr/local/src/mysql ) 錛?
銆?銆?mkdir -p /usr/local/src/mysql
銆?銆?灝嗕笅杞界殑婧愮爜鍖呯Щ鑷沖伐浣滅洰褰曪細(xì)
銆?銆?mv mysql-5.0.51.tar.gz /usr/local/src/mysql
銆?銆?榪涘叆宸ヤ綔鐩?褰曞茍鐢╰ar鍛戒護(hù)瑙ｅ帇婧愮爜鍖咃細(xì)
銆?銆?cd /usr/local/src/mysql
銆?銆?tar zxvf mysql-5.0.51.tar.gz
銆?銆?鍛戒護(hù)鎵ц?岀粨鏉熷悗錛屽綋鍓嶅伐浣滅洰褰曚笅灝嗙敓鎴愪竴涓?鏂扮殑瀛愮洰褰昺ysql-5.0.51錛屾?ょ洰褰曚笅鍗充負(fù)mysql鐨勬簮鐮佹枃浠躲??
銆?銆?3.1.4 閰嶇疆Makefile鏂囦歡
銆?銆?榪涘叆MySQL婧愮爜鐩?褰曪細(xì)
銆?銆?cd mysql-5.0.51
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)鍙?鏌ョ湅鍙?閰嶇疆閫夐」錛?
銆?銆?./configure –help
銆?銆?鏈?鏂囦嬌鐢ㄧ殑閰嶇疆鍛戒護(hù)鏍煎紡濡備笅錛?
銆?銆?CC=gcc CFLAGS=”-O3″ CXX=gcc CXXFLAGS=”-O3 -felide-constructors -fno-exceptions -fno-rtti” ./configure –prefix=/usr/local/mysql –enable-thread-safe-client –enable-assembler –with-big-tables –with-client-ldflags=-all-static –with-mysqld-ldflags=-all-static –with-charset=utf8 –with-collation=utf8_general_ci –with-extra-charsets=complex
銆?銆?閰嶇疆閫夐」璇存槑錛?
銆?銆?CC錛欳緙栬瘧鍣ㄧ殑鍚嶇О錛堢敤浜庤繍琛宑onfigure錛夛紝鏈?鏂囩ず渚嬩負(fù)gcc
銆?銆?CFLAGS錛欳緙栬瘧鍣ㄧ殑鏍囧織錛堢敤浜庤繍琛宑onfigure錛夛紝鏈?鏂囩ず渚嬩負(fù)-O3錛屾寚瀹氫紭鍖栫駭鍒?涓?3
銆?銆?CXX錛欳++緙栬瘧鍣ㄧ殑鍚嶇О錛堢敤浜庤繍琛宑onfigure錛夛紝鏈?鏂囩ず渚嬩負(fù)gcc
銆?銆?CXXFLAGS錛欳++緙栬瘧鍣ㄧ殑鏍囧織錛堢敤浜庤繍琛宑onfigure錛?
銆?銆?–prefix錛氭寚瀹氬畨瑁呯洰褰曪紝鏈?鏂囩ず渚嬩負(fù)/usr/local/mysql
銆?銆?–localstatedir錛氭寚瀹氶粯璁ゆ暟鎹?搴撴枃浠朵繚瀛樼洰褰曪紝榛樿?や負(fù)瀹夎?呯洰褰曚笅鐨剉ar鐩?褰?
銆?銆?–enable-thread-safe-client錛氱紪璇戠嚎紼嬪畨鍏ㄧ増鐨凪ySQL瀹㈡埛绔?搴?
銆?銆?–enable-assembler錛氫嬌鐢ㄤ竴浜涘瓧絎﹀嚱鏁扮殑姹囩紪鐗堟湰
銆?銆?–with-client-ldflags錛氬?㈡埛绔?閾炬帴鍙傛暟錛屾湰鏂囩ず渚嬩負(fù)鎸囧畾闈?rùn)?佺紪璇憁ysql瀹㈡埛绔?
銆?銆?–with-mysqld-ldflags錛氭湇鍔″櫒绔?閾炬帴鍙傛暟錛屾湰鏂囩ず渚嬩負(fù)鎸囧畾闈?rùn)?佺紪璇憁ysql鏈嶅姟鍣?
銆?銆?–with-big-tables錛氬湪32浣嶅鉤鍙頒笂鏀?鎸佸ぇ浜?4G琛岀殑琛?
銆?銆?–with-charset錛氭寚瀹氶粯璁ゅ瓧絎﹂泦銆俶ysql榛樿?や嬌鐢╨atin1(cp1252)瀛楃?﹂泦錛屽彲浠ヤ嬌鐢ㄦ?ら?夐」鏇存敼銆傚瓧絎﹂泦鍙?浠ユ槸big5銆乧p1251銆乧p1257銆乧zech銆乨anish銆乨ec8銆乨os銆乪uc_kr銆乬b2312銆乬bk銆乬erman1銆乭ebrew銆乭p8銆乭ungarian銆乲oi8_ru銆乲oi8_ukr銆乴atin1銆乴atin2銆乻jis銆乻we7銆乼is620銆乽jis銆乽sa7鎴杦in1251ukr銆?
銆?銆?–with-collation錛氭寚瀹氶粯璁ゆ牎瀵硅?勫垯銆俶ysql榛樿?や嬌鐢╨atin1_swedish_ci鏍″?硅?勫垯錛屽彲浠ヤ嬌鐢ㄦ?ら?夐」鏇存敼銆?
銆?銆?–with-extra-charsets錛氭湇鍔″櫒闇?瑕佹敮鎸佺殑瀛楃?﹂泦錛屾湁涓夌?嶅彲鑳界殑鍊鹼細(xì)絀烘牸闂撮殧鐨勪竴緋誨垪瀛楃?﹂泦鍚嶏紱complex 錛屽寘鎷?涓嶈兘鍔ㄦ?佽?呰澆鐨勬墍鏈夊瓧絎﹂泦錛沘ll錛屽皢鎵?鏈夊瓧絎﹂泦鍖呮嫭榪涗簩榪涘埗銆傛湰鏂囩ず渚嬩負(fù)complex銆?
銆?銆?娉ㄦ剰錛氳?佹兂鏇存敼瀛楃?﹂泦鍜屾牎瀵硅?勫垯錛岃?佸悓鏃朵嬌鐢?–with-charset鍜?–with-collation閫夐」銆? 鏍″?硅?勫垯蹇呴』鏄?瀛楃?﹂泦鐨勫悎娉曟牎瀵硅?勫垯銆?(鍦╩ysql涓?浣跨敤SHOW COLLATION璇?鍙ユ潵紜?瀹氭瘡涓?瀛楃?﹂泦浣跨敤鍝?涓?鏍″?硅?勫垯)銆?
銆?銆?3.1.5 緙栬瘧婧愪唬鐮?
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)緙栬瘧婧愪唬鐮侊細(xì)
銆?銆?make
銆?銆?3.1.6 瀹夎??
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)瀹夎?卪ysql鍒扮洰鏍囪礬寰勶細(xì)
銆?銆?make install
銆?銆?3.1.7 澶嶅埗榛樿?ゅ叏灞?鍚?鍔ㄥ弬鏁伴厤緗?鏂囦歡鍒?/etc鐩?褰?
銆?銆?婧愮爜鏂瑰紡瀹夎?呴渶瑕佹墜鍔ㄥ?嶅埗閰嶇疆鏂囦歡錛岄厤緗?妯℃澘浣嶄簬婧愮爜鏍?wèi)鐨剆upport-files鐩?褰曪紝鏈塵y-all.cnf銆乵y-medium.cnf銆乵y-large.cnf銆乵y-huge.cnf鍥涗釜錛岄?夋嫨璺熶綘鐨勭幆澧冪浉鎺ヨ繎鐨勪竴涓?澶嶅埗鍒?/etc鐩?褰曪紝騫跺仛閫傚綋淇?鏀廣?傚叧浜巑ysql閰嶇疆鏂囦歡鐨勮?︾粏淇℃伅璇峰弬闃呯瑪鑰呯殑鍏跺畠鏂囩珷鎴栨槸mysql瀹樻柟鏂囨。銆?
銆?銆?鏈?鏂囩ず渚嬮?夋嫨my-medium.cnf錛屾墽琛屼笅闈㈢殑鍛戒護(hù)灝嗗叾澶嶅埗鍒?/etc鐩?褰曪細(xì)
銆?銆?cp ./support-files/my-medium.cnf /etc/my.cnf
銆?銆?3.1.8 鍒濆?嬪寲鎺堟潈琛?
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)鍒濆?嬪寲鎺堟潈琛?錛?
銆?銆?./scripts/mysql_install_db –user=mysql
銆?銆?3.1.9 鏇存敼mysql鏁版嵁鐩?褰曞睘涓誨拰鏉冮檺
銆?銆?榛樿?ゆ暟鎹?搴撴枃浠朵繚瀛樼洰褰曚負(fù)瀹夎?呯洰褰曚笅鐨剉ar鐩?褰曪紝鎵ц?宑onfigure鍛戒護(hù)鏃跺彲閫氳繃–localstatedir鍙傛暟鎸囧畾涓嶅悓鐨勭洰褰曪紝鏈?鏂囩ず渚嬩負(fù)榛樿?や綅緗?銆?
銆?銆?chown -R mysql.mysql /usr/local/mysql/var
銆?銆?chmod -R 700 /usr/local/mysql/var
銆?銆?3.1.10 璁劇疆寮?鏈鴻嚜鍚?鍔ㄦ湇鍔℃帶鍒惰剼鏈?
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)澶嶅埗鍚?鍔ㄨ剼鏈?鍒拌祫婧愮洰褰曪細(xì)
銆?銆?cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)澧炲姞mysqld鏈嶅姟鎺у埗鑴氭湰鎵ц?屾潈闄愶細(xì)
銆?銆?chmod +x /etc/rc.d/init.d/mysqld
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)灝唌ysqld鏈嶅姟鍔犲叆鍒扮郴緇熸湇鍔細(xì)
銆?銆?chkconfig –add mysqld
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)媯?鏌?mysqld鏈嶅姟鏄?鍚﹀凡緇忕敓鏁堬細(xì)
銆?銆?chkconfig –list mysqld
銆?銆?鍛戒護(hù)杈撳嚭綾諱技涓嬮潰鐨勭粨鏋滐細(xì)
銆?銆?mysqld:off 1:off 2:on 3:on 4:on 5:on 6:off
銆?銆?琛ㄦ槑mysqld鏈嶅姟宸茬粡鐢熸晥錛屽湪2銆?3銆?4銆?5榪愯?岀駭鍒?闅忕郴緇熷惎鍔ㄨ?岃嚜鍔ㄥ惎鍔?錛屼互鍚庡彲浠ヤ嬌鐢╯ervice鍛戒護(hù)鎺у埗mysql鐨勫惎鍔ㄥ拰鍋滄??銆?
銆?銆?鍚?鍔╩ysqld鏈嶅姟錛?
銆?銆?service mysqld start
銆?銆?鍋滄??mysqld鏈嶅姟錛?
銆?銆?service mysqld stop
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)鍏抽棴寮?鏈鴻嚜鍚?鍔?錛?
銆?銆?chkconfig mysqld off
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)鍙?浠ユ敼鍙樺紑鏈鴻嚜鍚?鍔ㄧ殑榪愯?岀駭鍒?涓?3銆?5錛?
銆?銆?chkconfig –level 35 mysqld on
銆?銆?3.1.11 灝唌ysql鐨刡in鐩?褰曞姞鍏?PATH鐜?澧冨彉閲?
銆?銆?緙栬緫/etc/profile鏂囦歡錛?
銆?銆?vi /etc/profile
銆?銆?鍦ㄦ枃浠舵渶鍚庢坊鍔犲?備笅涓よ?岋細(xì)
銆?銆?PATH=$PATH:/usr/local/mysql/bin
銆?銆?export PATH
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)浣挎墍鍋氱殑鏇存敼鐢熸晥錛?
銆?銆?. /etc/profile
銆?銆?3.2 浜岃繘鍒跺寘鏂瑰紡瀹夎??
銆?銆?3.2.1 浠庡畨瑁呭獟浣撳畨瑁?
銆?銆?Mysql浜岃繘鍒跺寘宸茬粡鍖呭惈鍦–entOS 5鐨勫畨瑁呭獟浣撲腑錛屽彲浠ョ洿鎺ヤ粠瀹夎?呭獟浣撲腑瀹夎?呬笅闈?涓変釜rpm鍖咃細(xì)
銆?銆?mysql-5.0.22-2.1.0.1.i386.rpm
銆?銆?mysql-devel-5.0.22-2.1.0.1.i386.rpm
銆?銆?mysql-server-5.0.22-2.1.0.1.i386.rpm
銆?銆?涓嶅悓鐨勭増鏈?鏂囦歡鍚嶆湁鎵?涓嶅悓錛岃?鋒敞鎰忓尯鍒嗐??
銆?銆?鎵ц?屼笅闈㈢殑鍛戒護(hù)瀹夎?咃細(xì)
銆?銆?rpm -iUvh mysql-5.0.22-2.1.0.1.i386.rpm
銆?銆?rpm -iUvh mysql-devel-5.0.22-2.1.0.1.i386.rpm
銆?銆?rpm -iUvh mysql-server-5.0.22-2.1.0.1.i386.rpm
銆?銆?3.2.2 閫氳繃yum瀹夎??
銆?銆?濡傛灉浣犲畨瑁呯殑鏈哄櫒姝ゆ椂鍙?浠ヨ繛鎺ュ埌浜掕仈緗戯紝絎旇?呭緩璁?浣跨敤yum鍛戒護(hù)鏉ョ畝鍖栧畨瑁呰繃紼嬶細(xì)
銆?銆?yum install mysql-server mysql-devel mysql
銆?銆?yum灝嗚嚜鍔ㄤ粠centos鐨勯暅鍍忕珯鐐規(guī)煡鎵句綘鎸囨槑鐨勮蔣浠剁殑鏈?鏂頒簩榪涘埗鍖咃紝騫舵??鏌ヨ蔣浠跺寘渚濊禆鍏崇郴錛屽畨瑁呰蔣浠剁殑鍚屾椂鑷?鍔ㄥ畨瑁呭叾渚濊禆鐨勮蔣浠跺寘銆?
數(shù)據(jù)庫(kù)部署的方式包含的介紹就聊到這里吧，感謝你花時(shí)間閱讀本站內(nèi)容，更多關(guān)于數(shù)據(jù)庫(kù)部署的方式包含,數(shù)據(jù)庫(kù)管理系統(tǒng)的部署方式,鎬庢牱鍦↙inux鐜?澧冧笅瀹夎?呴儴緗睲ySQL鏁版嵁搴撶郴緇焈鐧懼害鐭ラ亾的信息別忘了在本站進(jìn)行查找喔。
創(chuàng)新互聯(lián)網(wǎng)絡(luò)推廣網(wǎng)站建設(shè)，網(wǎng)站設(shè)計(jì)，網(wǎng)站建設(shè)公司，網(wǎng)站制作，網(wǎng)頁(yè)設(shè)計(jì)，1500元定制網(wǎng)站優(yōu)化全包，先排名后付費(fèi)，已為上千家服務(wù)，聯(lián)系電話：13518219792
新聞名稱：數(shù)據(jù)庫(kù)管理系統(tǒng)的部署方式(數(shù)據(jù)庫(kù)部署的方式包含)
網(wǎng)站鏈接：http://www.dlmjj.cn/article/coiiogp.html
