MySQL ifatwa neza kimwe muri sisitemu yo gucunga Ububikoshingiro, rero ikoreshwa cyane nababigize umwuga nabakundana no gukorana nurubuga hamwe nibisabwa bitandukanye. Kubikorwa byiza byiki gikoresho, bizagomba gushyirwaho muri sisitemu y'imikorere hanyuma ugashyiraho iboneza ryukuri, gusunika muri seriveri iriho hamwe nibice byinyongera. Uyu munsi turashaka kwerekana neza uburyo iyi nzira ikorwa kuri mudasobwa zikora cetos 7.
Shyiramo MySQL muri Centos 7
Amakuru mu ngingo yacu yubu azagabanywa ibyiciro kugirango buri mukoresha bushobore kumva neza uko ibice bikubiyemo byongewe kuri Linux. Hida uhita usobanura ko kugirango ushireho kandi ukomeze imikoranire na MySQL uzakenera umurongo wa interineti ukora, kubera ko Archives izaboneka mububiko bwemewe.Intambwe ya 1: Ibikorwa byabanjirije
Nibyo, urashobora guhita ukomeza intambwe ikurikiraho hanyuma, bizakenerwa kumenya izina ryakiriwe kandi ukamenya neza ko ibinini ubu bifite ibishya byose. Hindura amabwiriza akurikira yo gutegura OS.
- Ibi nibikorwa byose byakurikiyeho bizakorwa binyuze muri terminal, muburyo, bizakenerwa gukora byoroheye. Urashobora kubikora ukoresheje ibikubiyemo cyangwa ugahagarika Ctrl + Alt + T. Urufunguzo rwo guhuza.
- Hano andika izina ryakiriwe hanyuma ukande kuri Enter.
- Byongeye kandi, vuga izina ryakiriwe --f hanyuma ugereranye ibisubizo bibiri. Iya mbere irarangiye, na kabiri - amagambo ahinnye. Niba ikwiranye, jya kure. Bitabaye ibyo, ugomba guhindura izina ryakiriwe ukoresheje amabwiriza ukurikije ibyangombwa byemewe.
- Mbere yo gushyira porogaramu iyo ari yo yose, birasabwa kugenzura ivugurura ryamakuru kugirango dukore ibikurikira byose bigenda neza. Kugirango ukore ibi, andika sudo yum kuvugurura hanyuma ukande kuri Enter.
- Ihitamo rikorwa mu izina rya supersuser, bivuze ko ukeneye kwinjiza ijambo ryibanga kugirango wemeze kwemeza konti. Reba ko mugihe cyo kwandika inyuguti, ntibazerekanwa muri konsole.
- Uzamenyeshwa ko ari ngombwa gushiraho paki ivuguruye, cyangwa kumenyesha ko kuvugurura bitabonetse kuri ecran.
Nyuma yo gushiraho ibishya byose, birasabwa gutangira sisitemu kugirango uhindure impinduka. Niba ibishya byabonetse, uhite ujya kumurongo ukurikira.
Intambwe ya 2: Gukuramo no gushiraho paki
Kubwamahirwe, ntuzashobora gukuramo mysql uhereye kububiko bwemewe kandi icyarimwe uyishyireho itegeko rimwe. Ibi biterwa numubare munini wa verisiyo nibibazo bimwe na bimwe byongeyeho ububiko, niko mbere guhitamo paki ibereye igomba kubanza.
Jya kuri Warehouses yemewe MySQL
- Jya kumurongo wavuzwe haruguru kugirango umenyere kuri verisiyo zose zihari za sisitemu yo gucunga Ububiko. Hitamo paki yinyungu muburyo bwa RPM hanyuma wandukure umurongo kuri yo uhamagara imiterere ya menu ukanda buto yimbeba iburyo.
- Iyo ushizemo, uzabona ko umurongo wandukuwe neza, kandi niba unyuze muri mushakisha, uzakuramo pake ya rpm, ariko ubu ntabwo ari ngombwa kuri twe, nuko tuzigera kuri konsole.
- Rimwe muri terminal, andika witge + yandukuye umurongo wabanjirije hanyuma ukande kuri Enter.
- Ibikurikira, koresha sudo rpm -ivh mysql57-Umuryango-Kurekura-El7.rPM, gusimbuza guhuza uyu murongo kumurongo usanzwe.
- Iki gikorwa nacyo gikorwa mu izina rya supersusser, bityo ugomba kongera kwinjira ijambo ryibanga.
- Tegereza kugeza igihe ububiko bumaze kuvugwa no gushiraho paki.
- Mbere yo gutangira inzira nyamukuru yo kwishyiriraho, kuvugurura urutonde rwibitabo ugaragaza sudo yum kuvugurura.
- Emeza igikorwa cyakozwe muguhitamo Y verisiyo.
- Ongera ubikore mugihe usubiramo.
- Gusa inzira yo kwishyiriraho sisitemu ubwayo yagumye. Ibi bikorwa ukoresheje Sudo Yum shyiramo MySQl-seriveri itegeko.
- Emeza rwose ibyifuzo byose byo kwishyiriraho cyangwa kwirukana.
- Uburyo bwo gukuramo bushobora gufata iminota mike, biterwa numuvuduko wa interineti. Muri ibi, ntugafunde isomo rya nyuma kugirango udasubiramo igenamiterere ryose.
- Nyuma yo kwishyiriraho neza, kora seriveri binyuze muri sudo sisitemu yo gutangira mysqld.
- Niba nta makosa agahinduka, umurongo mushya wo kwinjiza uzagaragara kuri ecran.
Nkuko mubibona, ushyireho MySSQL muri Centos 7 gusa, kandi uyikoresha ntabwo yatwaye amategeko menshi, menshi ashobora gukopororwa no kwinjiza muri konsole. Ariko, kubikorwa byiza hamwe na DBMS, bizaba ngombwa kubyara iboneza ryambere, bizaganirwaho hepfo.
Intambwe ya 3: Gushiraho kwambere
Noneho ntituzagira ingaruka ku bintu byose byo gushyiraho gahunda yo gucunga ububiko, kubera ko ibi bidakurikizwa ku ngingo y'ingingo. Turashaka gusa kuvuga kubikorwa byibanze bigomba gukorwa kugirango bigenzure ibikorwa bifatika kandi biha amategeko asanzwe. Kugirango ukore ibi, uzakenera gukurikiza ubuyobozi nk'ubwo:
- Reka dutangire kwishyiriraho umwanditsi mwiza, kubera ko igenamiterere ryose ryahinduwe muri dosiye iboneza, rifungura muri software. Nibyiza gukoresha Nano, rero muri konsole, sudo yum shyira nano.
- Niba ibikorwa bitarashyirwaho, ugomba kwemeza ko hiyongereyeho ububiko bushya. Bitabaye ibyo, umugozi "ntugire icyo ukora" uzagaragara gusa, bityo, urashobora kwimuka ku ntambwe ikurikira.
- Shyiramo Sudo Nano /etc/my.cnf kandi ukoreshe iri tegeko.
- Ongeraho bind_addssss = umugozi = hanyuma ugaragaze aderesi ya IP ushaka guhuza no gufungura ibyambu byose. Urashobora kwerekeza kurindikira ibindi bipimo byingenzi. Soma byinshi kuri bo mubyangombwa byemewe, ibisobanuro byerekanwe hepfo.
- Nyuma yimpinduka, ntukibagirwe kubyandika ukanze kuri Ctrl + o, hanyuma usohoke kuva nano ukoresheje Ctrl + X.
- Mu ntangiriro, dosiye iboneza nayo ikubiyemo ibipimo bireba umutekano wurusobe. Birashobora kuba ahantu dufite intege nke mugihe cyo kwiba, kubwibyo birasabwa kubikuraho mugukora mysql_isective_ibisobanuro.
- Kwemeza iki gikorwa, andika ijambo ryibanga.
Nkuko byavuzwe haruguru, twese twagaragaje ihame shingiro ryiboneza. Ibisobanuro birambuye kuri ibi byanditswe mu nyandiko zemewe na MySQL ikurikira.
Gusimbuka gusoma ibyangombwa bya mysql kurubuga rwemewe
Intambwe ya 4: Gusubiramo umuzi
Rimwe na rimwe, abakoresha iyo bashyiraho MySQL shiraho ijambo ryibanga rya supersuser, hanyuma uyibagirwe cyangwa utazi icyo watoranije muri iyi ngingo kugirango uhitemo urufunguzo, rukorwa nkibi:
- Fungura "terminal" hanyuma winjire kuri sudo sisitemu ihagarika mysqld ngaho kugirango uhagarike irangizwa rya serivisi.
- Jya muburyo butekanye bwibikorwa ukoresheje sisitemu yo gushiraho-ibidukikije mysqld_opts = "- gusimbuka-ameza."
- Ihuze nizina rya supersusser winjiza MySQl -u. Ijambobanga ntirizasabwa.
- Biracyasimbuye gusa kugirango ukore amategeko akurikira kugirango ukore urufunguzo rushya.
MySQL> Koresha MySSQL;
MySQL> Kuvugurura Umukoresha gushiraho ijambo ryibanga = ijambo ryibanga ("ijambo ryibanga") aho umukoresha = 'umuzi'; (aho ijambo ryibanga ari urufunguzo rwawe rushya)
MySQL> Flush Amahirwe;
SUD STSTSCTL ITANGIZE-Ibidukikije MySqld_PTS
Sudo sisitemu itangira mysqld
Nyuma yibyo, gerageza uhuza seriveri ukoresheje ijambo ryibanga rishya. Iki gihe ntihagomba kubaho ingorane.
Umaze kumenya intambwe yitariki yintambwe yo kwinjiza no kwisiga hejuru muri Centos 7. Nkuko mubibona, ariko ntugomba gusuzuma ibyifuzo byavuzwe haruguru hamwe nubuyobozi bwuzuye bwo guhuza Ububikoshingiro bwo gukomeza gukorana nurubuga cyangwa porogaramu. Ibi byose bigomba gukorwa intoki, gusunika kure yihariye yurubuga, gahunda no kwiga ibyangombwa byemewe nibigize byose bikoreshwa.
Reba kandi:
Kwinjiza PHPMyadmin muri Centos 7
Kwishyiriraho PHP 7 muri Centos 7