Uyifaka njani iMySQL kwi-Ubuntu

Kukho iinkqubo ezininzi zolawulo lwesiseko sedatha, kodwa abaninzi bakhetha uFikelelo lweMicrosoft, njengesiqhelo, kuba isuka kuMicrosoft kwaye iyinxalenye yeofisi yayo. Abanye abaninzi, ekubeni ukulawula i-database ngumsebenzi owenziwe ngabantu abanolwazi, bayaqaphela inketho yomthombo ovulekileyo, kwinto endiyibonileyo, ukhetho lweenkampani ezininzi. Apha siza kukufundisa faka i-mysql Ubuntu.

Ukuba sikwiWindows, ukufaka iMySQL ngumsebenzi olula ukuba uyayazi into omawuyifake, kuba kukho iipakethi ezibandakanya yonke into. KwiLinux ayifani, kwaye intsonkothe ​​ngakumbi kuba kuninzi okwenziwa ngelayini zomyalelo. Namhlanje siza kuzama ukucacisa indlela yokufaka i-MySQL kwi-Ubuntu, nangona kunokuthiwa into esiya kuyifaka. Lampokt Linux, Apache, MySQL kunye PHP.

Ngaphambi kokuba uqale

I-MySQL sisixhobo esingenalo ujongano lwegraphical olusebenza kwi-terminal ngomgca womyalelo (CLI). Ukufakela kwayo kulula, kodwa kuphela nge-MySQL kuya kufuneka siqhube yonke imibuzo kwi-terminal. Ukuphucula amava omsebenzisi, kufuneka ufake kwaye uqwalasele phpMyAdmin. Yile nto eyenza izinto zibe nzima kancinci. Ngokuxhomekeke kwindlela eqwalaselwe ngayo, sinokungena phpMyAdmin okanye siya kufumana enye yeempazamo ezininzi enokusibonisa yona.

Kwakhona kubonakala kubalulekile kum ukuba ndikhankanye ukuba oko kuchazwe apha kusebenza ngexesha lokubhala eli nqaku, kwaye ivavanyiwe ku-Ubuntu 22.10. Ukubona ukuba akukho phakheji okanye nantoni na ekhethekileyo, kufuneka isebenze kwiinguqulelo ezidlulileyo kunye nezizayo, kodwa akuqinisekiswanga. Ke, ukuba ubaleka naziphi na iibugs, ndingacebisa ukuba ubuyele kwinto oyenzileyo ukuze ufumane eli nqaku (ukuba awulifumananga kumajelo eendaba ezentlalo): khangela ibug ethile Uphando DuckDuckGo.

Uyifaka njani iMySQL kwi-Ubuntu

Ngokuchazwe ngasentla, masihambe kunye namanyathelo omawulandele ukufaka i-LAMP kunye nephpMyAdmin kwaye senze yonke into isebenze ku-Ubuntu.

1. Ukuqinisekisa ukuba yonke into isexesheni, sihlaziya zonke iipakethe, nokuba zivela kuHlaziyo lweSoftware okanye ngomyalelo sudo apt update && sudo apt upgrade.
2. Njengenyathelo lokuzikhethela, siya kwisikhangeli kwaye sibeke "localhost", siqinisekisa ukususa i-S kwi-HTTPS ukuba iyenzeka. Siza kubona impazamo kuba akukho mncedisi owenza umsebenzi wayo.

4. Siya kwi-terminal kwaye sifake i-A ye-LAMP: Apache.

sudo apt ukufaka apache2

5. Njengelinye inyathelo lokuzikhethela, elingabalulekanga kodwa libonisa ukuba siqhuba kakuhle, sibuyela kwisikhangeli, sibeke "localhost" kwaye siqinisekise ukuba ngoku kuvela into efana nale ilandelayo:

6. Okulandelayo sifaka i-MySQL, iM yeLAMP:

I-sudo ifake i-mysql-server

7. Kwinqanaba elilandelayo, ukuba asinayo, sifaka iP yeLAMP (PHP):

sudo apt ukufaka php

Kwaye ngale nto siya kuba nayo yonke into eyimfuneko ukusebenzisa i-MySQL ku-Ubuntu. Ukuphucula amava omsebenzisi, siyaqhubeka.

Faka iphpMyAdmin kwi-Ubuntu

8. Kwisiphelo, sibhala:

sudo apt ukufaka phpmyadmin

9. Kuya kufika ixesha apho iya kusicela ukuba sisebenzise umncedisi. Sikhetha apache2 ngebar yendawo, emva koko ithebhu kwaye Lungile.

10. Iya kusazisa ukuba kuyimfuneko ukuba nedatha esebenzayo, kwaye ukuba sifuna ukuyilawula nge-dbconfig-eqhelekileyo. Samkela ifestile yokuqala, enganikezeliyo ukhetho oluninzi, kwaye siya kweyesibini, sithi ewe kwaye sibeka igama lokugqitha kwiphpMyAdmin (kabini):

11. Sibuyela kwisikhangeli kwaye songeza "phpmyadmin" kwi "localhost", eya kuba yi-localhost/phpmyadmin.

12. Senza enye isheke: sibeka umsebenzisi ongagqibekanga, oyiphpmyadmin, kunye negama lokugqitha esiye saqwalasela kwinqanaba le-10. Siza kubona ukuba ingena, kodwa asinawo amalungelo.

13. Sivala iseshoni kwiphpMyAdmin.

14. Sibuyela kwi-terminal, bhala sudo -i (okanye sudo su) kwaye ubeke igama eliyimfihlo.
15. Ngoku sibhala i-mysql -u ingcambu -py sibeka igama eliyimfihlo lephpMyAdmin (enye ukusuka kwinqanaba le-10).

16. Akukho nto iseleyo. Kwinqanaba elilandelayo siza kwenza umsebenzisi (1), ukutshintsha i-1234 kwenye igama eligqithisiweyo (ekufuneka lihambe phakathi kokucaphula okukodwa) kunye ubunlog kumsebenzisi wakho, siyinika amalungelo (2) kwaye siyiqale kwakhona (iya kuqinisekiswa ukuba ihambe kakuhle ngomyalezo othi "Umbuzo Kulungile" emva kwentshayelelo nganye):

yenza umsebenzisi 'ubunlog'@'%' ichongwe ngu-'1234'; nika onke amalungelo kwi *.* ukuba 'ubunlog'@'%' enokhetho lwesibonelelo; amalungelo agungxulwayo;

Kwaye kuya kuba konke. Kuhlala kubuyela kwisikhangeli, hlaziya igama lokungena / iphepha lephpmyadmin kwaye uqinisekise ukuba sinokungena kunye nomsebenzisi owenziweyo, kwaye singakwazi ukulawula i-database.

Ukufihla i-database kunye nokutshintsha umxholo

Ngoku siyakwazi ukulawula ugcino-lwazi, sinokufuna ukwenza ngokwethu indlela. Kwiphepha eliphambili sifumana inketho ethi "Umxholo", kwaye kuxhomekeke kwinkqubo yokusebenza apho sinephpMyAdmin efakiweyo, iinketho ezi-3 okanye ezi-4 zingavela. Nangona kungekho maninzi, kukho ezinye iindlela phpmyadmin.net/themes, kwaye, umzekelo, oku kulandelayo yi-BooDark (i-Dark Bootstrap):

Imixholo kufuneka ikhululwe kwaye ibeke ifolda ngaphakathi kwifolda yemixholo eya kuba ngaphakathi kwifolda yephpmyadmin (ku-Ubuntu iqhelekile /usr/share/phpmyadmin/themes).

Kwelinye icala, ukuba uqaphele, uya kube uqaphele ukuba ngasekhohlo kwesikrini se-BooDark kukho ugcino lwedatha olumbalwa kunomfanekiso wekhusi ongentla. Kungenxa yokuba zifihliwe. Ithiyori ithi banjalo oovimba beenkcukacha abaneefayile zoqwalaselo kwaye ukuba kufanelekile ukuba ungachukumisi nantoni na apho, kodwa sinokuzifihla, ukuba yonke into iya kuqhubeka isebenza njengaxa ibonakala.

Ukuzifihla, kwaye ngaloo ndlela sisebenze kuphela ngeedatha zethu, sinokuvula iiFayile, siye kwezinye iindawo, faka ingcambu ye-hard drive yethu, shaya iglasi yokukhulisa, khangela iphpmyadmin, faka ifolda kwaye uvule ifayile ye-config.inc. .php. Ekugqibeleni unokongeza umgca ngolu hlobo lulandelayo:

$cfg['Servers'][$i]['hide_db'] = '^mysql|sys|phpmyadmin|performance_schema|information_schema$';

Ukusuka apha ngasentla, sisebenzisa i ukhetho lokufihla oovimba beenkcukacha (hide_db) kwaye ibonise ukuba yeyiphi esingafuniyo ukuyibona. Umtya uqala kwaye uphela ngesicatshulwa esisodwa; ngaphakathi kwayo, isimboli sokuqala kufuneka sibe "^" kunye neyokugqibela "$"; kwaye ngaphakathi kukho oovimba beenkcukacha abahlulwe ngu "|". Ukuba uqaphela into engaqhelekanga, nangona akufanelekanga, unga "gqabaza" loo mgca ngokubeka izikhewu ezibini (//) phambi kwayo okanye uyibeke phakathi /*…*/.

Ukulawula oovimba beenkcukacha ngeLibreOffice Base

Njengoko sichazile ekuqaleni kweli nqaku, yintoni eyimfuneko ngokwenene ukusebenzisa i-MySQL ku-Ubuntu yenziwa malunga namanyathelo asi-7. Ukuba ke silawula nge-terminal, akukho nto yimbi efunekayo. NgephpMyAdmin siya kuyenza nge-graphical interface, enye ehlala ifumaneka kwiinkonzo zokusingatha, ngoko kuyafaneleka ukuqhelana nayo ngaphambi kwayo nayiphi na enye into. Kodwa unokulawula i-database kunye nenye isoftware.

Umzekelo, njengokuba sinoFikelelo kuMicrosoft 365, LibreOffice inesiseko. Kwaye ewe, sinokuqhagamshela kwi-database ye-MySQL ene-Base, uhlobo lwe. Nangona kuyinyani ukuba sinokongeza iitafile kwisiseko sedatha, kuyinyaniso ukuba akusivumeli ukuba sihlele iitafile esizenzileyo kwiphpMyAdmin, ngoko kuyafaneleka ukuba, ukuba siza kusebenza kunye ne-Base, thina. yenza i-database nge-MySQL, masiqhagamshele kuyo kwaye emva koko silawule iitafile kwi-Base. Ngokubhekiselele kwi SQL imibuzo, kuphela abo ukufumana ulwazi bavumelekile; ukuba sifuna ukwenza utshintsho, kufuneka siyenze ngojongano lomzobo.

Ukwenza oku, xa sele siyifakile yonke i-LAMP (iLinux sele ikhona, i-Apache, i-MySQL kunye ne-PHP), kufuneka silandele la manyathelo:

1. Sivula iLibreOffice Base. siya kuboniswa iwizard.
2. Kwifestile yokuqala, sikhetha "Xhuma kwisiseko sedatha ekhoyo", yehla imenyu kwaye ukhethe "MySQL / MariaDB".

3. Kwifestile elandelayo, sikhetha "Qhagamshela ngokuthe ngqo (nge-MariaDB C isinxibelelanisi)" kwaye ucofe ngokulandelayo:

4. Emva koko, sibeka igama lesiseko sedatha kunye nomncedisi. Isiseko sedatha siya kuba yile sifuna ukudibanisa nayo, kwaye umncedisi ngumgcini wendawo.

5. Emva kokuchofoza ngokulandelayo, siya kubeka igama lomsebenzisi kwaye, kunye nebhokisi ethi "Iphasiwedi efunekayo" ihlolwe, siya kucofa uvavanyo lokudibanisa.

6. Iya kusibuza igama eligqithisiweyo (lomsebenzisi we-MySQL), siyibeka. Ukuba yonke into ihamba kakuhle, siya kubona umyalezo oqinisekisa ukuba uxhumano luphumelele.
7. Sicofa ngokulandelayo kwaye siza kubona ifestile yokugqibela apho kukufanelekile ukushiya izinto ngokungagqibekanga kwaye ucofe ku "Gqiba".

Oku kuya kusivumela ukuba sifikelele kwisiseko sedatha ukusuka kwi-LibreOffice Base, kodwa ndingayisebenzisa kuphela ukuba kukho into yasekuhlaleni efunekayo kunye nolawulo olusisiseko. Kwakhona ukuba ukhetha ukusebenza ngento ebonakala ingcono kwi-desktop yakho, efana ne-GTK ku-Ubuntu okanye i-Qt kwezinye iimeko zegraphical.

Phakathi kwezinye iinketho, enye yeentandokazi DBever, enomthombo ovulekileyo wokhetho loLuntu, kodwa ukusebenzisa enye okanye enye kufuneka ibe yinto yokunambitha. Oko kwaye mhlawumbi emsebenzini bacela ukuba uhambe kakuhle kwi-phpMyAdmin.

Nantsi indlela onokuthi uyifake ngayo i-MySQL ku-Ubuntu kwaye ulawule i-database nge-graphical interface evela ku-Ubuntu.