Qhov wikiHow no qhia koj siv koj lub khoos phis tawj kab lus hais kom rho tawm MySQL database. Txhawm rau tshem tawm MySQL database, koj yuav tsum muaj kev nkag mus rau tus as khauj nrog tshem tawm cov cai, xws li "hauv paus" tus as khauj.
Cov kauj ruam
Kauj Ruam 1. Qhib MySQL Command Line
Txhawm rau tshem tawm cov ntaub ntawv khaws tseg hauv MySQL, koj yuav tsum siv MySQL kab hais kom ua los ntawm koj lub khoos phis tawj Command Prompt (Windows) lossis Terminal (Mac) program.
Kauj ruam 2. Nkag mus rau lo lus txib nkag
Ntaus hauv qab no, tom qab ntawd nias ↵ Enter.
mysql -u hauv paus -p
Yog tias koj tsis muaj kev nkag mus rau tus lej hauv paus, nkag mus rau koj tus kheej lub npe siv nyob rau hauv qhov chaw ntawm "hauv paus". Qhov no yuav tsum yog tus as khauj uas tau nyeem/sau cov cai
Kauj Ruam 3. Nkag mus rau koj tus password thaum hais kom sai
Ntaus tus password uas koj siv los nkag rau hauv MySQL, tom qab ntawd nias ↵ Enter.
Kauj Ruam 4. Saib cov npe ntawm koj cov chaw khaws ntaub ntawv
Thaum MySQL qhib, ntaus cov lus txib hauv qab no thiab nias ↵ Nkag mus saib cov npe ntawm koj li MySQL databases:
QHIA DATABASES;
Kauj Ruam 5. Nrhiav lub npe ntawm cov ntaub ntawv koj xav rho tawm
Scroll los ntawm cov chaw khaws ntaub ntawv kom txog thaum koj pom tus uas koj xav rho tawm, ua kom nco ntsoov nws lub npe raws li nws tshwm nyob rau sab saud.
Yog tias koj siv Mac, cov npe database yog cov ntaub ntawv nkag siab. Qhov no txhais tau tias yog lub database lub npe muaj cov tsiaj ntawv loj, koj yuav tsum tau siv cov peev txheej tsim nyog hauv kab lus "rho tawm" kom paub tseeb tias koj rho tawm cov ntaub ntawv raug
Kauj Ruam 6. Rho tawm lub database
Ntaus hauv DROP DATABASE lub npe; qhov twg lub npe yog koj lub npe database, tom qab ntawv nyem ↵ Enter. Piv txwv li, kom tshem tawm cov ntaub ntawv npe hu ua "Paj", koj yuav nkag mus rau cov lus txib hauv qab no:
DROP DATABASE Paj;
Kauj Ruam 7. Txheeb xyuas koj cov npe tshiab ntawm cov chaw khaws ntaub ntawv
Koj tuaj yeem ua kom ntseeg tau tias cov ntaub ntawv raug tshem tawm los ntawm kev rov nkag mus rau SHOW DATABASES; hais kom ua thiab nqes los ntawm koj cov ntaub ntawv muaj. Ib qho uas koj tshem tawm yuav tsum tsis muaj tam sim no.
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
-
Yog tias koj tsis paub meej tias puas muaj lossis tsis muaj lub hauv paus database, nkag mus DROP DATABASE Yog tias muaj lub npe;
yuav tiv thaiv qhov yuam kev los ntawm kev tso tawm yog tias lub database tsis tau sau npe.
- Hauv qhov xwm txheej tsis zoo uas koj tab tom rho tawm cov ntaub ntawv los ntawm server tsis siv localhost, koj yuav ntaus tus nkag mus hais kom ua mysql -u hauv paus -h host -p qhov twg "tus tswv" yog IP chaw nyob ntawm koj lub server.