Yadda ake Sanya MySQL 8 a Fedora 36 Linux


MySQL shine ɗayan mafi tsufa kuma ingantaccen tsarin buɗe tushen tushen tushen tsarin sarrafa bayanai wanda miliyoyin masu amfani suka amince kuma suke amfani dashi akai-akai. Tun da kwanan nan Fedora ya sanar da sabon sigar rarraba flagship ɗin su, za mu rufe yadda zaku iya shigar da MySQL 8 cikin sauƙi a cikin Fedora 36.

A cikin wannan koyawa, za mu yi amfani da tsoffin ma'ajin Fedora don mu iya yin wannan tsarin shigarwa a matsayin mai sauƙi kamar yadda zai iya zama.

Muhimmi: Fakitin MySQL da MariaDB suna ba da fayiloli iri ɗaya kuma za su yi rikici da juna. Don wannan dalili, yakamata ku shigar da MySQL ko MariaDB kawai amma ba duka ba.

Shigar da MySQL a cikin Fedora Linux

Kafin shigar da kowane fakitin zuwa tsarin ku, sabunta ma'ajiyar ku da amfani da sabuntawa (idan akwai) yana tabbatar da ƙwarewa mai ƙarfi. Za mu sabunta ma'ajiyar ta hanyar umarnin dnf da aka bayar:

$ sudo dnf update

Da zarar an sabunta ma'ajiyar, za mu iya ci gaba zuwa sashin shigarwa. Yayin da za mu yi amfani da tsoffin ma'ajin, yana ceton mu daga matakai masu rikitarwa. Kamar yadda muke son samun sabon sigar MySQL, za mu yi amfani da sigar al'umma.

Don shigar da MySQL, yi amfani da umarnin da aka bayar:

$ sudo dnf install community-mysql-server -y

Kamar yadda muke amfani da dnf, za ta sarrafa duk abin dogaro ta atomatik kuma zai ba mu ƙwarewa mara wahala.

Fara MySQL a cikin Fedora Linux

Shigar da MySQL kawai ba zai sami aikin ku ba. Kafin ci gaba, ana buƙatar mu kunna sabis na MySQL kamar yadda zai kasance a cikin yanayin rashin aiki bayan shigarwa.

Don duba halin yanzu na sabis na MySQL, yi amfani da umarnin da aka bayar:

$ systemctl status mysqld

Za mu yi amfani da umarni mai zuwa don fara sabis na MySQL:

$ sudo systemctl start mysqld

Yanzu, bari mu bincika ko mun sami nasarar fara MySQL ta amfani da umarnin da aka bayar:

$ systemctl status mysqld

Kamar yadda kake gani, MySQL yana gudana a cikin yanayi mai aiki.

Hakanan, idan kuna son fara MySQL a kowane taya, zaku iya yin hakan cikin sauƙi ta amfani da umarnin da aka bayar:

$ sudo systemctl enable mysqld

Tabbatar da MySQL a cikin Fedora Linux

Tsohuwar shigarwa na MySQL yana da rauni ta tsarin tsaro na zamani kuma masu iya amfani da su cikin sauƙi ta hanyar hackers. Akwai hanyoyi da yawa don tabbatar da MySQL ɗinku, amma mafi sauƙi amma mafi inganci shine amfani da ingantaccen rubutun.

Zamu iya fara rubutun sirri cikin sauƙi ta hanyar umarni mai zuwa:

$ sudo mysql_secure_installation

Ga mafi yawan masu amfani, wannan rubutun zai yi aiki lafiya amma idan ya neme ku kalmar sirri, zaku iya dawo da kalmar sirri ta wucin gadi daga mysqld.log a /var/log/ ta umarnin da aka bayar:

$ sudo grep 'temporary password' /var/log/mysqld.log

Amintaccen rubutun zai tambaye ku masu zuwa:

  • Kafa tushen kalmar sirri
  • Cire masu amfani da ba a san su ba
  • Kashe hanyar shiga tushen ta hanyar nesa
  • Cire bayanan gwaji
  • Sake lodin tushen gata

Haɗa zuwa MySQL a cikin Fedora Linux

Da zarar mun gama tare da tabbatar da rubutun, za mu iya haɗawa cikin sauƙi zuwa uwar garken MySQL ta hanyar ba da umarni:

$ sudo mysql -u root -p

Da zarar mun shiga MySQL, za mu iya lissafin bayanan bayanai ta amfani da masu zuwa:

mysql> SHOW DATABASES;

Ana sabunta MySQL a cikin Fedora Linux

Duk da cewa mun gama shigarwa kwanan nan, za mu iya amfani da wannan umarni don sabunta samfuran MySQL:

$ sudo dnf update mysql-server

Wannan shine ra'ayinmu kan yadda zaku iya shigar da MySQL 8 cikin sauƙi akan Fedora 36 a cikin mafi sauƙin hanya mai yiwuwa. Amma idan har yanzu kuna da wasu batutuwa game da shigarwa, jin daɗin yin tambaya a cikin sashin sharhi.