Otu esi etinye MySQL 8.0 na Rocky Linux na AlmaLinux


Edere ya na C, MySQL bụ ebe mepere emepe, obe-ikpo okwu, yana otu n'ime Sistemụ Njikwa Database Management (RDMS) na-ejikarị eme ihe. Ọ bụ akụkụ dị mkpa nke nchịkọta LAMP ma bụrụ usoro njikwa nchekwa data ama ama na ntanetị weebụ, nyocha data, na ngwa eCommerce iji kwuo ole na ole.

Ntọhapụ kwụsiri ike ugbu a bụ MySQL 8.0.25 wee wepụta ya na Mee 11, 2021. Isi isi ihe dị na mwepụta ọhụrụ gụnyere:

  • Nkwalite InnoDB & XML.
  • Akwụkwọ ọkọwa okwu data azụmahịa.
  • Nkwado emelitere maka data JSON Native yana ọrụ ụlọ ahịa akwụkwọ.
  • Nkwupụta okwu tebụl nkịtị.
  • Ọrụ Windows.
  • Mmalite ndekọ mperi dị ka nọmba njehie & mbelata okwu ọnụ.

Na ọtụtụ ihe ndị ọzọ. Ị nwere ike ịlele ndetu ntọhapụ maka mkpuchi zuru oke nke njirimara na nkwalite niile.

N'ime ntuziaka a, anyị na-enyocha otu esi etinye MySQL na Rocky Linux na AlmaLinux.

Kwụpụ 1: Melite Linux Rocky

Mgbe ị na-etinye ngwungwu ngwanrọ, a na-atụ aro ka ịmalite site na mmelite nke ngwugwu sistemụ. Nke a, n'ọnọdụ ụfọdụ, na-akwalitekwa kernel ebe ọ ga-achọgharịgharị.

Ya mere, na ahịrị iwu, mebie iwu a ka imelite kernel na ngwugwu sistemụ:

$ sudo dnf update

Kwụpụ 2: Kwado MySQL Upstream Module

N'ịga n'ihu, anyị kwesịrị ime ka MySQL 8.0 modul nke ebe nchekwa AppStream nyere. Ugbu a, nke a bụ naanị MySQL modul nke enyere ma ị nwere ike nyochaa nke a site na iji iwu a:

$ sudo dnf module list mysql

Iji mee ka iyi modul MySQL nwee ike, mee iwu:

$ sudo dnf module enable mysql:8.0

Kwụpụ 3: Wụnye MySQL 8.0 na Rocky Linux

Site na modul nyeere, wụnye MySQL 8.0 na Rocky Linux dị ka ndị a:

$ sudo dnf install @mysql

Kwụpụ 4: Kwado ma malite MySQL

Iji mee ihe ọ bụla na sava MySQL, anyị kwesịrị ibu ụzọ malite ọrụ ahụ. Mana nke mbụ, ka anyị mee ya ka ọ malite na oge buut dị ka ndị a:

$ sudo systemctl enable mysqld

Mgbe ahụ malite MySQL daemon.

$ sudo systemctl start mysqld 

Ị nwere ike ịchọpụta na MySQL na-agba ọsọ site na ime:

$ sudo systemctl status mysqld 

Kwụpụ 5: Chekwaa MySQL na Rocky Linux

Nzọụkwụ ikpeazụ bụ ịchekwa ihe nkesa nchekwa data MySQL arụnyere. Gịnị kpatara? ị nwere ike ịjụ. Ihe kpatara ya bụ na site na ndabara, MySQL na-abịa na ntọala ndabara nke jupụtara na loopholes nke ndị hackers nwere ike irigbu. Dị ka nke a, anyị kwesịrị imesi ya ike site na iji edemede mysql_secure_installation.

$ sudo mysql_secure_installation

Mgbe emechara edemede ahụ, a ga-akpali gị iji VALIDATE_PASSWORD ngwa mgbakwunye nke na-ekpebi ọkwa ike okwuntughe ma na-ahapụ ndị ọrụ ka ha guzobe naanị okwuntughe siri ike.

Iji melite ngwa mgbakwunye, pịnye Y wee pịa ENTER. Ngwa mgbakwunye na-enye ọkwa amụma okwuntughe atọ bụ: LOW, MEDIUM & IKE.

Pịnye 2 maka amụma okwuntughe siri ike wee pịa ENTER.

Na-esote, jide n'aka na ịtọ ntọala paswọọdụ MySQL siri ike dịka ọkwa paswọọdụ ahọpụtara.

Ngwa mgbakwunye na-enye atụmatụ nke ike okwuntughe, na nke a, 100. Nke a na-egosi na anyị emejuwo ike okwuntughe chọrọ nke chọrọ paswọọdụ siri ike inwe opekempe nke mkpụrụedemede 8 nke kwesịrị ịbụ ụdị dị iche iche nke ọnụọgụ, okwu agwakọta, na agwa pụrụ iche.

Iji gaa n'ihu na paswọọdụ atọrọ, pịa ‘Y’ ka ịga n’ihu. Ma ọ bụghị ya, pịa ‘n’ ka ịlaghachi azụ wee mee mgbanwe ndị achọrọ.

Maka mkpali ndị fọdụrụ, pịa ‘Y’ iji wepụ ndị ọrụ na-amaghị aha, gbochie onye ọrụ mgbọrọgwụ ịbanye n'ime ime, wee wepụ nchekwa data ule nke a ga-ehichapụ tupu ịbanye na ebe mmepụta ihe.

Kwụpụ 6: Jikọọ na MySQL na Rocky Linux

Ozugbo emechara, jiri onye ahịa MySQL jikọọ na nchekwa data dị ka egosiri. Wepụta paswọọdụ mgbọrọgwụ enyere.

$ sudo mysql -u root -p

Ị nwere ike kwado ụdị ahụ site na ịme ajụjụ a:

mysql>  SELECT VERSION ();

Ịwụnye nchekwa data MySQL na Rocky Linux ma ọ bụ AlmaLinux bụ usoro dị mfe ma kwụ ọtọ. Ọ dịghị mkpa ịgbakwunye ebe nchekwa ndị ọzọ ebe ọ bụ na ebe nchekwa AppStream enyela MySQL 8.0 modul iyi.