Muchinyorwa chinotevera tichatarisa kuti tingaisa sei MySQL Workbench paUbuntu tichishandisa snap package. Ichi chi software inogona kushandiswa kubata MySQL dhatabhesi kubva kune yemuno kana kure muchina. Zvinogona kutaurwa kuti ishandiso yakabatana yekuona yevagadziri, vanogadzira uye dhatabhesi maneja, inowanikwa yeGnu / Linux, Windows uye Mac OS X.
Sezvatotaurwa pamusoro imwe nyaya yakadhindwa pane ino blog, MySQL Workbench inzvimbo ine graphical yekushanda neMySQL dhatabhesi uye maseva. Iyo inogadzirwa uye kugoverwa neOracle Corporation, uye inowanikwa mune akasiyana edhisheni ekutengesa kuti ishandiswe padanho rebhizinesi. Oracle zvakare inogovera yakavhurika sosi Community Edition, inowanikwa mahara.
Chirongwa ichi inotsigira dhatabhesi uye manejimendi evashandisi, kugadzira nekuita SQL mibvunzo, kugadzirisa maseva, kuita mabhapu, kuita migration, nezvimwe zvakawanda.. MySQL Workbench inoita kuti zvive nyore kubata dhatabhesi yako yeMySQL, ungave uri mushandisi mutsva kana nyanzvi. Inosanganisira zvese zvinodiwa ne data modeler kugadzira yakaoma ER modhi, uye inopawo zvakakosha maficha kuita zvinyorwa zvakaoma uye kushandura manejimendi mabasa ayo anowanzoda nguva yakawanda nesimba. Workbench ichashandawo neMariaDB dhatabhesi sezvo MariaDB iri kutsiva yakananga kuMySQL.
Isa MySQL Workbench seSnap Package paUbuntu
Vashandisi vanogona kuisa Workbench uye kuishandisa mune kumwe kugoverwa kweGnu / Linux, kwete Ubuntu chete. Asi mumitsetse inotevera tichaona sei isa MySQL Workbench paUbuntu uchishandisa iyo snap kurongedza. Nhasi, iyo Workbench package haigone kuwanikwa muUbuntu repository seUbuntu 20.04, saka kushandisa iyi yekuisa sarudzo chinhu chinogona kutibatsira.
Kuita iyo community version installation, tinogona kushandisa sarudzo yeUbuntu software, kana terminal (Ctrl + Alt + T). Kana ukasarudza kushandisa iyi yekupedzisira sarudzo, iwe unongoda kunyora iyo yekuisa murairo mairi:
sudo snap install mysql-workbench-community
Kana kuiswa kwapera, tinogona tanga chirongwa ichi kubva mumutsara wekuraira kunyora:
mysql-workbench-community
Uye zvakare, isu tinogona zvakare tanga chirongwa nekutsvaga wekutanga kuti tichakwanisa kuwana inowanikwa muchikwata chedu.
Kuti ubatanidze kune database server, isu tinongofanidza kudzvanya pa Database == Batanidza kune database. Tinogonawo wedzera chinongedzo chitsva nekudzvanya pane ⊕ chiratidzo chatinogona kuwana padivi pe 'MySQL kubatana'.
Kana tasvika, tinofanira chete gadzira chinongedzo chitsva, kunyora zvitupa zvesevha yedatabase uye kuyedza kubatana. Kana zvese zvanyorwa nemazvo, mese magadzirira kuenda.
Sezvakaratidzwa mu GitHub repo uko iyo snap vhezheni yechirongwa ichi inoburitswa, kana ukashandisa zvinongedzo, Workbench inoshandisa Password Manager uye ssh kushanda nemazvo. Saka zvakafanira kupa mvumo iyi zvakajeka. Tinogona kuita izvi nekuvhura terminal (Ctrl + Alt + T) uye nekunyora mairi inotevera mirairo, imwe neimwe:
snap connect mysql-workbench-community:password-manager-service snap connect mysql-workbench-community:ssh-keys
Kana iwe ukashandisa mafaera pane ekunze madhiraivha kana zvakare anoda kudhinda mafaera, zvichave zvakakodzera kuita mirairo iyi mune terminal:
snap connect mysql-workbench-community:cups-control snap connect mysql-workbench-community:removable-media
Uninstall
Para bvisa chirongwa ichi kubva kuchikwata chedu, mune terminal (Ctrl + Alt + T) zvinongodiwa kunyora murairo:
sudo snap remove mysql-workbench-community
Nhasi, muGnu / Linux kune akawanda mikana yekushanda nemadhatabhesi. Izvi zviri nyore kushandisa, asi ingori imwe sarudzo yezvizhinji zviripo. Wese munhu anogona kuwana iyo inonyatsokodzera nzira yavo yekushanda. For tora rumwe ruzivo nezve chirongwa ichi, vashandisi vanogona kuenda ku purojekiti webhusaiti kana rake zvinyorwa.