MySQL Workbench Icho chishandiso chinobatsira kwazvo kune vanogadzira vanoshanda neMySQL dhatabhesi. Neichi chishandiso, unogona kugadzira, kubata uye kutonga zvinobudirira MySQL databases. Dhaunirodha Bhenji rekushanda reMySQL Iyo iri nyore nzira inogona kuitwa nenzira dzakasiyana, zvichienderana ne sisitimu yekushandisa yaunoshandisa. Ichi chinyorwa chinotsanangura matanho ekutevera kurodha MySQL Workbench paWindows, MacOS uye Linux.
Kutanga kwazvose, zvakakosha kuziva kuti MySQL Workbench ndeye yakavhurika sosi chishandiso chinogona kutorwa mahara kubva ku webhusaiti MySQL mukuru. Izvi zvinoreva kuti inowanikwa kurodha uye kushandiswa pasina muripo MySQL Workbench inopa intuitive uye ine simba graphical interface inoita kuti zvive nyore kugadzira uye kubata MySQL dhatabhesi.
Kurodha MySQL Workbench paWindows, iwe unofanirwa kuwana iyo MySQL yekurodha peji pane yepamutemo webhusaiti. Kubva ipapo, unogona kusarudza yaunoda vhezheni yeMySQL Workbench uye tinya pane inoenderana yekurodha link. Kana iyo yekuisa faira yatorwa, iwe unofanirwa kumhanya iyo yekuisa uye nekutevera iyo-pa-skrini mirairo kuti upedze kuisirwa chishandiso.
Kana MacOS iri kushandiswa, kudhaunirodha MySQL Workbench kuri nyore zvakafanana. Unofanira kushanyira webhusaiti yeMySQL wosarudza MacOS. Sezvakaita Windows, iwe unofanirwa kumhanyisa iyo yekuisa uye kutevedzera mirairo yakapihwa kuti upedze iyo yekuisa maitiro.
Kune avo vanoshandisa Linux masisitimu, maitiro ekurodha akasiyana zvishoma uye anosiyana zvichienderana nekugovera chaiko. Nekudaro, inogona kazhinji kuitwa kuburikidza neiyo terminal uchishandisa yakakodzera package maneja yekugovera iri kushandiswa. Mutariri wepakeji achatarisira kudhawunirodha uye kuisa MySQL Workbench otomatiki, kuve nechokwadi chekuti zvese zvinodiwa zvinogutsikana zvakare.
Mukupedzisa, download MySQL Workbench Iyo iri nyore maitiro anogona kuitwa mahara kubva kune yepamutemo MySQL webhusaiti. Kunyangwe uchishandisa Windows, MacOS kana Linux, pane matanho akajeka ekutevera kuti tive neine simba rekushandisa dhatabhesi rekushandisa pazvigunwe zvedu. NeMySQL Workbench, vagadziri vanogona kugadzira uye kubata MySQL dhatabhesi zvinobudirira uye zvine pundutso.
-Kuenderana kweMySQL Workbench ine akasiyana masisitimu anoshanda
MySQL Workbench ine simba uye inoshanda zvakasiyana-siyana dhizaini yedhizaini uye yekushandisa yekushandisa. Neraki, chishandiso ichi chinowanikwa kune dzakasiyana siyana masisitimu ekushanda, izvo zvinoita kuti ienderane nemapuratifomu akasiyana. Izvi zvinoita kuti zvive nyore kudhawunirodha uye kushandisa zvisinei neiyo sisitimu yekushandisa yatiri kushandisa.
Kana uri kushandisa MahwindoUnogona kudhawunirodha MySQL Workbench zvakananga kubva kune yepamutemo MySQL webhusaiti. Iwe unongoda kuenda kune chikamu chekurodha, sarudza iyo yakakodzera vhezheni ye sisitimu yako yekushandisa uye tinya pane yekurodha link kana kurodha kwapera, ingo mhanyisa faira rekuisa uye tevera mirairo yewizard yekuisa MySQL Workbench pamushini wako.
Kune vashandisi ve Mac OS, kune zvakare vhezheni yeMySQL Workbench iripo. Unogona kuirodha kubva kune yepamutemo MySQL webhusaiti nenzira imwechete sepaWindows. Sezvinoita Windows, kana kurodha kwapera, mhanyisa faira rekuseta uye tevera mirairo yekuisa chishandiso pane yako Mac system Ndokumbira utarise kuti ungangoda Kupa dzimwe mvumo panguva yekuisa kuti uve nechokwadi chekuti zvese zvinoshanda nemazvo.
- Maitiro eku dhawunirodha MySQL Workbench kubva kune yepamutemo MySQL saiti
Danho rechitatu: Enda kune iyo official peji ye MySQL uye tsvaga chikamu kudhawunirodha. Kuti uite izvi, unogona kuzviita kuburikidza nekutsvaga mune yekutsvaga injini yaunosarudza kana kuenda zvakananga kune peji. www.mysql.com. Kana wangove ipapo, iwe uchaona bhaa yekufambisa kumusoro kwepeji. Click Zvaunodhaunirodha kuti uwane iyo MySQL yekurodha peji.
Danho rechina: Papeji yekurodha, MySQL inopa dzakasiyana shanduro dzesoftware, asi iwe uchada Bhenji rekushanda reMySQL kune database management. Ita shuwa kuti wasarudza iyo vhezheni inoenderana neyekushandisa system yauri kushandisa. Semuenzaniso, kana uine Windows, sarudza Windows(x86, 64-bit), MSI Installer. Kana iwe uine macOS, sarudza iyo yakakodzera vhezheni kune yako system. Kudzvanya pashanduro chaiyo kunobva kwatanga kudhaunirodha.
Chechishanu Danho: Kana kudhaunirodha kwapera, enda kune folda uko kuisirwa faira kwakachengetwa. Dzvanya faira kuti utange wizard yekuisa. Tevedza mirairo yepa-screen kuti upedze kuisa maitiro. Panguva yekuisa, zvakare unofanira kusarudza zvimwe zvekuwedzera zvaunoda kuisa. MySQL Workbench inosanganisira zvimwe zvinhu zvakaita se Shell yeMySQL y MySQL Zvishandiso, iyo inogona kubatsira pabasa rako nemadatabase.
-Maminimum system inodiwa yekuisa MySQL Workbench
Usati waenderera kudhawunirodha MySQL Workbench, zvakakosha kuve nechokwadi chekuti system yako inosangana nezvinodiwa zvishoma zvinodiwa pakuiswa kwayo uye kushanda kwayo. Pazasi pane tsanangudzo yezvinodikanwa izvi:
- Sisitimu yekushandisa: MySQL Workbench inoenderana neWindows, macOS uye Linux masisitimu anoshanda.
- Muchina wekugadzirisa: Iyo processor yeinenge 1.6 GHz inokurudzirwa kuti iite zvakakwana.
- Ndangariro: Kanokwana 2 GB ye RAM inodiwa kuti ushande zvakanaka.
- Kuchengetera: Izvo zvinodikanwa kuve neinenge 500 MB ye nzvimbo yedhisiki yekumisikidzwa kweMySQL Workbench nezvimwe zvayo zvekuwedzera.
- Sikirini: Chiratidziro cheanenge 1024x768 pixels inokurudzirwa kuti iratidzike chaiyo yemushandisi interface.
Zvakakosha kuyeuka kuti izvi ndizvo zvidiki zvinodiwa pakugadzwa kweMySQL Workbench, saka kana iwe uchida kushandisa chishandiso zvakanyanya kana nehombe yedata, zvinokurudzirwa kuve nehurongwa hwakasimba hwekuita kwakaringana.
Kana uchinge waita shuwa kuti yako system inosangana izvo zvishoma zvinodiwa, unogona kuenderera kurodha MySQL Workbench uye unakirwe neayo ese maficha. Rangarira kusarudza iyo yakakodzera vhezheni yako yekushandisa system uye tevera iyo yekumisikidza mirairo yakapihwa neMySQL yekuseta kwakabudirira.
- Matanho ekurodha uye kuisa MySQL Workbench paWindows
Kana iwe uchitsvaga iri nyore uye yakachengeteka nzira yekuenda dhawunirodha uye isa MySQL Workbench pakombuta yako yeWindows, iwe wauya panzvimbo chaiyo. Muchinyorwa chino, isu tinokutungamira iwe kuburikidza nematanho anodiwa kuti uwane uye kugadzirisa ichi chakakosha chishandiso munzvimbo yako yekusimudzira. Ramba uchiverenga kuti uzive kuti unozviita sei.
Step 1: Svika iyo yepamutemo MySQL webhusaiti
Chinhu chekutanga chaunofanirwa kuita kuenda kune MySQL yepamutemo webhusaiti. Ikoko iwe unowana sarudzo yekurodha MySQL Workbench. Dzvanya link kuti uwane peji yekudhawunirodha.
Nhanho yechipiri: Sarudza yako chikuva uye dhawunirodha
Kamwe pane yekurodha peji, iwe uchaona runyoro rwekurodha sarudzo dzemapuratifomu akasiyana. Ita shuwa yekusarudza iyo vhezheni inoenderana neyako yekushandisa system (Windows) uye tinya bhatani rekurodha. Iyo yekuisa faira ichachengetwa pakombuta yako.
Nhanho 3: Isa MySQL Workbench
Kana kurodha kwapera, famba uchienda kunzvimbo yawakachengeta faira yekuisa uye tinya kaviri kuti utange kuisirwa. Tevedza mirairo yepa-screen uye gamuchira zvirevo nemamiriro. Munguva yekuisirwa maitiro, iwe unozokumbirwa kusarudza nzvimbo yekumisikidza. Unogona kusarudza nzira yakasarudzika kana kusarudza imwe nzvimbo pane yako dhiraivha yakaoma. Kana kuiswa kwapera, unenge wakagadzirira kutanga kushandisa MySQL Workbench pakombuta yako yeWindows.
Uye ndizvozvo! Iye zvino une matanho anodiwa ekurodha uye kuisa MySQL Workbench pane yako Windows inoshanda system. Ichi chishandiso chinokupa ine hushamwari graphical interface kubata uye kushanda neMySQL dhatabhesi. Tanga kuongorora maitiro ayo uye mabhenefiti nhasi!
- Matanho ekudhawunirodha uye kuisa MySQL Workbench paMac OS
Pazasi pane matanho anodiwa kurodha uye kuisa MySQL Workbench paMac OS.
Step 1: Svika iyo yepamutemo MySQL webhusaiti
Kutanga, tinofanira kuenda kune MySQL yepamutemo webhusaiti tichishandisa browser yedu yatinoda.
Step 2: Enda kune chikamu chekurodha
Kamwe pawebhusaiti yeMySQL, isu tinofanirwa kuwana uye nekudzvanya pane "Kurodha" tebhu, iri pamusoro peji.
Nhanho 3: Sarudza iyo MySQL Workbench vhezheni
Muchikamu chekurodha, tsvaga iyo MySQL Workbench sarudzo. Kune Mac OS vashandisi, zvinokurudzirwa kusarudza iyo vhezheni inoenderana neiyi inoshanda sisitimu. Kana yangosarudzwa, tinoenderera mberi nekudzvanya bhatani rekurodha.
Nhanho 4: Isa MySQL Workbench
Kana iyo yekuisa faira yatorwa, tinoenderera mberi nekuivhura uye nekutevera mirairo yeiyo yekuisa wizard. Munguva iyi, isu tichakumbirwa kusarudza nzvimbo yekuisa uye kubvuma zvirevo nemamiriro. Kamwe kuisirwa kwapera, tinogona kumhanya MySQL Workbench kubva kune folda yekushandisa.
Iye zvino zvawaziva matanho anodiwa, uchakwanisa kurodha nekuisa MySQL Workbench paMac OS yako pasina matambudziko. Rangarira kushanyira iyo yepamutemo MySQL webhusaiti kuti uwane yazvino vhezheni iripo uye unakirwe ese maficha aunopihwa nechishandiso ichi.
- Matanho ekurodha uye kuisa MySQL Workbench paLinux
MySQL Workbench ndeye-inofanirwa-kuva nechishandiso chevagadziri uye dhatabhesi maneja vachishandisa Linux. Neraki, kurodha nekuisa MySQL Workbench paLinux inzira iri nyore. Muchikamu chino, ini ndichakutungamirira kuburikidza nematanho anodiwa kurodha uye kuisa iyi ine simba dhatabhesi manejimendi chishandiso.
Danho 1: Tarisa kuwanikwa
Usati watanga kurodha uye kuisa, ita shuwa kuti Linux yako yekugovera inotsigira MySQL Workbench. Unogona kutarisa kuwanikwa nekubvunza zvinyorwa zvekugovera kwako kana kushanyira iyo yepamutemo MySQL Workbench webhusaiti. Ita shuwa kuti une zvinodiwa zvinodiwa, senge Internet yekubatanidza uye mvumo yekutonga.
Danho 2: Dhawunirodha MySQL Workbench
Kana wangosimbisa kuenderana, yave nguva yekurodha MySQL Workbench. Enda kune yepamutemo MySQL webhusaiti uye tsvaga iyo yekurodha chikamu. Pano iwe unowana akasiyana mavhezheni aripo eLinux. Sarudza iyo yakakodzera vhezheni yekugovera kwako uye tinya inoenderana yekurodha link. Iko kurodha kunotanga otomatiki uye faira ichachengetwa pakombuta yako.
Nhanho 3: Isa MySQL Workbench
Kana iko kurodha kwapera, vhura folda uko iyo MySQL Workbench yekuisa faira yakachengetwa. Tinya-kurudyi pane faira uye sarudza iyo "Vhura neiyo Terminal" kana "Vhura muTeminari" sarudzo. Izvi zvinovhura hwindo rekupedzisira, kwaunogona kumhanya mirairo uye woenderera mberi nekuiswa. Tevera mirairo yepa-screen kuti upedze kuisa. Kana yapera, MySQL Workbench ichave yakagadzirira kushandiswa paLinux system yako.
Nematanho akareruka aya, uchakwanisa kudhawunirodha uye kuisa MySQL Workbench pakombuta yako yeLinux Gara uchiyeuka kutarisa kuenderana uye kutevedzera mirairo inopihwa nemagwaro epamutemo. MySQL Workbench ichakubvumidza iwe kubata yako dhatabhesi nzira inoshanda uye ita mabasa akadai se schema dhizaini, kugadzira mibvunzo, uye manejimendi emushandisi. Nakidzwa neiyi ine simba dhatabhesi manejimendi chishandiso pane yako Linux system!
-MySQL Workbench yekutanga kuseta uye matanho ekutanga
MySQL Workbench yekutanga kuseta uye matanho ekutanga
Paunenge uchinge warodha MySQL Workbench, nhanho inotevera ndeyekuita yekutanga gadziriso. Paunovhura chirongwa kekutanga, iwe unozokumbirwa kuisa ruzivo rwekubatanidza. Izvi zvinosanganisira zita rekushandisa uye password yeserver yako. dhatabhesi, pamwe chete nezvimwe zvigadziriso zvinoenderana nezvaunoda. Paunenge wapedza iyi yekutanga kuseta, wagadzirira kutanga kushandisa MySQL Workbench.
Iyo MySQL Workbench interface yakakamurwa kuita akati wandei zvikamu zvikuru, chimwe nechimwe chine basa rayo chairo. Kuruboshwe kune chinhu chekufambisa, kwaunogona kuwana dhatabhesi, matafura, maonero, uye akachengetwa maitiro. Pakati ndiyo nzvimbo huru yebasa, kwaunogona kugadzira Mibvunzo yeSQL, gadzira uye gadzirisa matafura, uye ita mamwe mabasa ane chekuita nedatabase management. Pazasi pane tebhu yemhedzisiro, uko mibairo yemibvunzo yakaurayiwa kana chero mhosho meseji icharatidzwa..
Iye zvino zvawajaira iyo interface, yave nguva yekutanga kushanda neMySQL Workbench. Unogona kugadzira chinongedzo chitsva nekudzvanya pakanzi "New Connection" pairi toolbar kana nekusarudza «Faira» -> «Itsva yekubatanidza hwindo». Tevere, iwe unozofanirwa kuisa ruzivo rwekubatanidza, senge zita remugamuchiri, port, username, uye password. Kana uchinge watanga kubatana, iwe unokwanisa kuita SQL mibvunzo, kuita dhatabhesi manejimendi mabasa, uye zvimwe zvakawanda. Ongorora ese maficha uye mabasa anopihwa neMySQL Workbench uye uwane zvakanyanya kubva muchishandiso ichi chine simba chekugadzirisa MySQL dhatabhesi!
-Kurudziro yekukwirisa MySQL Workbench kuita
Kune akati wandei Kurudziro yekukwirisa MySQL Workbench kuita uye ita shuwa kuti chishandiso ichi chinoshanda nemazvo. Chimwe chezvinhu zvokutanga zvaunogona kuita gadziridza kune yazvino vhezheni yeMySQL Workbench. Zvigadziriso zvinowanzo sanganisira kuvandudzwa kwemashandiro uye kugadzirisa tsikidzi, saka zvakakosha kuti ugare uchiziva nezveshanduro dzichangoburwa.
Imwe kurudziro yakakosha ndeye gadzirisa zvakanaka MySQL Workbench zvido. Izvi zvinosanganisira kugadzirisa ndangariro yakagoverwa kuchishandiso uye nekugonesa iyo database yekubatanidza marongero. Mukuwedzera, inokurudzirwa dzima sarudzo dzisina kufanira izvo zvinogona kushandisa zviwanikwa uye kudzikisira kuita kweMySQL Workbench.
Pamusoro pezvo, kuti uwedzere kukwirisa mashandiro e MySQL Workbench, mamwe anogona kuteverwa. maitiro akanakisa. Somuenzaniso, inokurudzirwa kuderedza huwandu hwe data inoratidzwa mumibvunzo uye shandisa pagination kupatsanura zvabuda kuita zvidimbu zvidiki. Izvo zvakakoshawo kufunga nezve MySQL log file size uye ita shuwa kuti yakagadziriswa nemazvo kudzivirira mabhodhoro ekuita.
- Gadziridza MySQL Workbench kune yazvino vhezheni iripo
Kugadziridza MySQL Workbench kune yazvino vhezheni iripo
MySQL Workbench yakakurumbira dhizaini dhizaini uye yekushandisa yekushandisa. Kana iwe uri mushandisi weMySQL Workbench, zvakakosha kuti uchengetedze software yako iri-kusvika-date kuti utore mukana wekuvandudzwa kwazvino uye kugadzirisa kwebug. Zvadaro, tinotsanangura sei dhawunirodha yazvino vhezheni yeMySQL Workbench uye maitiro ekugadzirisa yako vhezheni iripo.
Danho rekutanga: Svika iyo yepamutemo MySQL webhusaiti (https://www.mysql.com/) uye famba uchienda kuchikamu chekurodha. Kana wangovepo, tsvaga iyo "Download MySQL Workbench" chikamu uye tinya pane inoenderana link.
Danho rekutanga: PaMySQL Workbench yekurodha peji, sarudza iyo vhezheni yeMySQL Workbench inoenderana neyako yekushandisa system. Sarudzo dziripo dzinowanzo sanganisira shanduro dzeWindows, macOS, uye Linux.
Danho rechisere: Paunenge wasarudza iyo yakakodzera vhezheni, tinya iyo yekudhawunirodha link. Iro faira rekuisa richadhaunirodwa kukombiyuta yako nenzira yakamanikidzwa (somuenzaniso, mu.zip kana .tar.gz fomati).
Izvo zvakakosha kuti uzive kuti usati wagadzirisa MySQL Workbench, zvinokurudzirwa kuti ita kopi yekuchengetedza yedatabase yako iripo kudzivirira chero kurasikirwa kwedata. Zvakare, iva nechokwadi chekuverenga zvinyorwa zvinoburitswa kuti uwane ruzivo nezve shanduko nekuvandudzwa usati wavandudza. Nematanho akareruka aya, unogona kuchengetedza MySQL Workbench yako kusvika parizvino uye kunakidzwa nezvazvino maficha uye kuvandudzwa kwainopa.
-Kugadzirisa matambudziko akajairika pakurodha kana kuisa MySQL Workbench
Paunenge uchirodha kana kuisa Bhenji rekushanda reMySQL, unogona kusangana nezvimwe zvinetso zvinowanzoitika. Pano tichakuratidza maitiro ekugadzirisa mamwe ematambudziko akajairika kuitira kuti utange kushandisa MySQL Workbench pasina matambudziko.
Dambudziko 1: Kuisa kukanganisa
Kana iwe ukagamuchira meseji yekukanganisa paunenge uchiedza kuisa MySQL Workbench, inogona kunge iri nekuda kwedambudziko nehurongwa hwezvinodiwa kana kushaikwa kwekodzero dzevashandisi. Ita shuwa kuti unosangana nezvinodiwa zvishoma system, senge yekushandisa system vhezheni uye ndangariro zvinodiwa. Zvakare, edza kumhanyisa iyo yekuisa neye maneja kana superuser ropafadzo kuti udzivise matambudziko ekuwana.
Dambudziko rechipiri: Dambudziko rekubatanidza Database
Kana uchinge waisa MySQL Workbench, unogona kuomerwa nekubatanidza kune yako database. Simbisa kuti ruzivo rwekubatanidza, senge zita remugamuchiri, chiteshi, zita rekushandisa, uye password, zvakaiswa nemazvo. Kana iwe ukaramba uchitarisana nematambudziko ekubatanidza, ungangoda kugadzirisa firewall yako kana kugadzirisa kune server database.
Dambudziko rechitatu: Kunonoka kuita kana kukanganisa kazhinji
Kana uri kusangana nekuita zvishoma nezvishoma muMySQL Workbench kana chirongwa chikaparara nguva dzose, izvi zvinogona kunge zvichikonzerwa nenhamba yezvikonzero zvakasiyana Zvinogona kubatsira kukwidziridza kune yazvino vhezheni yeMySQL Workbench kuti uve nechokwadi chekuti une kuvandudzwa kwazvino uye bug. fixes. Zvakare, edza kuongorora masisitimu ako uye woigadzirisa zvinoenderana neMySQL kurudziro Zvakare, simbisa kuti komputa yako inosangana nezvinodiwa zvehardware uye funga kusunungura nzvimbo pa hard drive kana kunenge kwazara.
Ini ndiri Sebastián Vidal, injiniya wekombuta anofarira nezve tekinoroji uye DIY. Uyezve, ndini musiki we tecnobits.com, kwandinogovera zvidzidzo kuti tekinoroji iwanikwe uye inonzwisisika kumunhu wese.