I-MySQL Workbench yindawo yemizobo yokusebenza kunye neenkcukacha ze-MySQL kunye neeseva. Iphuhlisiwe yaza yasasazwa yiOracle Corporation, i-MySQL Workbench iyafumaneka kumahlelo aliqela orhwebo okusetyenziswa kwinqanaba leshishini.
Oracle nayo isasaza uHlelo loLuntu oluVulekileyo, olufumaneka simahla (yeeWindows, iMacOS, kunye neLinux).
Iimpawu zeBench Workbench
Iimpawu zeBench Workbench vumela umsebenzisi ukuba enze kwaye alawule unxibelelwano lweseva yedatha kwaye asebenzise imibuzo ye-SQL Kolu nxibelelwano lwedatha usebenzisa umhleli we-SQL eyakhelweyo.
I-MySQL Workbench isekwe kumanqaku amahlanu abalulekileyo nala alandelayo:
- Uphuhliso lwe-SQL: ikuvumela ukuba wenze kwaye ulawule unxibelelwano kumaseva wedatha. Ukongeza kokuvumela umsebenzisi ukuba aqwalasele iiparameter zonxibelelwano, i-MySQL Workbench ibonelela ngesakhono sokuqhuba imibuzo ye-SQL kunxibelelwano lwedatha usebenzisa iSQL Sakhelwe ngaphakathi.
- Imodeli yedatha (uyilo): ikuvumela ukuba ubonise ngokomfanekiso i-schema yedatha yakho, ubuyisele umva kunye nonjineli ngqo kwi-schema kunye nedatha esebenzayo, kwaye uhlele yonke imiba yedatha yakho usebenzisa isiHlomelo setafile esibanzi. Umhleli wetafile ubonelela ngezixhobo ekulula ukuzisebenzisa zokuhlela iitafile, iikholamu, izalathiso, izinto ezibangela, izahlulelo, ukhetho, ukufaka kunye namalungelo, iindlela kunye neembono.
- Ulawulo lweseva: Ikuvumela ukuba ulawule iimeko zeseva ye-MySQL ngokulawula abasebenzisi, ukwenza ugcino kunye nokubuyisa, ukuhlola idatha yophicotho, ukujonga imeko yedatha, kunye nokujonga ukusebenza kweseva ye-MySQL.
- Ukufuduka kwedatha: ikuvumela ukuba ufuduke kwi-Microsoft SQL Server, Microsoft Access, Sybase ASE, SQLite, SQL Naphi na, PostreSQL, kunye nezinye iitafile ze-RDBMS, izinto kunye nedatha kwi-MySQL. Ukufuduka kukwaxhasa ukufuduka ukusuka kwiinguqulelo ezindala ze-MySQL ukuya kwiinguqulelo zamva nje.
- Inkxaso yamashishini e-MySQL: Inkxaso yeemveliso zeshishini ezinje nge-MySQL Enterprise Backup, i-MySQL Firewall, kunye ne-MySQL Audit.
I-MySQL Workbench inokuvelisa iskripthi esifanelekileyo ukwenza isiseko sedatha oko kutsaliwe kwiskimu; iyahambelana nemodeli yedatha ye-DBDesigner 4 kwaye ixhasa amanqaku amatsha afakwe kwi-MySQL 5.
Uyifaka njani i-MySQL Workbench kwi-Ubuntu nakwiziphumo?
Ukufaka esi sixhobo kwinkqubo yethu, Singayenza ngokuthe ngqo kwii-Ubuntu zokugcina.
Ke sinokuzixhasa ngeziko lethu lesoftware, i-synaptic okanye kwisiphelo esinye Singalwenza ufakelo ngokwenza lo mthetho ulandelayo:
sudo apt install mysql-workbench
Kulungiselelwe abo bakhetha ukufaka kusetyenziswa ipakeji yamatyala azinzileyo yakutshanje, Ungaya kwiwebhusayithi esemthethweni yeprojekthi kwaye kwicandelo lokukhuphela uya kufumana amakhonkco.
Okwangoku uguqulelo oluzinzileyo lwangoku ngu-8.0.15 ke ukuba ukhetha njalo ungasebenzisa nayiphi na le miyalelo ilandelayo yokukhuphela.
Ubuntu 18.10 kunye nabasebenzisi abasuswayo kufuneka basebenzise lo mthetho ulandelayo kwisiphelo sendlela:
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community_8.0.15-1ubuntu18.10_amd64.deb
Ngelixa kwabo bakhoyo Abasebenzisi be-Ubuntu 18.04 LTS okanye ezo zithathwe kolu hlobo loBuntu, iphakheji yokukhuphela yile ilandelayo:
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community_8.0.15-1ubuntu18.04_amd64.deb
Nje ukuba ukhuphelo lwenziwe, ungafaka iphakheji ngoncedo lomphathi wephakheji oyikhethileyo okanye kwisiphelo ngokwaso. ukwenza lo mthetho ulandelayo:
sudo dpkg -i mysql-workbench*.deb
Kwaye sisombulula nayiphi na ingxaki ngokuxhomekeka kokwenza oku kulandelayo kwisiphelo sendlela:
sudo apt -f install
Ukusetyenziswa ngokusisiseko kwe-MySQL Workbench
Ukuqala ukusebenzisa esi sixhobo Kuya kufuneka siyiphumeze, ke kuya kufuneka ufumane isiqalisi sayo kwimenyu yesicelo sakho okanye kwisiphelo sendlela umyalelo:
mysql-workbench
Ngethuba lokuqala xa sivula i-MySQL Workbench, isikrini esamkelekileyo siya kuvela ngolwazi malunga nesixhobo kunye nokunye.
Apha Siza kuya entlokweni ye-Workbench Preferences eyakhelweyo ukulungisa useto. Ukuvula ukhetho, cofa u-Hlela imenyu, emva koko ukhethe.
Ngaphakathi sinokuhlengahlengisa iiparameter ezinje ngohlobo lweseva ye-MySQL, umbala wefonti, ukugqitywa kwekhowudi kunye nezinye.
Ukuvelisa unxibelelwano olutsha kufuneka ucofe iqhosha "+”Kwaye kuya kuvuleka iwindow apho siza kubeka khona ulwazi ukuze sikwazi ukuqhagamshela kwiziko ledatha lethu.
Banokwenza uvavanyo loqhagamshelo ukuqinisekisa ukuba yonke idatha ichanekile kwiqhosha elithi "uvavanyo lokunxibelelana" ukuba yonke into ichanekile, cofa nje ok.
Ukuba ufuna ukwazi ngakumbi malunga nokusetyenziswa kwesi sixhobo ungacofa Kule khonkco ilandelayo.