Otu esi etinye MySQL 8.0 na Ubuntu 18.04

Ihe nkesa obodo MySQL bụ isi mmalite mepere emepe n'efu, sistemụ nchekwa data ama ama na cross-platform. Ọ na-akwado ma SQL na NoSQL, ma nwee ihe nrụpụta injin nchekwa pluggable. Na mgbakwunye, ọ na-abịa na ọtụtụ njikọ nchekwa data maka asụsụ mmemme dị iche iche, na-enye gị ohere ịmepụta ngwa site na iji asụsụ ọ bụla ama ama, yana ọtụtụ atụmatụ ndị ọzọ.

Ọ nwere ọtụtụ ihe eji eme ihe n'okpuru nchekwa akwụkwọ, igwe ojii, sistemụ nnweta dị elu, IoT (Internet of Things), hadoop, nnukwu data, nkwakọba data, LAMP ma ọ bụ ngwugwu LEMP maka ịkwado weebụsaịtị/ngwa dị elu na ọtụtụ ndị ọzọ.

N'isiokwu a, anyị ga-akọwa ntinye ọhụrụ nke MySQL 8.0 nchekwa data usoro na Ubuntu 18.04 Bionic Beaver. Tupu anyị abanye na usoro nrụnye n'ezie, ka anyị lelee nchịkọta nke:

• Ebe nchekwa data na-etinye akwụkwọ ọkọwa okwu azụmahịa azụmahịa.
• Na-abịa na nkwado nkwupụta Atomic DDL.
• Enwere nchekwa na njikwa akaụntụ.
• Mmalite na njikwa akụrụngwa.
• Ọtụtụ nkwalite InnoDB.
• Ụdị mkpọchi ndabere ọhụrụ.
• Nhazi mkpụrụedemede agbanweela ka ọ bụrụ utf8mb4 sitere na latin1.
• Mkwalite JSON ole na ole.
• Na-abịa na nkwado okwu oge niile site na iji Ngwa Mba Nile maka Unicode (ICU).
• Ndekọ mperi ọhụrụ nke na-eji nhazi akụrụngwa MySQL ugbu a.
• Nkwalite na MySQL replication.
• Na-akwado okwu tebụl nkịtị (ma ndị na-abụghị ndị na-emegharị emegharị ma na-emegharịgharị).
• nwere ihe ebuli elu.
• Ọrụ mpio mgbakwunye na ndị ọzọ.

Kwụpụ 1: Tinye MySQL Apt Repository

Ọ dabara nke ọma, enwere ebe nchekwa APT maka ịwụnye ihe nkesa MySQL, onye ahịa na ihe ndị ọzọ. Ịkwesịrị ịgbakwunye ebe nchekwa MySQL a na ndepụta isi mmalite nke sistemụ gị; malite site na nbudata ngwungwu nchekwa site na iji ngwa wget site na ahịrị iwu.

$ wget -c https://repo.mysql.com//mysql-apt-config_0.8.13-1_all.deb 

Wee tinye ngwungwu nchekwa MySQL site na iji iwu dpkg na-esonụ.

$ sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb 

Rịba ama na na usoro ntinye ngwugwu, a ga-akpali gị ịhọrọ ụdị nkesa MySQL na ihe ndị ọzọ dị ka ụyọkọ, ọba akwụkwọ ndị ahịa na-ekekọrịta, ma ọ bụ MySQL workbench nke ịchọrọ ịhazi maka nrụnye.

Ụdị ihe nkesa MySQL mysql-8.0 ga-ahọpụta onwe ya, wee pịgharịa gaa na nhọrọ ikpeazụ Ok wee pịa [Tinye] iji mechaa nhazi na ntinye nke ngwugwu ntọhapụ, dị ka egosiri na nseta ihuenyo.

Kwụpụ 2: Wụnye MySQL Server na Ubuntu 18.04

Na-esote, budata ozi ngwungwu kachasị ọhụrụ site na ebe nchekwa niile ahaziri, gụnyere ebe nchekwa MySQL agbakwunyere nso nso a.

$ sudo apt update

Wee mee iwu a ka ịwụnye ngwugwu maka sava obodo MySQL, onye ahịa na faịlụ nkịtị nchekwa data.

$ sudo apt-get install mysql-server

Site na usoro nrụnye, a ga-ajụ gị ka itinye paswọọdụ maka onye ọrụ mgbọrọgwụ maka ihe nkesa MySQL gị, tinyegharịa paswọọdụ iji kwado ya wee pịa [Tinye].

Na-esote, ozi nhazi nhazi ihe nkesa MySQL ga-apụta, gụọ ya wee jiri akụ ziri ezi họrọ OK wee pịa [Tinye] ka ịga n'ihu.

Mgbe nke ahụ gasịrị, a ga-agwa gị ka ịhọrọ ngwa mgbakwunye njirimara nke ndabara ị ga-eji, wee jiri akụ ziri ezi họrọ OK wee pịa [Enter] iji mezue nhazi ngwugwu.

Kwụpụ 3: Chekwaa nwụnye MySQL Server

Site na ndabara, nrụnye MySQL enweghị nchekwa. Iji chekwaa ya, mee edemede nche nke na-abịa na ngwungwu ọnụọgụ abụọ. A ga-ajụ gị ka itinye mgbọrọgwụ paswọọdụ ị debere n'oge usoro nrụnye. Họrọkwa ma ị ga-eji VALIDATE PASSWORD ngwa mgbakwunye ma ọ bụ na ị gaghị.

Ị nwekwara ike ịgbanwe mgbọrọgwụ okwuntughe ị debere na mbụ (dịka anyị mere na ihe atụ a). Wee tinye ee/y na ajụjụ nchekwa ndị a:

• Wepu ndị ọrụ amaghị aha? (Pịa y|Y maka Ee, igodo ọ bụla ọzọ maka Mba) : y
• Kwepu nbanye mgbọrọgwụ n'ime oge? (Pịa y|Y maka Ee, igodo ọ bụla ọzọ maka Mba) : y
• Wepu nchekwa data nnwale wee nweta ya? (Pịa y|Y maka Ee, igodo ọ bụla ọzọ maka Mba) : y
• Bugharịa tebụl ihe ùgwù ugbu a? (Pịa y|Y maka Ee, igodo ọ bụla ọzọ maka Mba) : y

Mepee edemede ahụ site n'inye iwu na-esonụ.

$ sudo mysql_secure_installation

Iji chekwaa ihe nkesa MySQL gị, gụọ akụkọ anyị 12 MySQL/MariaDB Security Best Practices maka Linux.

Nzọụkwụ 4: Ijikwa MySQL Server site Systemd

Na Ubuntu, mgbe ị wụnye ngwugwu, a na-amalitekarị ọrụ (s) na-akpaghị aka ozugbo ahaziri ngwugwu. Ị nwere ike ịlele ma ọ bụrụ na ihe nkesa MySQL dị na-eji iwu na-esonụ.

$ sudo systemctl status mysql

Ọ bụrụ n'ihi otu ihe ma ọ bụ nke ọzọ, ọ bụghị na-amalite na-akpaghị aka, jiri iwu dị n'okpuru ebe a malite ma mee ka ọ malite na oge buut usoro, dị ka ndị a.

$ sudo systemctl status mysql
$ sudo systemctl enable mysql

Kwụpụ 5: Wụnye ngwaahịa na akụrụngwa MySQL ọzọ

Na mgbakwunye, ị nwere ike iwunye mgbakwunye MySQL nke ị chere na ị chọrọ iji soro sava ahụ rụọ ọrụ, dị ka mysql-workbench-community, libmysqlclient18 na ọtụtụ ndị ọzọ.

$ sudo apt-get update
$ sudo apt-get install mysql-workbench-community libmysqlclient18

N'ikpeazụ, iji nweta MySQL shei, nye iwu na-esonụ.

$ sudo mysql -u root -p

Maka ozi ndị ọzọ, gụọ MySQL 8.0 Notes Release.

Ọ bụ ya! N'isiokwu a, anyị akọwala otu esi etinye MySQL 8.0 na Ubuntu 18.04 Bioni Beaver. Ọ bụrụ na ị nwere ajụjụ ọ bụla ma ọ bụ echiche ị ga-ekekọrịta, jiri ụdị nkọwa dị n'okpuru ebe a iru anyị.