MySQL 8.0, mai sauƙi da sauri akan Ubuntu 18.04

A cikin labarin na gaba zamu kalli MySQL 8.0. A yau, da MySQL uwar garken al'umma ne tsarin sarrafa bayanai kyauta, mashahuri da dandamali. Yana ba da tsarin injin injin ajiya wanda zai samar mana da masu haɗin bayanai da yawa don harsunan shirye-shirye daban-daban da sauran siffofin da zamu samo.

A cikin wannan sakon zamu ga yadda ake girka MySQL 8.0 akan Ubuntu 18.04 Bionic Beaver. Duk wannan cikin sauri da sauƙi. Kafin tafiya zuwa stepsan matakan da shigarwa zai buƙata, yana da ban sha'awa ganin wasu fasallan da wannan sigar ta MySQL ke ba mu. Waɗannan halaye za a iya tuntuɓar su akan tashar yanar gizon. Can, duk wanda yake so, zai iya karanta fasali game da sigar MySQL 8.0.

MySQL 8.0 Girkawa

Theara ma'aji

Abin farin, akwai APT mangaza don shigar da sabar MySQL, abokin ciniki da sauran kayan aikin. Don yin amfani da shi, zamu buƙaci ƙara wannan ma'ajiyar MySQL ɗin ɗin a cikin jerin hanyoyin tushen tsarin mu. Don yin wannan, mun buɗe tashar (Ctrl + Alt + T) kuma a ciki zamu rubuta mai zuwa don sauke kunshin daga ma'ajiyar. Zamuyi wannan ta amfani da kayan aiki wget.

wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb

Bayan haka, zamu shigar da kunshin da muka sauke yanzu ta hanyar bugawa a cikin wannan tashar:

sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

Kafin fara shigarwa, ka tuna cewa yayin aiwatarwa, za a umarce mu da zaɓar sigar sabar uwar garken MySQL da sauran abubuwan haɗin.

Za'a zaɓi sabar MySQL 8.0 ta atomatik. Dole ne muyi ƙasa zuwa zaɓi na ƙarshe wanda ya faɗi Ok kuma a kansa latsa Shigar don ci gaba da daidaitawa da shigarwar kunshin.

Sanya MySQL Server akan Ubuntu 18.04

Yanzu za mu sabunta jerin kayan aikin da ake dasu a wuraren da muka kara a jerin sunayenmu, gami da ma'ajiyar MySQL da muka kara. A cikin m (Ctrl + Alt T) mun rubuta:

sudo apt update

Da zarar an gama sabuntawa, za mu aiwatar da wannan umarnin zuwa shigar da sabar jama'a ta MySQL, abokin ciniki da sauran fayilolin da suka dace:

sudo apt-get install mysql-server

Yayin shigarwa, tsarin zai nemi mu rubuta a kalmar wucewa don tushen mai amfani da sabar MySQL ɗinku. Dole ne mu buga shi sau biyu kuma mu gama ta latsa Shigar.

Ci gaba da kafuwa, sakon sanyi na MySQL uwar garken uwar garken uwar garken MySQL. Za a nuna mana ɗayan zaɓuɓɓukan kamar yadda aka ba da shawara, kawai za mu danna Shigar da shi.

Tabbatar da kafaffen sabar MySQL

Ta hanyar tsoho, shigar MySQL ba amintacce bane. Don kare shi zamu aiwatar da rubutun tsaro wanda ya kawo shi. Za a umarce mu da mu shigar da kalmar sirri ta asali da muka saita yayin aikin shigarwa. Hakanan zamu zabi ko muyi amfani da VALIDATE PASSWORD plugin ko a'a. Wani zabin da za a gabatar mana shi ne wanda zai iya canza tushen kalmar sirri da muka kafa a baya.

Sannan zamu iya amsa eh / ya ga tambayoyin tsaro masu zuwa:

• Share masu amfani da ba a sansu ba? (Latsa y | Y don Ee, kowane maɓallin don A'a): y
• Ba kyale tushen shiga nesa ba? (Latsa y | Y don Ee, kowane maɓallin don A'a): y
• Share bayanan gwajin kuma sami damar shi? (Latsa y | Y don Ee, kowane maɓallin don A'a): y
• Sake shigar da teburin gata yanzu? (Latsa y | Y don Ee, kowane maɓalli na A'a): y

Rubutun tsaro Zamu iya fara shi don daidaitawa ta hanyar bugawa a cikin m (Ctrl + Alt T):

sudo mysql_secure_installation

MySQL uwar garken gwamnati ta hanyar Systemd

A cikin Ubuntu, bayan shigar da kunshin, ayyukan yawanci suna farawa kai tsaye da zarar an saita kunshin. Za mu iya duba idan sabar MySQL tana aiki tare da umarnin mai zuwa:

sudo systemctl status mysql

Idan da wani dalili baya farawa ta atomatik, zamu sami wadatattun masu zuwa umarni don fara shi:

sudo systemctl enable mysql

Samun dama ga harsashin MySQL

Don ƙarewa, dole ne kawai mu sami damar harsashi na MySQL. Za muyi haka ta buga umarnin mai zuwa a cikin m (Ctrl + Alt T):

sudo mysql -u root -p

A cikin kwasfa za mu iya nemi taimakon kuma za mu ga allo kamar haka: