Maitiro ekuisa MariaDB paWindows?

Maitiro ekuisa MariaDB paWindows?

Munyika yehurongwa uye dhatabhesi manejimendi, MariaDB yava sarudzo iri kuramba ichizivikanwa. Nekuenderana kwayo neMySQL uye kutarisa kwayo pakusimba uye kuita, iyi yakavhurika sosi imwe nzira yakakurumidza kuwana traction. Kana iwe uri kufunga kushandisa MariaDB kune yako Windows mapurojekiti, iwe uri munzvimbo chaiyo. Muchikamu chino, ini ndinokutungamira nhanho nhanho kuburikidza nemaitiro ekuisa MariaDB pa sisitimu yako yekushandisa Mahwindo.

Nhanho 1: Dhawunirodha iyo MariaDB simisi
Nhanho yekutanga yekuisa MariaDB paWindows ndeye download iyo installer zvinoenderana neshanduro yako yeWindows kubva kune yepamutemo MariaDB saiti. Ita shuwa kuti wasarudza iyo chaiyo vhezheni inoenderana neyako sisitimu yekushandisa, kana zviri 32 kana 64 bits.

Danho rechipiri: Mhanyai mugadziri
Paunenge watora iyo MariaDB installer, imhanye nekudzvanya kaviri pane faira ratorwa. Izvi zvichavhura wizard yekuisa iyo inokutungamira iwe kuburikidza nekuisa maitiro.

Danho rechitatu: Sarudza zvikamu uye zvigadziriso
Panguva ino, wizard yekuisa inokubvumira sarudza zvikamu iyo yaunoda kuisa pamwe chete neMariaDB, senge masevhisi evatengi, zvinobatanidza, uye zvinoshandiswa. Pamusoro pezvo, iwe unogona zvakare kugadzirisa sarudzo dzekuisa, senge yekumisikidza folda nzvimbo uye zita remuenzaniso.

Danho 4: Gadzirisa sarudzo dzemushandisi
Tevere, uchafanira gadzirisa sarudzo dzemushandisi kuseta iyo MariaDB midzi mushandisi password. Ita shuwa kuti unosarudza yakasimba uye yakachengeteka password kuchengetedza yako dhatabhesi.

Nematanho akareruka aya,⁤ unogona isa MariaDB pane yako Windows system yekushandisa uye tanga kutora mukana wemabhenefiti ayo maererano nekuita, scalability ⁢uye kuenderana neMySQL. Usazeze kuongorora zviri pamutemo MariaDB zvinyorwa zvakare kuti udzidze nezve ese maficha uye mashandiro ayo papuratifomu iyi inopa. Rombo rakanaka!

1. System zvinodiwa kuti uise MariaDB⁣ paWindows

Kuti uise MariaDB paWindows, unofanirwa kuzadzisa zvinotevera system zvinodiwa:

– Sisitimu yekushandisa: MariaDB inoenderana neakasiyana mavhezheni eWindows, kusanganisira Windows 10, Windows Server 2019 uye Windows Server 2016. Zvakakosha kuve nechokwadi kuti une shanduro inoenderana yehurongwa hwekushanda usati waenderera mberi nekuisa.

– Nzvimbo yekuchengetera zvinhu: Ita shuwa kuti une nzvimbo yekuchengetera yakakwana inowanikwa pakombuta yako. dhiraivha yakaoma yekuisa MariaDB. Pamusoro pezvo, zvinokurudzirwa kuve nekuwedzera nzvimbo yekukura kwedatabase mune ramangwana.

– RAM Yekurangarira: Zvinokurudzirwa kuve neinenge 4 GB ye RAM kuitira yakakwana MariaDB kuita. Nekudaro, huwandu hwendangariro hunodiwa hunogona kusiyana zvichienderana nehukuru uye basa redhatabhesi.

Pamusoro pezvinodikanwa zvehurongwa uhu, zvakakosha kuti utarise zvimwe zvakaita sevhezheni yeMariaDB yaunoda kuisa uye kodzero dzemaneja dzinodiwa pakuiswa. Kana izvi zvinodikanwa zvazadzikiswa, unogona kuenderera mberi nekuiswa kweMariaDB paWindows uye wotanga kunakidzwa nekuita kwayo kwakawanda uye zvakanakira mukutarisira dhatabhesi.

2. Dhaunirodha yazvino yakatsiga vhezheni ye⁢ MariaDB yeWindows

Zve dhawunirodha yazvino yakagadzikana vhezheni yeMariaDB yeWindows, Tevedzera matanho aya ari nyore:

1. Tsvaga webhusaiti MariaDB mukuru pa https://mariadb.org/.

2. Enda⁢ kuchikamu chekudhawunirodha uye sarudza Windows vhezheni.

Kana wapedza kudhaunirodha, Tevedza nhanho idzi kuisa MariaDB pane yako Sisitimu yeWindows:

1. Tinya kaviri faira rekuisa rakadhawunirodha kuti utange kugadzwa.

2. Wizard yekuisa ichavhura. Sarudza mutauro waunoda uye tinya "Next".

3. Gamuchira mazwi erezinesi uye tinya "Next."

Pakupedzisira, gadzirisa yako MariaDB yekuisa paWindows sezvinotevera:

1. Sarudza zvaunoda kuisa sarudzo, senge nzvimbo yekuisa uye zvimwe zvikamu.

2. Isa password yakasimba yeMariaDB administrator account.

3. Pedzisa wizard yekuisa uye mirira kuti maitiro apedze.

Iye zvino unenge uine yazvino yakagadzikana vhezheni yeMariaDB yakaiswa pane yako Windows system uye unogona kutanga kushandisa iyi ine simba dhatabhesi manejimendi system!

3. MariaDB yekuisa maitiro paWindows

MariaDB ndeye yakavhurika sosi dhatabhesi manejimendi system uye forogo yeMySQL. Kuisa MariaDB paWindows inzira yakapusa uye inokurumidza iyo inogona kupedzwa nekutevera mashoma akakosha matanho. Heano maitiro ekuisa MariaDB paWindows.

Danho 1: Dhawunirodha MariaDB: Chinhu chekutanga chaunofanirwa kuita kurodha yazvino yakagadzikana vhezheni yeMariaDB kubva kune yepamutemo webhusaiti. Iva nechokwadi chekusarudza shanduro inoenderana neWindows operating system yako. Kana yangodhaunirodwa, iyo yekuisa faira ichave yakagadzirira kushandiswa.

Nhanho 2: Mhanya iyo installer: Mushure mekunge wadhawunirodha iyo MariaDB yekuisa faira, tinya kaviri kuti uimhanye. Iwindo rekuisa rinovhurika nekukutungamira kuburikidza nekuita. Iva nechokwadi chekuverenga nekugamuchira mazwi erezinesi usati waenderera.

Danho rechitatu: Gadzirisa kuiswa: Panguva yekugadzika maitiro, iwe uchakumbirwa kuti usarudze sarudzo dzekugadzirisa zvichienderana nezvaunoda. Unogona kusarudza mutauro wekugadza, nzvimbo yefaira, uye sarudzo dzekutanga sevha, pakati pemamwe marongero. Iva nechokwadi chekunyatsoongorora sarudzo dzese usati waenderera. Kana uchinge wagadzirisa zvese zvingasarudzwa, tinya ⁣»Isa» kuti utange maitiro ekuisa.

4. ⁢Kugadziriswa kwekutanga kweMariaDB paWindows

Kugadzirisa MariaDB paWindows

Kana uchinge waisa MariaDB pane yako Windows system yekushandisa, zvakakosha kuti uite gadziriro yekutanga kuve nechokwadi chekuti dhatabhesi iri kushanda nemazvo. Muchikamu chino, ini ndichakutungamirira kuburikidza nematanho akasiyana aunoda kutevedzera kugadzirisa⁤ MariaDB paWindows.

Chekutanga pane zvese, iwe unofanirwa kuvhura hwindo remutsara wemirairo semutungamiri. Kuti uite izvi, tinya-kurudyi menyu yekutanga uye sarudza "Command Prompt (Admin)" kubva pane yekudonha-pasi runyorwa. Izvi zvinokutendera kuti uite shanduko⁤ kune MariaDB kumisikidzwa.

Nhanho inotevera ndeyekugadzirisa iyo my.ini configuration file iri muMariaDB yekuisa folda. Unogona kuwana iyi faira munzira C: Chirongwa MafairaMariaDB ⁣10.6data. Vhura iyo faira uchishandisa text editor uye tsvaga iyo [mysqld] chikamu. Apa ndipo paunogona kuita shanduko kune ⁢MariaDB kumisikidzwa. Mamwe eakanyanya kukosha paramita yekufunga nezvayo ndeyekumisikidzwa kwechiteshi, saizi yakakura yepakiti, uye gadziriso yeinjini. Iva nechokwadi chekuchengetedza shanduko dzako kana wapedza.

Kuita izvi kwakakosha kuve nechokwadi chekushanda kwakakwana kwe database. Tevera matanho ataurwa pamusoro apa kuti uvhure hwindo rekuraira-mutsara semutungamiri uye gadzirisa my.ini configuration file. Rangarira kuchengetedza shanduko kana yaitwa. Kugadzirisa kwakakodzera kunogona kuvandudza mashandiro uye kuchengetedzeka kweMariaDB dhatabhesi paWindows. Kana wapedza nhanho idzi, unenge wakagadzirira kushanda naMariaDB pane yako Windows inoshanda system.

5. Kuwana MariaDB command line interface paWindows

Iye chikamu chakakosha chekushanda neiyi dhatabhesi ine simba. Kuburikidza nemutsara wekuraira, vashandisi vanogona kuita mirairo uye mibvunzo zvakananga mudhatabhesi. Izvi ⁢zvinopa kutonga kukuru uye kuchinjika mukutarisira data.

Kuti uwane iyo MariaDB yekuraira-mutsara interface paWindows, unofanira kutanga wavhura hwindo rekuraira. Unogona kuita izvi nekudzvanya Windows kiyi + R wobva wanyora "cmd." Kana hwindo rekuraira richinge ravhurwa, iwe unofanirwa kupinda dhairekitori iyo MariaDB yakaiswa. Kazhinji, iyi ndiyo C: Program FilesMariaDBMariaDB< version>bin, kuita shuwa yekutsiva < vhezheni > ‍ neiyo chaiyo vhezheni yawakaisa.

Paunenge uchinge uri mudhairekitori chairo, unogona kushandisa iyo "mysql" kuraira kuvhura iyo MariaDB yekuraira mutsara interface. Izvi zvinokuendesa kuMariaDB kukurumidza, kwaunogona kuisa mirairo yako uye mibvunzo. Kana iwe uchida kuwana imwe dhatabhesi, unogona kushandisa "shandisa <zita rezita>" kuraira kuti usarudze. Kubva ipapo, unogona kuita zvakasiyana-siyana zvekushanda, zvakadai sekugadzira matafura, kuisa data, uye kushandisa mibvunzo yakaoma. ⁢Yeuka kuti zvakakosha kuve neruzivo rwekutanga rwemirairo yeMariaDB yekushanda zvinobudirira mune yekuraira mutsara interface.

6. Kugadzira uye kugadzirisa dhatabhesi muMariaDB yeWindows

Mune ino post, isu tinokuratidza iwe sei isa MariaDB paWindows uye maitiro ekugadzira nekugadzirisa dhatabhesi papuratifomu ino. MariaDB ndeye yakavhurika sosi yehukama dhatabhesi manejimendi system yave yakakurumbira imwe nzira kune MySQL. Vazhinji vanogadzira uye manejimendi edhatabhesi⁤ vanosarudza kushandisa MariaDB nekuda kwekuita kwayo, scalability, uye kuchengetedzwa kwekuvandudzwa.

Kutanga dhawunirodha yakakodzera vhezheni yeMariaDB yeWindows kubva pawebhusaiti yayo yepamutemo. Ita shuwa kuti wasarudza iyo vhezheni inoenderana neyako yekushandisa system. Kana iyo yekuisa faira yadhaunirodha, tinya kaviri kuti utange kuita basa.Tevedza mirairo yepa-screen kuti upedze kuisa.

Kana wangoisa MariaDB pane yako system, yave nguva yeku gadzira uye maneja dhatabhesi. Unogona kushandisa mutsara wekuraira, graphical mushandisi interface, kana maturusi ekutonga senge phpMyAdmin. ‍ Kuti uwane iyo MariaDB ⁤command line, vhura hwindo rekuraira uye nyora. mariadb ichiteverwa na -u tu_usuario -p kuti upinde neako username nepassword. Kubva pano, unogona kumhanya SQL mirairo yekugadzira uye kugadzirisa yako dhatabhesi.

7. Kugadzirisa kodzero dzevashandisi muMariaDB yeWindows

Kana uchinge waisa MariaDB pane yako Windows system, zvakakosha kuti ugadzirise akakodzera emushandisi ropafadzo kuve nechokwadi chekuchengetedza uye kuwana kwakaringana kudhatabhesi. Neraki, MariaDB inopa seti yezvishandiso zvekugadzirisa ropafadzo dzevashandisi zvinobudirira.

Kuti utange, unofanirwa kuvhura iyo MariaDB yekuraira-mutsara interface nekumhanyisa rairo mysql kubva kucommand prompt. Izvi zvinokutendera iwe kuti uwane iyo MariaDB manejimendi console. Kana uchinge wapinda, unogona kutanga kutonga maruramiro evashandisi uchishandisa mirairo chaiyo.

Imwe yematanho ekutanga kugadzira mushandisi mutsva ane kodzero dzakakodzera. Kuti uite izvi, unogona kushandisa murairo GADZA MUSHANDISI. Semuenzaniso, kana iwe uchida kugadzira mushandisi anonzi "user1" nepassword "password1", unogona kumhanya unotevera kuraira:
«`
GADZIRA MUNHU 'user1' @ 'localhost' AKAZIVA NE 'password1';
«`
Zvadaro, iwe unofanirwa kugovera ropafadzo dzinodiwa kumushandisi achangogadzirwa. Unogona kuzviita uchishandisa murairo GURA. Semuenzaniso, kana iwe uchida kupa "user1" maropafadzo ese ekuwana dhatabhesi inonzi "database1", unogona kumhanya unotevera kuraira:
«`
IPA MABHARADZO ESE PANZVIMBO1.* KUTI 'mushandisi1' @'localhost';
«`
Rangarira kuti iwe unofanirwa kugadzirisa maropafadzo kuti shanduko dziite uchishandisa murairo FLUSH⁣ PRIVILEGES. Neizvi, wakabudirira kugadzirisa ropafadzo dzemushandisi muMariaDB yeWindows, izvo zvinokutendera kuti utore uye kudzora kupinda kune database. zvakachengeteka.

8. Kugadzirisa zvinowanzoitika panguva yekuiswa kwaMariaDB paWindows

Kana wafunga kuisa MariaDB paWindows operating system yako, unogona kusangana nematambudziko anowanikwa panguva yekuisa.Sezvineiwo, mazhinji ematambudziko aya ane nyore uye nekukurumidza mhinduro. Pazasi, tinokupa mamwe magadzirirwo akajairika kuti akubatsire kugadzirisa zvimhingamipinyi zvinowanzoitika.

1. Dependence kukanganisa: ⁤ Meseji yekukanganisa inogona kuoneka panguva yekuisa inoratidza kuti zvimwe zvinotsamira hazvipo. Kuti ugadzirise nyaya iyi, iva nechokwadi chokuti une software inodiwa yakaiswa, yakadai seVisual C ++ Redistributable Package uye NET Framework. Kana izvo zvinodiwa zvisina kuisirwa, dhawunirodha uye uzviise usati waedza kuisa MariaDB zvakare.

2. Dambudziko reFirewall: Kana firewall yako ichivharira kuisirwa kweMariaDB, zvakakosha kuidzima kwenguva pfupi panguva yekuisa. Iwe unogona kuita izvi nekuenda kuWindows firewall marongero uye kusarudza sarudzo yekudzima. Kana iyo yekumisikidza yapedza zvinobudirira, yeuka kumisa firewall zvakare kuchengetedza chengetedzo yehurongwa hwako.

9. Kuvandudza MariaDB paWindows: Maitiro Akanakisisa uye Kungwarira Kutora

Imwe yemabhenefiti makuru eMariaDB kugona kwayo kuvandudzwa mukati masisitimu ekushanda Windows zviri nyore uye zvakachengeteka. Zvakadaro, zvakakosha kurangarira mamwe⁤ maitiro akanakisa uye matanho akakosha ekudzivirira usati waita nhanho yekuvandudza. Aya matanho anovimbisa kutendeseka kweiyo data uye nekushanda chaiko kwesevha yedatabase.

1. Ita a kuchengetedza zvakazara: Usati waenderera mberi nekusimudzira kweMariaDB, zvinokurudzirwa kuti utore backup yakazara yeese database uye mafaera ane hukama. Izvi zvakakosha kuchengetedza ruzivo kana chimwe chikakanganisika panguva yekuita.⁣ Unogona kushandisa maturusi ekuchengetedza senge mysqldump kana yechitatu-bato backup mhinduro kuti upedze basa. Ita shuwa kuti backup yakachengetwa munzvimbo yakachengeteka uye inowanikwa kana iwe uchida kuidzosera.

2. Simbisa zvinodiwa zvishoma zvesystem: Usati watanga kusimudzira, ita shuwa kuti system yako inosangana neiyo shoma hardware uye software zvinodiwa kutsigira yazvino vhezheni yeMariaDB. Izvi zvinogona kusanganisira vhezheni yekushandisa sisitimu, huwandu⁤ hwe RAM, inowanikwa disk nzvimbo, pakati pezvimwe. Ona zvinyorwa zveMariaDB zvepamutemo kuti uwane ruzivo⁤ nezve zvinodikanwa zveshanduro yauri kuvandudza.

3. Dzima masevhisi uye vhara sevha: Usati watanga kusimudzira, unofanirwa kudzima masevhisi ese ane chekuita naMariaDB uye ona kuti sevha yakadzimwa. Izvi zvinodzivirira kupokana kana kukanganisa panguva yekuvandudza maitiro. Unogona kushandisa Windows Service Manager kudzima masevhisi anoenderana. Zvakare, ita shuwa yekuzivisa vese vashandisi uye maapplication anowana sevha yechinangwa chako chekuita iyo update, kudzivirira chero kusagadzikana kana kurasikirwa kwebasa panguva yekuita.

10. Mamwe mazano ekushandisa zvakanaka uye zvakachengeteka kweMariaDB paWindows

1. Windows Firewall Configuration:

Zvakakosha gadzirisa nenzira kwayo Windows Firewall kuti ubvumire kupinda kuMariaDB.⁣ Ita shuwa kuti unobvumidza traffic kunetiweki pachiteshi chirikuteererwa naMariaDB, inova port 3306. Unogonawo kufunga kushandisa imwe yechitatu-party Firewall solution kuti upe dziviriro huru kubva kune dzimwe njodzi.

2. Kugarogadziridzwa kweMariaDB:

Kuti uchengetedze kuisirwa kwako kweMariaDB kwakachengeteka uye kusina njodzi dzinozivikanwa, ndizvo nguva dzose inogadziridza yakakosha. Gara uchitarisa peji rekurodha pane yepamutemo MariaDB webhusaiti kuti uone kuti uri kushandisa yazvino yakagadzikana vhezheni uye shandisa chero inodiwa inogadziridza.

3. Makopi ekuchengetedza zvinhu zvenguva dzose:

Kudzivirira kurasikirwa kwedata muchiitiko chekutadza kwehurongwa kana cyber kurwiswa, ndizvo Izvo zvakakosha kuita nguva dzose backups kubva kune yako database. Iwe unogona kushandisa chechitatu-bato maturusi kana tsika zvinyorwa kuti otomatiki iyi maitiro uye kuve nechokwadi kuti ruzivo rwako dzakachengetedzwa.