Yadda ake Sanya MySQL 8.0 a cikin Ubuntu 18.04

MySQL uwar garken al'umma shine tushen buɗewa kyauta, mashahuri kuma tsarin sarrafa bayanai na dandamali. Yana goyan bayan duka SQL da NoSQL, kuma yana da injin gine-ginen ajiya mai toshewa. Bugu da ƙari, yana zuwa tare da masu haɗin bayanai da yawa don harsunan shirye-shirye daban-daban, yana ba ku damar haɓaka aikace-aikace ta amfani da kowane sanannen yarukan, da sauran abubuwa da yawa.

Yana da shari'o'in amfani da yawa a ƙarƙashin ajiyar daftarin aiki, gajimare, babban tsarin samarwa, IoT (Internet of Things), hadoop, babban bayanai, ajiyar bayanai, LAMP ko tari na LEMP don tallafawa babban gidan yanar gizo/apps da ƙari mai yawa.

A cikin wannan labarin, za mu yi bayanin sabon shigarwa na tsarin bayanai na MySQL 8.0 akan Ubuntu 18.04 Bionic Beaver. Kafin mu matsa kan ainihin matakan shigarwa, bari mu dubi taƙaice:

• Tsarin bayanai yanzu ya ƙunshi ƙamus na bayanan ma'amala.
• Ya zo tare da tallafin bayanin Atomic DDL.
• Ingantattun tsaro da sarrafa asusu.
• Ingantattun hanyoyin sarrafa albarkatu.
• Haɓaka InnoDB da yawa.
• Sabon nau'in makullin wariyar ajiya.
• Tsohon saitin haruffa ya canza zuwa utf8mb4 daga latin1.
• Biyu na haɓaka JSON.
• Ya zo tare da goyan bayan furci na yau da kullun ta amfani da Abubuwan Ƙasa don Unicode (ICU).
• Sabuwar kuskuren shiga wanda yanzu ke amfani da tsarin gine-gine na MySQL.
• Haɓaka zuwa maimaita MySQL.
• Yana goyan bayan maganganun tebur gama gari (dukansu ba masu maimaitawa da masu maimaitawa ba).
• Yana da ingantaccen ingantawa.
• Ƙarin ayyukan taga da ƙari.

Mataki 1: Add MySQL Apt Repository

An yi sa'a, akwai wurin ajiyar APT don shigar da uwar garken MySQL, abokin ciniki, da sauran abubuwan haɗin gwiwa. Kuna buƙatar ƙara wannan ma'ajiyar MySQL zuwa jerin tushen fakitin tsarin ku; fara da zazzage fakitin ajiya ta amfani da kayan aikin wget daga layin umarni.

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

Sannan shigar da kunshin ma'ajiyar MySQL ta amfani da umarnin dpkg mai zuwa.

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

Lura cewa a cikin tsarin shigarwa na kunshin, za a sa ku zaɓi sigar uwar garken MySQL da sauran abubuwan haɗin gwiwa kamar tari, ɗakunan karatu na abokin ciniki, ko MySQL workbench ɗin da kuke son saitawa don shigarwa.

Sigar uwar garken MySQL mysql-8.0 za a zaɓi ta atomatik, sannan gungura ƙasa zuwa zaɓi na ƙarshe Ok kuma danna [Shigar] don gama daidaitawa da shigar da fakitin sakin, kamar yadda aka nuna a hoton.

Mataki 2: Shigar MySQL Server a cikin Ubuntu 18.04

Na gaba, zazzage sabbin bayanan fakitin daga duk wuraren da aka tsara, gami da ma'ajiyar MySQL da aka ƙara kwanan nan.

$ sudo apt update

Sannan gudanar da umarni mai zuwa don shigar da fakiti don uwar garken al'umma ta MySQL, abokin ciniki da fayilolin gama-gari na bayanai.

$ sudo apt-get install mysql-server

Ta hanyar tsarin shigarwa, za a buƙaci ka shigar da kalmar sirri don tushen mai amfani don uwar garken MySQL, sake shigar da kalmar wucewa don tabbatar da shi kuma danna [Enter].

Bayan haka, saƙon daidaitawar plugin ɗin uwar garken MySQL zai bayyana, karanta ta cikinsa kuma yi amfani da kibiya madaidaiciya don zaɓar Ok kuma danna [Shigar] don ci gaba.

Bayan haka, za a umarce ku da zaɓin tsoffin kayan aikin tantancewa don amfani, sannan yi amfani da kibiya madaidaiciya don zaɓar Ok kuma danna [Enter] don kammala daidaitawar kunshin.

Mataki 3: Amintacce Shigar uwar garken MySQL

Ta hanyar tsoho, shigarwar MySQL ba shi da tsaro. Don kiyaye shi, gudanar da rubutun tsaro wanda ya zo tare da kunshin binary. Za a umarce ku da shigar da tushen kalmar sirri da kuka saita yayin aikin shigarwa. Sannan kuma zaɓi ko amfani da VALIDATE PASSWORD plugin ko a'a.

Hakanan zaka iya canza tushen kalmar sirrin da kuka saita a baya (kamar yadda muka yi a wannan misalin). Sannan shigar da yes/y zuwa tambayoyin tsaro masu zuwa:

• Cire masu amfani da ba a san su ba? (Latsa y|Y don Ee, kowane maɓalli don A'a): y
• A hana tushen shiga daga nesa? (Latsa y|Y don Ee, kowane maɓalli don A'a): y
• Cire bayanan gwaji da samun dama gare shi? (Latsa y|Y don Ee, kowane maɓalli don A'a): y
• Sake ɗorawa teburin gata yanzu? (Latsa y|Y don Ee, kowane maɓalli don A'a): y

Kaddamar da rubutun ta hanyar ba da umarni mai zuwa.

$ sudo mysql_secure_installation

Don ƙarin amintaccen uwar garken MySQL ɗinku, karanta labarinmu 12 MySQL/MariaDB Mafi kyawun Ayyukan Tsaro na Linux.

Mataki 4: Sarrafa MySQL Server ta hanyar Systemd

A kan Ubuntu, bayan shigar da fakiti, sabis (s) galibi ana farawa ta atomatik da zarar an daidaita kunshin. Kuna iya bincika idan uwar garken MySQL ta tashi kuma tana aiki ta amfani da umarni mai zuwa.

$ sudo systemctl status mysql

Idan saboda dalili ɗaya ko ɗaya, ba a fara ta atomatik ba, yi amfani da umarnin da ke ƙasa don farawa kuma ba shi damar farawa a lokacin boot ɗin tsarin, kamar haka.

$ sudo systemctl status mysql
$ sudo systemctl enable mysql

Mataki na 5: Shigar Ƙarin Samfuran da Abubuwan MySQL

Bugu da ƙari, zaku iya shigar da ƙarin abubuwan MySQL waɗanda kuke jin kuna buƙata don yin aiki tare da sabar, kamar mysql-workbench-community, libmysqlclient18 da sauran su.

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

A ƙarshe, don samun damar MySQL harsashi, ba da umarni mai zuwa.

$ sudo mysql -u root -p

Don ƙarin bayani, karanta Bayanan Sakin MySQL 8.0.

Shi ke nan! A cikin wannan labarin, mun bayyana yadda ake shigar MySQL 8.0 a cikin Ubuntu 18.04 Bioni Beaver. Idan kuna da tambayoyi ko tunani don raba, yi amfani da fom ɗin sharhin da ke ƙasa don isa gare mu.