Yadda ake Sanya MySQL 8.0 akan Rocky Linux da AlmaLinux

An rubuta a cikin C, MySQL buɗaɗɗen tushe ne, dandamalin giciye, kuma ɗayan mafi yawan amfani da Tsarin Gudanar da Bayanan Bayanai (RDMS). Yana da wani muhimmin sashi na tarin LAMP kuma sanannen tsarin sarrafa bayanai ne a cikin tallan gidan yanar gizo, nazarin bayanai, da aikace-aikacen eCommerce don ambaton kaɗan.

Sakin kwanciyar hankali na yanzu shine MySQL 8.0.25 kuma an sake shi a kan Mayu 11, 2021. Mahimman bayanai na sabon sakin sun haɗa da:

InnoDB & Haɓaka XML.
Kamus ɗin bayanan ma'amala.
Ingantattun tallafi don bayanan JSON na asali da ayyukan kantin sayar da takardu.
Maganin Tebu na gama gari.
Ayyukan Windows.
Kuskuren inganta ayyukan log kamar kuskuren ƙididdigewa & rage yawan magana.

Da dai sauransu. Kuna iya duba bayanin kula don cikakken ɗaukar hoto na duk fasali da haɓakawa.

A cikin wannan jagorar, mun bincika yadda ake shigar MySQL akan Rocky Linux da AlmaLinux.

Mataki 1: Sabunta Rocky Linux

Lokacin shigar da fakitin software, koyaushe ana ba da shawarar farawa tare da sabunta fakitin tsarin. Wannan, a wasu lokuta, kuma yana haɓaka kernel yayin da ake buƙatar sake yi.

Don haka, akan layin umarni, aiwatar da umarni mai zuwa don sabunta kernel da fakitin tsarin:

$ sudo dnf update

Mataki 2: Kunna MySQL Upstream Module

Motsawa tare, muna buƙatar kunna tsarin MySQL 8.0 wanda aka samar ta wurin ajiyar AppStream. A halin yanzu, wannan shine kawai tsarin MySQL wanda aka bayar kuma zaku iya tabbatar da wannan ta hanyar aiwatar da umarnin:

$ sudo dnf module list mysql

Don kunna rafin module na MySQL, gudanar da umarni:

$ sudo dnf module enable mysql:8.0

Mataki 3: Shigar MySQL 8.0 akan Rocky Linux

Tare da tsarin da aka kunna, shigar da MySQL 8.0 a cikin Rocky Linux kamar haka:

$ sudo dnf install @mysql

Mataki 4: Kunna kuma Fara MySQL

Don yin kowane ayyuka tare da uwar garken bayanan MySQL, muna buƙatar fara sabis ɗin da farko. Amma da farko, bari mu ba shi damar farawa akan lokacin taya kamar haka:

$ sudo systemctl enable mysqld

Sannan fara MySQL daemon.

$ sudo systemctl start mysqld

Kuna iya tabbatar da MySQL yana gudana ta aiwatarwa:

$ sudo systemctl status mysqld

Mataki 5: Tabbatar da MySQL a cikin Rocky Linux

Mataki na ƙarshe shine tabbatar da sabar bayanan MySQL da aka shigar kawai. Me yasa? kuna iya tambaya. Dalili kuwa shine ta hanyar tsohuwa, MySQL yana zuwa tare da saitunan tsoho waɗanda ke ɗauke da madauki waɗanda hackers za su iya amfani da su. Don haka, muna buƙatar taurara ta ta hanyar gudanar da rubutun mysql_secure_installation.

$ sudo mysql_secure_installation

Lokacin da aka aiwatar da rubutun, za a sa ku yi amfani da plugin VALIDATE_PASSWORD wanda ke ƙayyade matakin ƙarfin kalmar sirri kuma yana ba masu amfani damar saita kalmomin shiga masu ƙarfi kawai.

Don saita plugin ɗin, Rubuta Y kuma danna ENTER. Plugin yana samar da matakan manufofin kalmar sirri guda 3 wato: LOW, MEDIUM & KARFI.

Rubuta 2 don manufar kalmar sirri mai ƙarfi kuma latsa ENTER.

Na gaba, tabbatar da saita kalmar sirri mai ƙarfi ta MySQL daidai da matakin kalmar sirri da aka zaɓa.

Plugin yana ba da kimanta ƙarfin kalmar sirri, a wannan yanayin, 100. Wannan yana nuna cewa mun gamsu da buƙatar ƙarfin kalmar sirri wanda ke buƙatar kalmar sirri mai ƙarfi don samun ƙaramin haruffa 8 wanda yakamata ya zama nau'in lambobi, gaurayawan harka, kuma haruffa na musamman.

Don ci gaba da saita kalmar wucewa danna 'Y' don ci gaba. In ba haka ba, danna 'n' don komawa da yin gyare-gyaren da ake buƙata.

Don sauran abubuwan da suka rage, danna ‘Y’ don cire masu amfani da ba a san su ba, hana tushen mai amfani da shiga daga nesa, da cire bayanan gwajin da ya kamata a goge kafin a ci gaba zuwa yanayin samarwa.

Mataki 6: Haɗa zuwa MySQL a cikin Rocky Linux

Da zarar an yi, yi amfani da abokin ciniki na MySQL don haɗi tare da bayanan bayanai kamar yadda aka nuna. Tabbatar da tushen kalmar sirri da aka bayar.

$ sudo mysql -u root -p

Kuna iya tabbatar da sigar ta hanyar gudanar da tambayar:

mysql>  SELECT VERSION ();

Shigar da bayanan MySQL akan Rocky Linux ko AlmaLinux tsari ne mai sauƙi kuma mai sauƙi. Babu buƙatar ƙara kowane ma'ajiyar ɓangare na uku tunda wurin ajiyar AppStream ya riga ya ba da rafi na MySQL 8.0.