Kwinqaku elilandelayo siza kujonga kwi-MySQL 8.0. Namhlanje, iseva yoluntu yase-MySQL yi Inkqubo yolawulo lwedatha simahla, ithandwayo kunye neqonga lomnqamlezo. Inika uyilo olungenakugcinwa lweinjini yolwakhiwo olusinika izixhobo zokudibanisa ezininzi zolwimi kwiinkqubo ezahlukeneyo zolwimi kunye nezinye izinto esizakufumana zifumaneka.
Kule posi siza kubona indlela yokufaka i-MySQL 8.0 kwi-Ubuntu 18.04 Bionic Beaver. Konke oku ngokukhawuleza nangokulula. Ngaphambi kokuya kumanyathelo ambalwa aza kufakelwa ufakelo, kuyathakazelisa ukubona ezinye zeempawu esizibonelelwa yile nguqulo ye-MySQL. Ezi mpawu kunokuboniswana ngazo kwiwebhusayithi esemthethweni. Apho, nabani na oyifunayo, unako funda amanqaku malunga nohlobo I-MySQL 8.0.
Ukufakwa kwe-MySQL 8.0
Yongeza indawo yokugcina
Ngethamsanqa, kukho Indawo yokugcina ye-APT ukufaka iseva ye-MySQL, umxhasi kunye nezinye izinto. Ukuyisebenzisa, kuya kufuneka songeze le ndawo yokugcina i-MySQL kuluhlu lwemithombo yenkqubo yethu. Ukwenza oku, sivula i-terminal (Ctrl + Alt + T) kwaye kuyo siya kubhala oku kulandelayo ukukhuphela iphakheji kwindawo yokugcina izinto. Siza kwenza oku sisebenzisa isixhobo wget.
wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb
Emva koko, siza kufaka iphakheji esiyikhupheleyo ngokuchwetheza kwisiphelo esinye:
sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb
Ngaphambi kokuqala ufakelo, gcinani engqondweni ukuba ngexesha lenkqubo, siya kucelwa ukuba sikhethe uhlobo lweseva ye-MySQL kunye nezinye izinto.
Iseva ye-MySQL 8.0 iya kukhethwa ngokuzenzekelayo. Kuya kufuneka uskrolele ezantsi kukhetho lokugqibela oluthi Kulungile kwaye ucofe u-Enter ukuqhubeka nokucwangciswa kunye nokufakwa kwephakheji.
Faka i-MySQL Server kwi-Ubuntu 18.04
Ngoku siza kuhlaziya uluhlu lwesoftware ekhoyo kwii-repositories esizongezileyo kuluhlu lwethu, kubandakanya indawo yokugcina ye-MySQL esisandula ukuyongeza. Kwisiphelo (Ctrl + Alt + T) sibhala:
sudo apt update
Nje ukuba uhlaziyo lugqityiwe, siza kwenza lo myalelo ulandelayo fakela iseva yoluntu ye-MySQL, umxhasi kunye nezinye iifayile eziyimfuneko:
sudo apt-get install mysql-server
Ngexesha lofakelo, inkqubo iya kusicela ukuba sibhale iphasiwedi yomsebenzisi wengcambu yomncedisi wakho we-MySQL. Kuya kufuneka siyichwetheze kabini kwaye sigqibe ngokucinezela u-Enter.
Ukuqhubeka nofakelo, umyalezo woqwalaselo we Iplagi engqinisisa iserver ye-MySQL. Olunye lokukhetha luya kuboniswa kuthi njengoko kucetyisiwe, kuya kufuneka sicinezele u-Enter kuyo.
Khusela ufakelo lweseva ye-MySQL
Ngokuzenzekelayo, ufakelo lwe-MySQL alukhuselekanga. Ukuyikhusela kuya kufuneka sisebenzise iskripthi sokhuseleko esiza nayo. Siya kucelwa ukuba singenise iphasiwedi yengcambu esiyibeke ngexesha lenkqubo yofakelo. Kuya kufuneka sikhethe nokuba sisebenzise iplagi ye-VALIDATE PASSWORD okanye hayi. Olunye ukhetho oluya kuthi luboniswe kuthi luya kuba nakho ukutshintsha igama eligqithisiweyo esalisekayo ngaphambili.
Emva koko singaphendula ngo-ewe / ya kule mibuzo ilandelayo yezokhuseleko:
- Cima abasebenzisi abangaziwayo? (Cinezela y | Y ewe, naliphi na elinye iqhosha ku-Hayi): y
- Ungavumeli ukungena kweengcambu kude? (Cinezela y | Y ewe, naliphi na elinye iqhosha ku-Hayi): y
- Cima indawo yovavanyo kwaye ungene kuyo? (Cinezela y | Y ewe, naliphi na elinye iqhosha ku-Hayi): y
- Layisha kwakhona iitafile zamalungelo ngoku? (Cinezela y | Y ewe, naliphi na elinye iqhosha ku-Hayi): y
Iskripthi sokhuseleko Singayiqala ngoqwalaselo ngokuchwetheza kwi-terminal (Ctrl + Alt + T):
sudo mysql_secure_installation
Ulawulo lweseva ye-MySQL nge-Systemd
Ku-Ubuntu, emva kokufaka iphakheji, iinkonzo zihlala ziqala ngokuzenzekelayo nje ukuba iphakheji iqulunqwe. Siza kukwazi jonga ukuba iseva ye-MySQL iyasebenza kwaye iyasebenza ngalo myalelo ulandelayo:
sudo systemctl status mysql
Ukuba ngesizathu esithile ayiqali ngokuzenzekelayo, siya kuba noku kulandelayo ukuyalela ukuba uyiqale:
sudo systemctl enable mysql
Ukufikelela kwiqokobhe le-MySQL
Ukugqiba, kufuneka singene kuphela kwigobolondo le-MySQL. Siza kwenza oku ngokuchwetheza lo myalelo ulandelayo kwi-terminal (Ctrl + Alt + T):
sudo mysql -u root -p
Ngaphakathi kweqokobhe esinako qhagamshelana noncedo kwaye siza kubona isikrini ngolu hlobo lulandelayo:
Sawubona,
Ayikhe indibuze igama eligqithisiweyo lengcambu, xa ndifuna ukusebenzisa i-mysql indicela yona, ukuba andiyibonisi (ke bathi kokokuqala) ayindivumeli ukuba ndenze nantoni na.
Ngaphezu koko, umbuzo awusoze uvele ngexesha lofakelo.
I-Mysql imbi kakhulu kune-Terminator, unqumamisa iinkonzo, khipha kwaye ucime yonke into kodwa ukuba uzama i-mysql isephandle. Ukuba, njengokuba kunjalo kwimeko yam, awunakufaka igama eligqithisiweyo lengcambu nangaliphi na ixesha, uya kuba sengxakini, kuba nantoni na oyenzayo, i-mysql iya kulikhumbula elo xabiso ungakhange ulibonise kwaye ayizukuvumela ukuba uqhubeke
Ezi tyikityo zilandelayo bezingalunganga: EXPKEYSIG 8C718D3B5072E1F5 MySQL Release Engineering
Mholo. vavanyo ukuba ubhala i-sudo apt-key adv -keyserver keys.gnupg.net –recv-keys 8C718D3B5072E1F5 kwaye uzama kwakhona ukusombulula ingxaki. Salu2.
maqinaaaaaa
yinto efanayo eyenzeka kum
Ngexesha lofakelo, inkqubo iya kusicela ukuba singenise igama eligqithisiweyo lomsebenzisi wengcambu yeseva yakho ye-MySQL. Kuya kufuneka siyichwetheze kabini kwaye sigqibe ngokucinezela u-Enter.
Khange andibuze ngayo. ?