Txhim kho phpmyadmin hauv Ubuntu

Yuav luag txhua lub vev xaib nrog kev faib tawm ntawm PHPMYADMIN los siv MySQL servers databases los ntawm web interface. Ib qho ntxiv, cov khoom ntawm no yog ib feem ntawm lub teeb, ntawm lub installation uas peb tau hais ntawm peb lub vev xaib nyob rau hauv lub moj lub vev xaib ntawm lwm cov khoom. Cov lus qhia niaj hnub no yuav tsom rau cov neeg siv cov neeg tsis tau pib uas nyuam qhuav pib lawv txoj kev paub txog WebSadmin rau lawv lub khoos phis tawm. Tom ntej no, peb yuav nthuav qhia ib qib zuj zus uas yuav ua rau nws ua tau raws li txhua yam ntawm kev ua tiav ntawm txoj haujlwm.

Nruab phpmyadmin hauv Ubuntu

Tam sim ntawd ceeb toom rau koj tias txhua qhov kev nqis tes ua tom qab yuav raug ua dhau los ntawm "Terminal", yog li tau npaj rau qhov tseeb tias koj yuav tau nkag mus rau ntau pawg. Peb kuj qhia tias tus phpmyadmin thawj zaug kev teeb tsa tau ua thaum ua tiav kev teeb tsa. Coj ua piv txwv, cov nrov tshaj plaws Apache web server thiab MySQL DBMS. Yog tias tam sim no koj xav tau txhua qhov ntawm cov khoom sib xyaw, nws zoo dua los siv qhov txuas hauv qab no, qhov chaw uas lub teeb teeb tsa tau piav, thiab peb tau mus ncaj qha rau kev sib cuam tshuam nrog cov khoom koj xav tau hnub no.

Yuav luag txhua tus yeej xws li kev teeb tsa yooj yim uas tsis muaj teeb meem. Txawm li cas los xij, yog tias koj muaj cov teeb meem hauv lub kaw lus cuam tshuam nrog tus saib xyuas pob, cov ntaub ntawv tshwm ntawm qhov screen uas lub installation ua tsis tiav. Cov xwm txheej no yuav tsum tau daws tau cov kev tshawb fawb sai ntawm cov teeb meem tshwj xeeb los ntawm cov ntaubntawv lossis cov neeg siv cov lus sib tham.

Kauj ruam 2: Nruab phpmyadmin

Qeb no yog qhov yooj yim tshaj plaws, txij li tam sim no peb yuav txhim kho cov kev teeb tsa ncaj qha ntawm cov phpmyadmin tivthaiv. Muaj ntau txoj kev sib txawv uas tso cai rau qhov no, thiab qhov yooj yim yuav tau siv los ntawm cov nom ncauj lus uas peb muab rau kev siv hauv kev qhia tom ntej.

1. Txhawm rau nruab, koj yuav tsum nkag mus rau sudo apt nruab PHPMYADmin hais kom ua thiab qhib nws.



2. Yuav muaj kev ceeb toom txog qhov xav tau kev rub tawm cov ntawv teev npe. Hauv cov lus "xav txuas ntxiv?" Xaiv D. kev xaiv



3. Tos kom muaj lub qhov rai console "teeb ​​lub pob". Ntawm no, ua ntej ntawm tag nrho cov, lub web server tau hais tseg rau kev teeb tsa tsis siv neeg. Xaiv koj tus kheej, ces nyem rau ntawm tab kom txav sai sai rau "OK" khawm.



4. Tos li ob peb feeb kom cov pob khoom khoob khoob. Thaum lub sijhawm ua haujlwm no, tsis txhob kaw lub console thiab tsis ua raws lwm yam kev ua hauv PC.



5. Qhov "pob teeb tsa" zoo nkaus li. Tam sim no lub database yog edited ntawm no. Txheeb xyuas cov ntaub ntawv nthuav tawm hauv lub qhov rais thiab xaiv cov kev xaiv tsim nyog.



6. Tsim tus password tshiab rau cov ntaub ntawv.



7. Paub meej tias nws, rov nkag mus rau hauv daim ntawv uas tshwm sim.



8. Qhia kom meej ib txoj kev yooj yim rau kev sib txuas rau cov ntaub ntawv.



9. Tus lej chaw nres nkoj yuav raug muab cia. Yog tias koj muaj qhov yuav tsum tau hloov nws, tsuas yog lwv cov lej thiab qhia cov chaw nres nkoj uas xav tau.



10. Teem lub npe ntawm cov qauv database.



11. Txheeb xyuas cov ntaub ntawv ntawm kev tsim lub npe username.



12. Tam sim no koj yuav tsum nug nws tus kheej, thawb tawm ntawm phau ntawv qhia thiab koj cov kev xav tau.



13. Nkag mus rau lwm lo lus zais uas yuav pab tau rau MySQL rau phpmyadmin.

Tom qab screen qhia cov ntaub ntawv hais txog kev teeb tsa zoo ntawm phpmyadmin hauv lub system. Yog tias muaj teeb meem tshwm sim thaum lub sijhawm teeb tsa lossis tsis tuaj yeem, koj tseem yuav ceeb toom txog lawv. Cov kev xaiv yuav ntxiv ntxiv cov kev xaiv ob leeg, piv txwv li, tsis quav ntsej txog qhov teeb meem, rov sim daws nws lossis hla kev.

Kauj ruam 3: Tsim tus neeg siv tshiab

Thaum lub sijhawm dhau los, cov cuab yeej installation muaj los tsim cov neeg siv tshiab rau phpmyadmin, tab sis qee cov neeg siv tau ploj mus ob peb cov nyiaj ntxiv. Cia peb pib peb ntu ntawm lub chaw tseem ceeb nrog cov lus qhia rau kev tsim cov ntaub ntawv.

1. Qhib kev sib tham tshiab hauv lub davhlau ya nyob twg thiab hom sudo mysql los pib lub chaw khaws ntaub ntawv.



2. Nco ntsoov sau tus password superuser.



3. Raws li thawj cov lus txib, nkag mus tsim cov neeg siv 'admin' allthos 'uas tau txheeb pom los ntawm' password ';, thiab tus lej ntawm tus lej, thiab tus password yog tus password.



4. Teem cov kev cai yooj yim los ntawm kev pab tag nrho cov cai ntawm *. * Rau 'Infucation' Planalhost 'nrog cov npe ntawm tus neeg siv ntawm cov neeg siv lub npe ntawm yav tas los.



5. Kawg queue, sau thiab qhib cov dej muaj cai;.



6. Koj yuav tau txais kev ceeb toom txog kev ua tiav ntawm kev ua haujlwm.

Yuav luag nyob rau hauv tib txoj kev, koj tuaj yeem tsim ib tus naj npawb ntawm cov neeg siv uas yuav txuas rau phpmyadmin los ntawm kev nkag mus rau lub npe ntawm tus account thiab tus password los ntawm nws. Nqa mus rau hauv tus account tsuas yog teeb tsa ntawm cov cai rau txhua qhov profile. Cov ntaub ntawv ntxiv tau sau rau hauv cov ntaub ntawv raug cai.

Kauj Ruam 4: Kev Ruaj Ntseg

Tsim kev tsim kho cov kev cai lijxeeb rau hauv phpmyadmin tsis yog ib txwm tsim nyog, tab sis yog tias tus neeg rau zaub mov muaj tsawg kawg ntawm cov cai yooj yim uas yuav pab nrog kev tawm tsam saum npoo. Cia kev nkag siab sai sai Yuav ua li cas kom teeb tsa cov neeg tiv thaiv server.

1. Txhua qhov kev nqis tes ua txuas ntxiv yuav ua los ntawm kev hloov cov ntaub ntawv cov ntaub ntawv. Txhawm rau ua qhov no, koj yuav tsum siv cov ntawv sau ntawv. Cov kev daws teeb meem txheem tuaj yeem nkag tsis tau rau cov neeg siv novice, yog li cia peb pib nrog kev sib ntxiv ntawm cov kev daws teeb meem yooj yim dua. Ntaus sudo apt nruab nano thiab nyem rau nkag.



2. Tom qab cov ntaub ntawv ua tiav zoo, pib ua ntej cov ntaub ntawv teeb tsa los ntawm Sudo Nano /USr/Share/SHARMYADMIN/.htaccess.



3. Ntawm no nyob rau hauv ib qho khoob kab ntxig rau plaub txoj cai hauv qab no.

   Sau ntawv yooj yim.

   Autnname "txwv cov ntaub ntawv"

   Ap autuserFile / thiab lwm yam / phpmyadmin / htpasswd.

   Yuav tsum siv tau-neeg siv



4. Siv CTRL + O sib xyaw ua ke los txuag cov chaw.



5. Thaum kev tshoov siab, tsis txhob hloov lub npe ntawm cov khoom, tab sis tsuas yog nyem rau nkag.



6. Thaum txhua qhov chaw tau txais kev cawmdim, nias CTRL + x kom kaw cov ntaub ntawv tam sim no.



7. Tom ntej no, teeb tus password tshiab rau tus account tseem ceeb, yog tias qhov no tsis tau ua dhau los. Qhib Sudo Hpaswd -c /etc/phpmyadmin/.htasswd neeg siv lus txib.



8. Nyob rau hauv cov hlua tshwm, nkag mus rau tus yuam sij nkag tau rau koj thiab tom qab ua kom tiav, rov ua nws.



9. Nws tseem nyob tsuas yog los teeb tsa lub web server nyob rau hauv tag nrho cov kev hloov pauv ua ntej. Txhawm rau ua qhov no, qhib cov ntaub ntawv tsim nyog los ntawm sudo nano /etc/apache/apacheS2.Conf.



10. Ntxig cov kab hauv qab thiab txuag cov kev hloov pauv.

    Tso cai rau tag nrho.

    Xav tau txhua qhov tso cai

Tag nrho lwm cov chaw ruaj ntseg yog nqa tawm raws li koj cov kev xav tau, coj mus rau hauv tus account syntax thiab cov cai dav dav uas tau piav qhia hauv cov ntaub ntawv phpmyadmin.

Ua ib feem ntawm cov khoom siv niaj hnub no, peb tsis tau tsuas yog hais txog lub ntsiab cai ntawm kev teeb tsa phpmyadmin, tab sis hais txog lub ntsiab configuration ntsiab lus. Tam sim no koj paub tias kev ua dab tsi yuav tsum tau ua kom tiav ua tiav lub hom phiaj.