Akanakisa MySQL GUI Zvishandiso zveKudzidza kuPurogiramu
Nyika yehurongwa yakafara uye iri pasi pemhando dzakasiyana dzemitauro nenzvimbo, masisitimu ekuchengetedza dhatabhesi akanyudzwawo mumaitiro aya, nekuti panguva ipi neipi chero chirongwa kana kunyorera kuchada kuchengetedza ruzivo. Tichifunga izvi, tinogona kutaura kuti MySQL ndiyo yakazara yakazara database maneja nhasi. Saka panguva ino isu tinotarisa pane izvo zvatinoona kunge akanakisa MySQL GUI maturusi. Kugonesa kunzwisiswa kwetemu tinogona kuti ndiwo maApp akanaka ekuronga muMySQL.
Nezve kushandiswa kweiyi inokosha system, isu tinogona kutarisira kuti ine maviri marudzi emalayisensi, imwe yemahara iyo inozivikanwa munyika yepurogiramu seyakavhurwa sosi. Uye kune zvekare iyo nyanzvi yekubhadhara sarudzo iri pamusoro pekambani yeOracle.
MaBhaibheri ese ari maviri anosanganisirwa zvirinani neyakanakisa MySQL GUI maturusi atichataura mune ino chinyorwa.
MySQL Zvimiro
Vazhinji vevagadziri nhasi vatanga kushandisa MySQL kune avo ese mapurojekiti. Izvi zvinokonzerwa nehurongwa, chengetedzo uye mashandiro, asi izvi hazvisi zvese hunhu hwatinogona kuratidza nezve uyu mutauro. Uye ndosaka takatora basa rekugadzira diki muunganidzwa neakanyanya kufadza iwo.
- SQL rutsigiro
- maonero
- Maitiro Akachengetedzwa
- Zvinokonzera
- kutengesa
Kana iwe uchitsvaga mambure eakanakisa maApplication ekuronga muMySQL, zvirokwazvo haugone kuwana ruzivo rwakadzama, mazhinji masayiti haazive iwo mazwi kuitira kuti vaverengi vapedzisire vavhiringidzika. Naizvozvo, kubva zvino zvichienda mberi iwe unofanirwa kuziva kuti izvo zvauri kutsvaga ndizvo zvishandiso zveGUI (Graphic Mushandisi inowanikwa) graphical mushandisi interface muSpanish.
Chii chiri kukosha kweMySQL
Tinogona kungoti ndeimwe yeakanakisa masisitimu manejimendi manejimendi, uyezve, kuti tiwane zano chairo tinofanirwa kuziva zvinorehwa nerimwe izwi rinokosha kwazvo. LAMP Iyo internet sisitimu yezvivakwa iyo inovhara yakanyanya kukosha mamaneja.
Tinokukurudzira iwe: Iwo akanakisa maApplication ekuronga muJAVA
Ichi chimiro chinofukidza LINUX, APACHE, MySQL, PHP, chirevo, uye sezvaungaona MySQL iri mukati mechimiro. Naizvozvo, isu tinogona kuona kuti iri pane iyo runyorwa pamwe nehofori dzechikamu.
Akanakisa Mahara eMySQL GUI Zvishandiso
Zvino isu tichatanga nerondedzero yezvatinofunga kuti ndezvakanakisa maApplication ekuronga muMySQL. Zvekugadzirwa kwechinyorwa ichi tinovimba neruzivo rwevanyanzvi munyika yehurongwa uye nemafungiro evashandisi vasina ruzivo rwakakura.
Mune ino runyorwa tichagadzirisa maturusi emahara uye anobhadharwa, pamwe neaya akagadzirirwa vashandisi vasina ruzivo rwakanyanya pamusoro penyaya iyi pamwe neenyanzvi.
Workbench
Ichi chishandiso chigadzirwa cheOracle uye chine GPL rezinesi, inoenderana neMicrosoft Windows, Linux, Mac Os masisitimu anoshanda. Workbench inowanikwa mune yayo yakagadziridzwa vhezheni uye iwe unogona kuiwana kubva pane sarudzo iyo yatinokusiira iwe.
Iyo maneja inosanganisa kuvandudza, dhizaini uye kugadzirisa kwe database. SQL
Iyi ndiyo imwe yesarudzo dzinoshandiswa nemamwe makambani kuti vashandi vadzo vatore mapurojekiti ega ega. Izvi nekuda kwekureruka kwaungashandisa maturusi ese akabatanidzwa ayo ainayo.
Sequence Pro
Ichi chimwe chikuva chatinogona kuratidza seimwe yeakanakisa maturusi eGUI eMySQL. Iri rezenisi remahara, ndiko kuti, tinogona kuwana nekuishandisa zvachose mahara. Kunyangwe iri yemahara kana iwe uchida kupa nechombo iwe unogona kupa mupiro, izvi zvinoenderana nemushandisi wega wega.
Pakati pekukanganisa kwatinogona kutaura nezveSequel Pro ndeyekuti inoshanda chete neMac Os Tiger Universal Buil. Muchokwadi, iyi inguva itsva yeyaimbozivikanwa seCocoaMySQL.
Kazhinji yenguva ino chishandiso chinoshandiswa kuwedzera kana kubvisa matafura kubva kudhatabhesi, pamwe nekuve nekutarisisa kwezvose zvirimo. Inoenderana neMySQL kubva pa3 - 5.
Akanakisa Muchinjikwa-Ipuratifomu MySQL GUI Zvishandiso
Heidi SQL
Tinouya kune imwe yeakanakisa maapplication kuronga neMySQL, irowo rezenisi remahara uye inotsigira zvipo kubva kune vashandisi vayo. Pakati pemapuratifomu akatsigirwa pane Windows 2000, Windows XP, Windows Vista, uye inoshandawo mune chero vhezheni yeLinux neWine.
Ichi chishandiso chakagadzirwa na Ansgar Becker uye yaimbozivikanwa seMySQL-Mberi. Izvo zvakati, zvirokwazvo iwe unorangarira kuti papuratifomu iyi waifanira kupinda mukati kuti ugone kushandisa mashandiro ayo. Iyi ficha inochengetwa mune iyi kuburitswa. Izvo zvakakosha kuti iwe uve nechokwadi chekupinda mukati uye kubuda kunze nenzira kwayo.
Kubva paApp iyi tinogona kubata dhatabhesi redu nenzira yakapfava uye inoshanda kunyangwe panguva ino isu tichiri kushanda mukugadzira kusangana kweMySQL kumberi-kumagumo.
PHPMyAdmin
Uyu maneja ndomumwe wevanonyanya kushandiswa uye izvi imhaka yekuti pakutanga ndiyo yemahara vhezheni uye tinogona kuishandisa mahara. Muchiitiko chechipiri tinokwanisa kutaura kuti ndechimwe chemaapplication ekuronga muMySQL ayo anogona kubatanidzwa nyore nyore neakawanda masisitimu anoshanda.
Iyo PHPMyAdmin turusi pani ndechimwe chezvinhu zviri nyore kushandisa sezvazvinogadzirirwa kune wepakati mushandisi asina ruzivo rwakadzika rwehurongwa neMySQL. Iyi sarudzo inobvumira akasiyana siyana maMySQL mashandiro. Pakati pavo tinogona kusimbisa manejimendi edhatabhesi, matafura, indexes, minda.
Ichi chishandiso chekuronga nekutarisira muMySQL ndechimwe chinonyanya kushandiswa sezvo chakazara, senge dzimwe sarudzo iwe dzaunokwanisa kuwana kuti uzviedze kubva pane sarudzo yatinokupa.
Nhoroondo yeMyDB Studio
Ichi chishandiso chine rezinesi remahara, saka, unogona kurishandisa mahara. Inoenderana neshanduro dzese dzeWindows dziripo parizvino, kunze kweWindows 11.
Kana iwe uchitsvaga chemahara chishandiso kubata yako MySQL server. iyi ndeimwe yesarudzo dzakanakisa dzaunofunga nezvadzo. Iyo inotibvumidza isu kuti tiite, kugadzirisa uye kudzima zvinhu kubva ku database.
Uye zvakare, isu tinogona kuwiriranisa, kupinza uye kutumira kunze iyo data nekukurumidza uye nyore nzira, kushanda kweMyDB Studio ndiko kunoita kuti ive imwe yeanodiwa kune vakawanda vashandisi. Pakati pezvimwe zvehunhu hwayo hukuru isu tinokwanisa kuratidza kuti inobvumidza kushandiswa kweSSH tunnel kuti ibatsire mukuchengetedzeka kwehukama hwako.
Iwe unogona kuva uchifarira: Mitauro iwe yaunofanirwa kudzidza kutanga chirongwa
Yakanakisisa yakabhadharwa MySQL GUI maturusi
Sezvo paine mahara zvachose mahara tinokwanisa zvakare kuwana dzimwe nzira dzakabhadharwa, anotevera manejimendi ekushandisa neMySQL yatinozotarisa ndeimwe yezvakakosha kwazvo zvatingawana nhasi.
Isu tinotsvaga yakanakisa hunyambiri pakati pemutengo nekushanda, nekudaro, isu tinogutsikana kuti mukati mavo muchawana zvese zvauri kutsvaga.
Tisati tataura zvimwe zvezvinhu zveiyi MySQL GUI tinogona kusimbisa izvo ine yemahara 30-zuva vhezheni. Kana iwe usiri kuda kutora iyo premium vhezheni, ino nguva yekuyedza ndeimwe yedzakanakisa dzimwe nzira dzaunogona kufunga nezvadzo. Kuti uwane iyo yemahara vhezheni iwe chete unofanirwa kuwana iyo sarudzo iyo yatinokupa iwe.
Zvingave sei zvikasadaro, chikuva ichi chinoenderana neakakosha masisitimu anoshanda (Windows, Linux neMac)
Navicat ari maviri maneja wedhatabhesi uye maneja wekusimudzira, izvi zvinotipa hukuru hwemabasa mazhinji uye ndosaka chiri chakabhadharwa chishandiso. Chimwe chezvinhu zvaro zvinoshamisira ndechekuti inogona kusanganiswa nechero MySQL server kubva vhezheni 3.21 zvichienda mberi.
Kana isu tichiedza kuisa chikamu ichi chishandiso tinogona kutaura kuti chinokwana mukati mevanyanzvi zvakanyanya zvichibva pane ayo akakosha anoshanda mapaneru. Asi zvakare yakakosha kune avo vari kutanga kushanda neMySQL, sezvo iine intuitive interface iri nyore kwazvo kuitisa sezvatinoishandisa.
SQL Maestro MySQL Zvishandiso Mhuri
Iyi MySQL GUI chishandiso ndeimwe yeinowanikwa zvakanyanya mukati meyakabhadharwa, parizvino ine mutengo wemadhora makumi mapfumbamwe nemapfumbamwe pamashanduro ayo ekutanga uye ane hunyanzvi anokwira kusvika kumadhora zana nemazana mapfumbamwe. Aya mavhezheni eprimiyamu ane imwe yakazara kwazvo MySQL manejimendi manejimendi matinogona kuwana.
Iyo pasuru inosanganisira SQL tenzi, Code Fekitori, Dhata Wizard, Service Center uye PHP jenareta Pro. Zvakare, isu tinofanirwa kutaura kuti iwe uchagashira zvigadziriso zvemakore matatu. Iyi chikuva uye inoenderana neWindows mune ayo ese mavhezheni.
Kana zviri zvikumbiro zvakanakisa zvekuronga neMySQL, iyi ndeimwe yesarudzo dzakazara uye inoshandiswa nemakambani ehunyanzvi sezvo iine zvese zvaunoda kubata dhatabhesi pane mumwe munhu kana mubatanidzwa.
SQLWave
Chigadzirwa chekambani yeNerocode uye chinotengwa mumusika wemadhora makumi mapfumbamwe nemapfumbamwe, haina mabhizinesi ekushandura kana kupfuura aya. Kuenderana kwayo kunogumira paWindows 99, Windows XP, Windows 7 uye Vista.
Ichi chishandiso cheMySQL GUI chakagadzirirwa kuita maitiro akareruka uye nekukurumidza kune wepakati mushandisi anotarisa kuti agadzirise data ravo. SQLWave inoshanda mushe pamwe neMySQL 4.x-6.x.
Kune vanhu vanoda yemahara muedzo pane 30-zuva rekuyedza sarudzo inowanikwa, iyi vhezheni yakakwana uye inotibvumidza isu kuwana mukana kune ese mashandiro epuratifomu. Kuti uwane kwazviri, iwe chete unofanirwa kunyoresa uye kutanga kuyedza iyi yakanaka kwazvo app.
dbForge Studio
Kupatsanurwa kwekambani yeDevart uye isu tinogona kuiwana ichiwanika muzviratidziro zviviri, yekutanga nemutengo we $ 2 muchikamu chayo chakajairika uye imwe iri pa $ 49 muchikamu chehunyanzvi. Inotsigira ese mavhezheni eWindows uye ine yakanakisa technical technical service.
Muchokwadi, iyi GUI iri mushanduro nhatu, iwo maviri ataurwa pamusoro anobhadharwa uye yakajairwa vhezheni yatinogona kuwana mahara. Kunyangwe iri sarudzo inowanikwa kune wese munhu, haina mabasa ese akazara ehunyanzvi-chikamu dhatabhesi maneja.
Zvimwe zvishandiso izvo dbForge Studio inosanganisira seimwe yeakanakisa GUI yeMySQL
- Schema Enzanisa neMySQL
- Dhata Enzanisa yeMySQL
- Query Muvaki weMySQL
- Fusion yeMySQL
Pakati pesarudzo dzekubhadhara iyi ndeimwe yesarudzo dzakanakisa seDBTools Manager GUI maturu emabasa ako ekuchengetedza dhatabhesi. Izvi pasina mubvunzo imwe yeakanakisa premium MySQL mapurogiramu ekushandisa aunogona kuwana.
DBTools maneja
Iyi ine maBhaibheri maviri, akajairwa atinogona kuwana mahara uye imwe yekubhadharisa ine kukosha kwe $ 2. Inowirirana neWindows 69.90, Vista, 7 uye XP.
Iwe unogona kufarira kuziva iyo akanakisa maApplication kuronga muPython
Ichi chishandiso chakanyanya kushandiswa kwemunhu pane bhizinesi, iri sarudzo yakanakisa kune vanhu vanoda kudzidza zvese zvine chekuita nehurongwa neMySQL uye vanobata maitiro ese.
Kunyangwe iri chikuva chakanakira vatangi, yakagadzirirwawo maDBA kuve nehunyanzvi maneja wedhatabhesi pamaoko avo. Iko hakuna zvakawanda zvekutaura nezve iyi sarudzo kunze kwekureruka kwekushandisa uye yayo 20-mazuva ekuyedza nguva inotsigira MySQL 3,4 uye 5.
dbeaver
Imwe yematurusi anozivikanwa kwazvo munyika ino yezvakanakisa maturusi ekuronga muMySQL. Imwe yemabhenefiti ayo makuru ndeyekuti inogona kushandiswa zvakakwana mune chero sisitimu inoshanda, ingave Windows, Mac kana Linux.
Asi hazvisi izvo zvese, isu tinofanirwa zvakare kuratidza kuti inotsigira MySQL, MariaDB, Oracle, SQL server pakati pevamwe. Iyo ine akawanda mashandiro uye iwe unogona kuwana iyi kunyorera mahara, izvi zvinomiririra mukana mukuru kune avo vari kutanga kubata dhatabhesi muMySQL.
Kufambisa kuburikidza nemapaneru ayo DBeaver anotipa ari nyore kunzwisisa nekuti chinangwa chikuru ndechekukupa iwe manejimendi manejimendi, kunyangwe ichienderana neanoverengeka masisitimu anoshanda, anonyanya kushandiswa neLinux uye mhedzisiro yacho yakanaka.
Mhedziso pane akanakisa MySQL GUI maturusi
Iye zvino une zano riri nani rekuti ndedzipi dzakanakisa MySQL GUI maturusi aunogona kushandisa mune yavo yemahara kana yakabhadharwa vhezheni. Tichave tichiwedzera runyorwa urwu nemidziyo yakatanhamara inogona kukodzera mukati memusoro uyu unonakidza uye unobatsira. saka tinokurudzira kuti urambe uchitishanyira nguva nenguva.
MySQL ipuratifomu ine simba yatinogona kudzidza kubata nenzira yakanaka nerubatsiro rweGUI. Uye nerondedzero yatinokusiira, hauzove nematambudziko kusarudza iyo inonyatsoenderana nezvido zvako. Kana iwe uchitsvaga akanakisa maapplication ekuronga muMySQL, usazviite futi uye tanga kuyedza sarudzo dzatinokusiira iwe.