phpMyAdmin tsim MySQL database li cas? Ntxiv rau tus neeg siv los teeb tsa tus account tso cai

phpmyadmin yog mainstreamMySQL databaseTswjSoftware.

Yog hais tias nyob rau hauvCWP Control Vaj Huam Sib LuagBackground tsim tsis tauMySQLDatabase, koj yuav tsum tsim MySQL database thiab ntxiv ib tus neeg siv nyiaj tshiab los ntawm phpMyAdmin.

thaum peb nruabWordPress lub vev xaibThaum lub sij hawm qhov kev zov me nyuam, nws tseem yuav tsum tau tsim ib lub MySQL database tshiab thiab ntxiv tus neeg siv tshiab.

phpMyAdmin tsim MySQL database li cas?

Kauj Ruam 1:Ua ntej, peb yuav tsum nkag mus rau hauv phpMyAdmin database tswj software.

Kauj Ruam 2:Tsim MySQL database tshiab, nyob rau hauv txoj cai qhov rai ntawm phpMyAdmin, sau rau hauv lub npe database, thiab nyem Tsim ▼

Kauj Ruam 3:Tom qab tsim MySQL database, nyem "Permissions" nyob rau sab xis ntawm lub ntsiab interface los tsim cov neeg siv database ▼

Yuav ua li cas ntxiv tus neeg siv tus account hauv phpMyAdmin?

Kauj Ruam 4:Ntawm nplooj ntawv tso cai, peb nyem "Ntxiv Tus Neeg Siv Tshiab" ▼

Kauj Ruam 5:Nkag mus rau tus neeg siv lub npe, nkag mus tau thiab lo lus zais ntawm MySQL database koj xav ntxiv ▼

• Peb sau rau hauv MySQL database username lichenweiliang.com;
• MySQL database cov neeg siv tsuas yog tso cai rau hauv zos, yog li xaiv "hauv zos" rau lub npe tswv;
• Peb tuaj yeem siv tus password uas tau tsim los, nyem "Tsim" hauv qab no los tsim tus password random, thiab tom qab ntawd nyem "Copy" kom sau rau hauv lub thawv lo lus zais, lossis koj tuaj yeem txhais koj tus kheej lo lus zais.
• Los ntawm lub neej ntawd, lub kaw lus yuav siv tus phooj ywg xyuas "Grant all permissions to the database chenweiliang", uas yog qhov peb xav tau.

Yuav ua li cas xaiv lub hostname ntawm tus neeg siv tshiab hauv phpMyAdmin?

Muaj 4 txoj kev xaiv ntawm no: txhua tus tswv tsev (%), hauv zos (localhost), siv lub rooj sib tham (tus tswv), siv cov ntawv teb (piv txwv li siv cov ntawv teb).

1. "Txhua tus tswv" txhais tau tias phim txhua tus tswv;
2. "local" txhais tau tias tsuas yog tus tswv hauv zos (defaults nyob rau hauv localhost);
3. "Siv lub rooj sib tham" txhais tau hais tias cov ntaub ntawv hauv lub rooj sib tham hauv MySQL database yuav tsum yeej, thiab tsis tas yuav sau cov ntaub ntawv (yog tias sau, qhov kev xaiv no tsis raug);
4. "Siv cov ntawv teb" txhais tau tias koj sau cov ntaub ntawv chaw nyob ntawm koj tus kheej.

Kauj Ruam 6:Configure thoob ntiaj teb kev tso cai rau cov neeg siv MySQL, xaiv "Xaiv Tag Nrho" ▼

• Tom qab ntawd, rub mus rau hauv qab ntawm nplooj ntawv thiab nyem "Execute" kom ua tiav tsim tus neeg siv tshiab.

Kauj Ruam 7:Tom qab tus neeg siv tau tsim, koj tuaj yeem teeb tsa cov cai tshwj xeeb los hloov kho cov neeg siv database hauv Permissions.

• Yog tias koj tsis tas yuav hloov pauv kev tso cai, koj tuaj yeem tso nws ib leeg.