Ungayifaka kanjani i-MySQL ku-Ubuntu

Kunezinhlelo ezimbalwa zokuphatha i-database, kodwa abaningi bakhetha i-Microsoft Access, njengenjwayelo, ngoba ivela ku-Microsoft futhi iyingxenye yehhovisi layo. Abanye abaningi, njengoba ukuphatha imininingwane yolwazi kuwumsebenzi owenziwe abantu abanolwazi, bayaqaphela inketho yomthombo ovulekile, kulokho engikubonile, ukukhetha kwezinkampani eziningi. Lapha sizokufundisa faka i-mysql ku-Ubuntu.

Uma siku-Windows, ukufaka i-MySQL kuwumsebenzi olula uma wazi ukuthi yini okufanele uyifake, njengoba kukhona amaphakheji ahlanganisa yonke into. Ku-Linux akufani, futhi kuyinkimbinkimbi kakhulu ngoba okuningi kwenziwa ngemigqa yomyalo. Namuhla sizozama ukuchaza indlela yokufaka i-MySQL ku-Ubuntu, nakuba kungase kushiwo ukuthi esizokufaka kuzoba LAMPokungukuthi i-Linux, i-Apache, i-MySQL ne-PHP.

Ngaphambi kokuthi uqale

I-MySQL iyithuluzi elingenayo i-interface yesithombe esebenza kusukela ku-terminal ngomugqa womyalo (CLI). Ukufakwa kwayo kulula, kepha nge-MySQL kuphela lapho kuzodingeka senze yonke imibuzo evela kutheminali. Ukuze uthuthukise ulwazi lomsebenzisi, kufanele futhi ufake futhi ulungiselele phpMyAdmin. Yilokhu okwenza izinto zibe nzima kancane. Kuye ngokuthi icushwe kanjani, singangena phpMyAdmin noma sizothola elinye lamaphutha amaningi elingasibonisa lona.

Kuphinde kubonakale kubalulekile kimina ukusho ukuthi okuchazwe lapha kusebenza ngesikhathi sokubhala lesi sihloko, futhi ihlolwe ku-Ubuntu 22.10. Ngokubona ukuthi awekho amaphakheji nanoma yini ekhethekile, kufanele isebenze ezinguqulweni ezedlule nezizayo, kodwa akuqinisekisiwe. Ngakho-ke, uma ungena kunoma yiziphi izimbungulu, ngingancoma ukuthi ubuyele kulokho okwenzile ukuze uthole lesi sihloko (uma ungasitholanga ezinkundleni zokuxhumana): sesha iphutha elithile -Google I-DuckDuckGo.

Ungayifaka kanjani i-MySQL ku-Ubuntu

Ngokuchazwe ngenhla, ake sihambe nezinyathelo okufanele sizilandele ukuze ufake I-LAMP kanye ne-phpMyAdmin futhi senze konke kusebenze ku-Ubuntu.

1. Ukuqinisekisa ukuthi yonke into isesikhathini, sibuyekeza wonke amaphakheji, kusuka ku-Software Update noma ngomyalo sudo apt update && sudo apt upgrade.
2. Njengesinyathelo sokuzikhethela, siya esipheqululini bese sibeka okuthi "localhost", senze isiqiniseko sokususa i-S ku-HTTPS uma ikwenza. Sizobona iphutha ngoba asikho iseva eyenza umsebenzi wayo.

4. Siya esigungwini bese sifaka i-A yeLAMP: Apache.

I-sudo ifaka ukufaka i-apache2

5. Njengesinye isinyathelo sokuzikhethela, esingabalulekile kodwa esibonisa ukuthi senza kahle, sibuyela esipheqululini, sibeke "localhost" futhi siqinisekise ukuthi manje kuvela okuthile okufana nokulandelayo:

6. Okulandelayo sifaka i-MySQL, i-M ye-LAMP:

Sudo kufanele ufake i-mysql-server

7. Esinyathelweni esilandelayo, uma singenayo, sifaka i-P yeLAMP (PHP):

sudo apt ukufaka php

Futhi ngalokhu sizoba nakho konke okudingekayo ukusebenzisa i-MySQL ku-Ubuntu. Ukuze sithuthukise ulwazi lomsebenzisi, siyaqhubeka.

Faka i-phpMyAdmin ku-Ubuntu

8. Esigungwini, sibhala:

sudo apt ukufaka phpmyadmin

9. Kuzofika isikhathi lapho izosicela ukuthi sisebenzise iseva. Sikhetha i-apache2 ngebha yesikhala, bese sithebhu futhi KULUNGILE.

10. Izosazisa ukuthi kuyadingeka ukuba nesizindalwazi esisebenzayo, futhi uma sifuna ukuyiphatha nge-dbconfig-common. Samukela iwindi lokuqala, elinganikezi izinketho eziningi, futhi siya kwesibili, sithi yebo futhi sibeka iphasiwedi ku-phpMyAdmin (kabili):

11. Sibuyela emuva kusiphequluli bese sengeza okuthi “phpmyadmin” ku-“localhost”, okungaba localhost/phpmyadmin.

12. Senza esinye isheke: sibeka umsebenzisi ozenzakalelayo, okuyi-phpmyadmin, kanye nephasiwedi esiyilungisile esinyathelweni se-10. Sizobona ukuthi ingena, kodwa asinawo amalungelo.

13. Sivala iseshini ku-phpMyAdmin.

14. Sibuyela kutheminali, bhala sudo -i (noma sudo su) bese ufaka iphasiwedi yethu.
15. Manje sibhala i-mysql -u root -py sibeka iphasiwedi ye-phpMyAdmin (leyo esuka kusinyathelo se-10).

16. Akusekho lutho. Esinyathelweni esilandelayo sizodala umsebenzisi (1), sishintsha u-1234 kwenye iphasiwedi (okumele ihambe phakathi kwezingcaphuno ezilodwa) futhi ubunlog kumsebenzisi wakho, siyinika amalungelo (2) futhi siyiqalise kabusha (kuzoqinisekiswa ukuthi ihambe kahle ngomlayezo othi "Umbuzo KULUNGILE" ngemva kwesingeniso ngasinye):

dala umsebenzisi 'ubunlog'@'%' ikhonjwe ngu-'1234'; nika wonke amalungelo ku-*.* ukuze 'ubunlog'@'%' enenketho yesibonelelo; amalungelo okushisa;

Futhi kungaba kuphela lokho. Kusele ukubuyela esipheqululini, uvuselele ikhasi lokungena/phpmyadmin futhi uqinisekise ukuthi singangena nomsebenzisi odaliwe, nokuthi singaphatha imininingwane.

Ukufihla imininingo egciniwe kanye nokushintsha itimu

Manje njengoba sesingakwazi ukuphatha izingosi zolwazi, singase sifune ukwenza ngendlela yethu. Ekhasini eliyinhloko sithola inketho ethi "Itimu", futhi kuye ngesistimu yokusebenza lapho sine-phpMyAdmin efakiwe, izinketho ezi-3 noma ezi-4 zingavela. Nakuba zingekho eziningi, zikhona ezinye izindlela phpmyadmin.net/themes, futhi, isibonelo, okulandelayo yi-BooDark (Dark Bootstrap):

Izindikimba kufanele zivulwe futhi zifakwe ifolda ngaphakathi kwefolda yezingqikithi ezizoba ngaphakathi kwefolda ye-phpmyadmin (ku-Ubuntu kuvame ukuthi /usr/share/phpmyadmin/themes).

Ngakolunye uhlangothi, uma uqaphele, uzobe uqaphele ukuthi kwesokunxele sesithombe-skrini se-BooDark kunemininingwane yolwazi embalwa kunesithombe-skrini esingenhla. Lokho kungenxa yokuthi zifihliwe. Ithiyori ithi banjalo imininingwane egciniwe enamafayela okumisa nokuthi kufanelekile ukuthi singathinti lutho lapho, kodwa singabafihla, ukuthi konke kuzoqhubeka nokusebenza njengalapho kubonakala.

Ukuze uzifihle, futhi ngaleyo ndlela usebenze kuphela ngezinqolobane zethu zolwazi, singavula Amafayela, siye kwezinye izindawo, faka impande ye-hard drive yethu, shaya ingilazi yokukhulisa, sesha i-phpmyadmin, faka ifolda bese uvula ifayela le-config.inc. .php. Ekugcineni ungangeza umugqa ofana nokulandelayo:

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

Kusukela ngenhla, sisebenzisa i- inketho yokufihla imininingwane (hide_db) futhi ekhombisa ukuthi yiziphi esingafuni ukuzibona. Iyunithi yezinhlamvu iqala futhi iphethe ngezingcaphuno ezilodwa; ngaphakathi kwayo, uphawu lokuqala kufanele kube "^" futhi elokugcina "$"; futhi ngaphakathi kukhona isizindalwazi esihlukaniswe ngokuthi "|". Uma kwenzeka ubona okuthile okungajwayelekile, nakuba kungafanele, "ungaphawula" lowo mugqa ngokubeka ama-slash amabili (//) ngaphambi kwawo noma ukubeke phakathi /*…*/.

Ukuphatha imininingo egciniwe nge-LibreOffice Base

Njengoba sichazile ekuqaleni kwalesi sihloko, okudingeka ngempela ukusebenzisa i-MySQL ku-Ubuntu kwenziwa ngezinyathelo ezingaba ngu-7. Uma ngabe sesiphatha nge-terminal, akukho okunye okudingekayo. Nge-phpMyAdmin sizokwenza nge-graphical interface, evame ukutholakala ezinsizeni zokubamba, ngakho-ke kufanelekile ukuyijwayela ngaphambi kwanoma yini enye. Kodwa ungakwazi futhi ukuphatha database nezinye isofthiwe.

Isibonelo, njengoba sinokufinyelela ku-Microsoft 365, I-LibreOffice ine-Base. Futhi yebo, singaxhuma kusizindalwazi se-MySQL nge-Base, uhlobo. Nakuba kuyiqiniso ukuthi singakwazi ukwengeza amatafula kusizindalwazi, kuyiqiniso futhi ukuthi akusivumeli ukuthi sihlele amatafula esiwadalile kusuka ku-phpMyAdmin, ngakho-ke kuyafaneleka ukuthi, uma sizosebenza ne-Base, dala isizindalwazi nge-MySQL, masixhume kuyo bese siphatha amatafula ku-Base. Ngokuqondene ne Imibuzo ye-SQL, leyo yokuthola ulwazi kuphela evunyelwe; uma sifuna ukwenza izinguquko, kufanele sikwenze ngokusebenzisa i-graphical interface.

Ukwenza lokhu, uma sesiyifakile yonke i-LAMP (i-Linux isivele ikhona, i-Apache, i-MySQL ne-PHP), kufanele silandele lezi zinyathelo:

1. Sivula i-LibreOffice Base. Sizoboniswa umsizi.
2. Efasiteleni lokuqala, sikhetha "Xhuma ku-database ekhona", yehlisa imenyu bese ukhetha "MySQL/MariaDB".

3. Ewindini elilandelayo, sikhetha "Xhuma ngqo (ngesixhumi se-MariaDB C)" bese uchofoza okulandelayo:

4. Okulandelayo, sibeka igama le-database kanye neseva. I-database kuzoba yileyo esifuna ukuxhuma kuyo, futhi iseva i-localhost.

5. Ngemva kokuchofoza okulandelayo, sizobeka igama lomsebenzisi futhi, ngebhokisi elithi "Iphasiwedi Edingekayo" lihloliwe, sizochofoza ukuhlola uxhumano.

6. Izosicela iphasiwedi (yomsebenzisi we-MySQL), siyayibeka. Uma konke kuhamba kahle, sizobona umlayezo oqinisekisa ukuthi ukuxhumana kube yimpumelelo.
7. Sichofoza okulandelayo futhi sizobona iwindi lokugcina lapho kufanelekile ukushiya izinto ngokuzenzakalelayo bese uchofoza "Qeda".

Lokhu kuzosivumela ukuthi sifinyelele ku-database kusuka ku-LibreOffice Base, kodwa ngingayisebenzisa kuphela uma kukhona okungokwemvelo okudingekayo kanye nokuphathwa okuyisisekelo. Futhi uma ukhetha ukusebenza ngokuthile okubukeka kangcono kudeskithophu yakho, njenge-GTK ku-Ubuntu noma i-Qt kwezinye izindawo ezinemifanekiso.

Phakathi kwezinye izinketho, enye yezintandokazi I-DBeaver, enenketho yomphakathi evulekile, kodwa ukusebenzisa eyodwa noma enye kufanele kube yindaba yokunambitha. Lokho nokuthi mhlawumbe emsebenzini bakucela ukuthi uhambe kahle ku-phpMyAdmin.

Futhi nansi indlela ongafaka ngayo i-MySQL ku-Ubuntu futhi uphathe imininingwane yolwazi nge-graphical interface evela ku-Ubuntu.