Kukhazikitsa mysql mu malo 7

MySQL imawonedwa momveka bwino kasamalidwe ka malo osungirako database, chifukwa chake amagwiritsa ntchito akatswiri onse ndi okonda kugwira ntchito ndi mawebusayiti ndi mapulogalamu osiyanasiyana. Kuti mugwire ntchito yolondola ya chida ichi, iyenera kuyikika mu ntchito yogwira ntchito ndikukhazikitsa makonzedwe olondola, akukankha mu maseva omwe alipo ndi zina zowonjezera. Lero tikufuna kuwonetsa momwe njirayi imachitikira pamakompyuta omwe amathamanga 12.

Ikani MySQL mu Cretos 7

Zomwe zili m'nkhani yomwe tili nayo igawika magawo kuti wogwiritsa ntchito aliyense athe kumvetsetsa bwino kuti linux, komanso momwe magawo ayenera kulipirira poyamba. Mwachidule amakuwuzani kuti mu kukhazikitsa ndi kuyanjananso ndi MySQL mudzafunikira kulumikizana kwa intaneti, chifukwa kusungidwa kwasungidwa kuvomerezedwa.

Gawo 1: Zochita Zoyambirira

Zachidziwikire, mutha kupitilira nthawi yotsatira ndikupanga kukhazikitsa, komabe, ndikofunikira kudziwa dzina la omwe ali nalo ndikuwonetsetsa kuti malowa tsopano asintha zaposachedwa kwambiri. Sinthani malangizo otsatirawa kuti akonzekere os.

Izi ndi zochita zomwe pambuyo pake zidzapangidwa kudzera mwa terminal, motsatana, zidzakhala zofunikira kuti muzithamangira. Mutha kuchita izi kudzera mu menyu yofunsira kapena kufota Ctrl + Alt + T. Kuphatikiza kwakukulu.

Kusintha Kumodzi Kuti Muzichita Zochita Zochita Zochita Mukakhazikitsa Mysql mu ATSOS 7

Apa muyikenso lamulo la Holtoname ndikudina ku Enter.

Lowetsani lamulo loti mufotokozere dzina la omwe ali mu MySQL mu ATENSOS 7

Kuphatikiza apo, dzina lake Dongosolo -f ndikufanizira zotsatira ziwiri. Woyamba ndi wathunthu, ndipo wachiwiri - wachidule. Ngati ikukuyeneretsani, pitani patsogolo. Kupanda kutero, muyenera kusintha dzina loti lizikhala pogwiritsa ntchito malangizo ochokera ku zolembedwa zakale.

Lamulo loti liziwonetsa dzina lachidule la MySQL mu APOS 7

Musanakhazikitse pulogalamu iliyonse, tikulimbikitsidwa kuti muwone kupezeka kwa zosintha kuti njira zonse zotsatizana zikuyenda bwino. Kuti muchite izi, lowetsani SuDo yum ndikudina ku Enter.

Lamulo loti lizilandira zosintha musanakhazikitse MySQL mu APOS 7

Njira iyi imachitidwa m'malo mwa mafuta a superuser, zomwe zikutanthauza kuti muyenera kulowa achinsinsi kuti mutsimikizire kutsimikizika kwa akauntiyo. Ganizirani kuti mukalemba zilembo, sadzawonetsedwa mutonthozo.

Kulowera password kuti mulandire zosintha musanakhazikitse mysql mu dispos 7

Mudzadziwitsidwa za kufunika kokhazikitsa mapaketi osinthidwa, kapena chenjezo lomwe zosintha sizipezeka pazenera.

Kulandila zosintha musanakhazikitse MySQL mu ATENSOS 7

Pambuyo kukhazikitsa zosintha zonse, tikulimbikitsidwa kuyambitsanso kachitidwe kosintha zosintha. Ngati zosintha sizinapezeke, nthawi yomweyo pitani ku gawo lina.

Gawo 2: Tsitsani ndikukhazikitsa mapaketi

Tsoka ilo, simudzatha kutsitsa mysql kuchokera ku malo osungira ndikuyika nthawi yomweyo ndi lamulo limodzi. Izi zimachitika chifukwa cha mitundu yambiri ya mitundu ndi kuphatikizika kwina ndi kuwonjezera kwa zosungidwa, kotero woyamba kusankha phukusi yoyenera ayenera yoyamba.

Pitani ku Nyumba Yazikulu MySQL

Pitani ku ulalo womwe uli pamwambapa kuti mudzidziwe nokha ndi mitundu yonse yomwe ilipo kuyang'anira dongosolo. Sankhani phukusi la chiwongola dzanja cha RPM ndikutengera ulalo poyitanitsa menyu pokonzekera batani lakumanja.

Kutsitsa phukusi la PPM RPM ndi mtundu wa mysql mu dispos 7

Mukayika, muwona kuti ulalo udagawidwa molondola, ndipo ngati mungadutse phukusi la RPM, koma tsopano sichofunikira kwa ife, ndiye tisamukira kutonthozo.

Onani ulalo wolumikizidwa kuti udutse phukusi ndi mysql mu dispos 7

Kamodzi mu ma terminal, lowetsani ulalo wazomwe adalemba ndikudina ku Enter.

Tsitsani Phukusi la MySQL mu dispos 7 kudzera mu terminal

Kenako, gwiritsani ntchito Sudo RPM -vql57-Community-El7.RPM, kuyika cholakwika mu mzerewu kwa manambala omwe atchulidwa mu ulalo womwe ulipo.

Lamulo lowonjezera pakutsitsa phukusi la ASSQL ku Aspos 7

Opaleshoni iyi imachitidwanso m'malo mwa mafuta ochulukirapo, chifukwa chake muyenera kuyambiranso mawu achinsinsi.

Chitsimikiziro cha phukusi lotsitsa la kukhazikitsa kwa MySQL mu dispos 7

Yembekezani mpaka zosintha zomwe zatsirizika ndikukhazikitsa phukusi.

Kudikirira kumaliza kwa phukusi la AsSQL kuyika mu Dispos 7

Musanayambe kukonzanso kwakukulu, sinthani mndandanda wotsatsa mwa kutchula za Suro Yum.

Lamulo la zosintha zaposachedwa pokhazikitsa mysql mu ATSOS 7

Tsimikizani zomwe zachitika posankha y Version.

Chitsimikiziro cha zosintha za repositories pokhazikitsa mysql mu dispos 7

Chitani izi kachiwiri mukabwereza.

Lamulo Lachiwiri kuti mutsimikizire kukhazikitsa mukakhazikitsa MySQL mu ATENSOS 7

Njira yokhayo yokhazikitsa pulogalamuyi yokhayokha. Izi zimachitika pogwiritsa ntchito sudo yum kukhazikitsa lamulo la seva.

Lamulo lokhazikitsa mysql mu sullos 7 kudzera mu terminal

Tsimikizani zopempha zonse za kukhazikitsa kapena paketi ya packet.
Ndondomeko yotsitsayo imatha kutenga mphindi zochepa, zomwe zimatengera kuthamanga kwa intaneti. Pa nthawi imeneyi, musatseke gawo lokhazikika kuti musasinthe makonda onse.

Kuyembekezera kukhazikitsa kwa MySQL DBMS mu distros 7 kudzera mu terminal

Pambuyo pokhazikitsa, yambitsa seva kudutsa sudo sysctl amayambira mysqld.

Kuyendetsa ntchito kuti muchepetse marql dbms mu dispos 7 kudzera mu terminal

Ngati palibe zolakwa zomwe zikutembenukira, mzere watsopano wogwirizira udzawonekera pazenera.

Ntchito Yabwino Kwambiri ya MySQL DBMS mu Dispos 7 kudzera mu terminal

Monga mukuwonera, kukhazikitsa mysql ku malo 7 adatenga mphindi zochepa, ndipo wogwiritsa ntchito sanatenge malamulo ambiri, omwe ambiri amangokopedwa ndikuyika mu kutonthoza. Komabe, kuti mupangitse kulumikizana ndi DBMS, ndikofunikira kutulutsa kasinthidwe koyambirira, komwe tidzafotokozedwe pansipa.

Gawo 3: Kukhazikitsa Koyambirira

Tsopano sitingakukhudze mbali zonse zokhazikitsa dongosolo la database, popeza izi sizikugwirizana ndi nkhani ya nkhaniyi. Tikungofuna kunena za zinthu zoyambira zomwe zikufunika kuchitidwa kuti tiwone momwe ntchitoyi ndikugawirani malamulo. Kuti muchite izi, muyenera kutsatira chitsogozo chotere:

Tiyeni tiyambe ndi kukhazikitsa kwa mkonzi wamanja, popeza makonda onse amasinthidwa mu fayilo yosinthira, yomwe imatsegulira pulogalamu yotere. Ndikosavuta kugwiritsa ntchito nano, kotero mu kutonthoza, sudo yum kukhazikitsa nano.

Kukhazikitsa mkonzi wolemba kuti musinthe makonda a mysql mu dispos 7

Ngati zofunikira sizinakhazikike, muyenera kutsimikizira kuphatikiza kosungidwa kwatsopano. Kupanda kutero, zingwe "sizichita kanthu" zimangowonekera, chifukwa chake mutha kusamukira ku gawo lina.

Kukhazikitsa bwino kwa mkonzi walemba kuti asinthane makonda a mysql mu dispos 7

Ikani SUDO nano /mc/my.cnf ndikuyambitsa lamuloli.

Thamangitsani fayilo yosintha kuti ikhazikike myosql mu dispos 7

Onjezani magome_addddress = chingwe = ndikutchula adilesi ya IP komwe mukufuna kulumikiza ndikutsegula madoko onse. Mutha kutchulanso magawo ena ofunikira. Werengani zambiri za iwo muzolemba zovomerezeka, zomwe zikuwonetsedwa pansipa.

Kusintha kwa fayilo yosinthira mukakhazikitsa mysql mu dispos 7

Zikasintha, musaiwale kuwalemba podina Ctrl + o, kenako kutuluka kuchokera ku nano kudzera pa Ctrl + X.

Kusunga zosintha mu mkonzi wolemba mukamakhazikitsa mysql mu dispos 7

Poyamba, fayilo yosinthira ilinso ndi magawo omwe akukhudza chitetezo cha netiweki. Atha kukhala malo ofooka akamabisala, chifukwa chake tikulimbikitsidwa kuti awathetse popanga MySQL_securetion.

Kutsimikizira opareshoni iyi, lembani mawu achinsinsi.

Monga tanena kale, tinkangowonetsa mfundo yoyambirira ya kusinthika. Zambiri zatsatanetsatane za izi zalembedwa m'nkhani ya MySQL Kenako.

Kudumpha kuti muwerenge zolemba za mysql pa Webusayiti Yovomerezeka

Gawo 4: Muzu Muzu Wokonzanso Chinsinsi

Nthawi zina ogwiritsa ntchito akakhazikitsa MySQL ayimitsani chinsinsi cha Superjuser, kenako osayiwala kapena sakudziwa kuti choyambirira, kotero tidaganiza zokhala ndi fungulo lofikira, lomwe limachitika motere:

Tsegulani "terminal" ndikulowetsa dongosolo la Sudo kuyimitsani Anga kuti aletse kuphedwa kwa ntchitoyo.

Lemekezani ntchito ya mySQL mu APOS 7 kuti mubwezeretse mawu achinsinsi

Pitani kumalo otetezedwa ogwiritsira ntchito kudzera pa madongosolo okhazikika-chilengedwe mysqld_pts = "- Ma tebulo."

Thamangani mysql mu dispos 7 mu Njira Yotetezeka Yoyambiranso

Lumikizanani ndi dzina la dzina la Superuser polowa mu mysql -ku. Mawu achinsinsi sangapemphedwe.

Kulowetsa malamulo kuti mubwezeretse mawu achinsinsi a MySQL 7 mwa ma terminal

Imangosinthanso kuti mupereke malamulo otsatirawa kuti apange kiyi yatsopano yofikira.
MySQL> Gwiritsani ntchito mySQL;
MySQL> Sinthani mawu achinsinsi ogwiritsa ntchito = Chinsinsi ("achinsinsi") komwe wogwiritsa = 'muzu'; (komwe chinsinsi ndi kiyi yanu yatsopano)
MySQL> kutulutsa maudindo;
SuDo Sysctroctl wosakhazikika-maysqld_opts
SuDo Sysctrol amayamba mysqld

Pambuyo pake, yesani kulumikizana ndi seva pogwiritsa ntchito mawu achinsinsi. Nthawi ino payenera kukhala yovuta.

Mwakhala mukudziwa bwino mbiri ya sitepe ndi gawo loti mukhazikitse ndi kukhazikika kwa mysql mu cretos 7. Monga mukuonera, palibe chovuta pa izi, koma simuyenera kuwongolera pamwambapa kuti mulumikizane Database kuti mugwirizanenso ndi seva kapena pulogalamuyi. Zonsezi zimayenera kuchitika pamanja, kukankha kumbuyo kwa malowo, pulogalamu ndikuphunzira zolemba zovomerezeka za zinthu zonse zomwe zimagwiritsidwa ntchito.

Wonenaninso:

Kukhazikitsa phpmyademin mu malo 7

Kukhazikitsa PHP 7 mu Cretos 7