MySQL yog qhov chaw khaws ntaub ntawv uas tuav cov ntaub ntawv tseem ceeb xws li cov ntaub ntawv pov thawj ntawm cov neeg siv, cov ntsiab lus hauv lub vev xaib, lossis cov kev xaiv xws li loj thiab xim rau koj cov khoom nyiam. Nws yog ib feem ntawm "pawg" ntawm software hu ua LAMP, uas sawv cev rau Linux, Apache web server, MySQL, thiab PHP programming lus.
Ntawm no yog vim li cas koj yuav xav nruab MySQL ntawm Windows 10 thiab yuav ua li cas.
Vim li cas Nruab MySQL ntawm Windows 10?
MySQL yog dawb, qhib-qhov software, thiab koj tuaj yeem rub tawm qhov chaws yog tias koj nyiam. Rau ntau tus, qhov no yog ib qho laj thawj uas nws tau ntseeg los ua ib feem ntawm lub ntiaj teb nrov tshaj plaws lub vev xaib platform. Hauv cov ntsiab lus siv tau ntau dua, nws txhais tau tias koj tuaj yeem rub tawm dawb thiab siv MySQL rau koj tus kheej.
Vim li cas koj thiaj xav ua qhov no? Zoo, yog tias koj xav paub txog technology, koj tuaj yeem ua si nrog nws kom pom nws ua haujlwm li cas. Koj tuaj yeem tsim koj tus kheej cov ntaub ntawv, tsis yog rau kev kawm lossis khaws cov khoom tseem ceeb hauv tsev. Koj tuaj yeem nruab nws los kawm SQL, cov lus programming siv los tswj thiab cuam tshuam nrog ntau cov databases.
Yuav ua li cas rub tawm MySQL's Free Community Edition
Ua ntej txhim kho MySQL Free Community tsab, rub nws ntawm koj lub PC:
-
Mus rau MySQL lub vev xaib thiab xaiv Downloads.
Image -
Xaiv MySQL Community (GPL) Downloads. Lub Zej Zog Tshaj Tawm yog qhov pub dawb, qhib qhov chaw ntawm MySQL.
Qhov sib txawv tseem ceeb ntawm cov qauv them nyiaj thiab cov ntawv dawb hauv zej zog yog Oracle Premier Support, uas muab rau koj nkag mus rau txoj kab kev txhawb nqa, kev pab sab laj, thiab kev paub txog kev paub. Lub luag haujlwm tseem ceeb ntawm MySQL yog qhov loj heev rau ob qho tib si.
Image -
Ntawm nplooj ntawv nram qab no, xaiv MySQL Community Server.
Image -
Scroll down mus rau hauv qab ntawm nplooj ntawv thiab xaiv qhov Mus rau Download Nplooj ntawv ib sab ntawm Windows (x86, 32 & 64-ntsis), MySQL Installer MSI.
Image -
Nplooj ntawv tom ntej yuav hais kom koj xaiv ntawm ob daim ntawv nruab:
- Yog tias koj muaj kev sib txuas hauv Is Taws Nem, xaiv qhov rub tawm sab saum toj.
- Yog tias koj yuav tsum tau offline thaum koj nruab, xaiv qhov rub tawm hauv qab.
thawj qhov kev xaiv yuav rub tawm cov ntaub ntawv thaum koj nruab, thaum qhov kev xaiv thib ob muaj tag nrho hauv ib pob.
Filename yuav txawv nyob ntawm MySQL version.
Image -
Thaum kawg, nkag rau hauv koj tus account Oracle. Yog tias koj tsis muaj, lossis tsis xav kos npe, xaiv Tsis ua tsaug, cia li pib kuv rub tawmhauv kaum sab laug.
Image
Yuav ua li cas rau nruab MySQL ntawm Windows 10
To nruab MySQL:
- Qhib cov ntaub ntawv koj rub tawm los pib txheej txheem kev teeb tsa.
-
Koj yuav pom ntau hom kev teeb tsa sib txawv. Xaiv Custom thiab tom ntej.
Image -
Nyob rau ntawm Xaiv Cov Khoom Muag thiab Cov Khoom Muag, koj yuav tsum tau txav cov khoom los ntawm Xaiv cov khoom lub thawv rau Cov khoom yuav tsum tau nruabbox.
Ua ntej, qhib lub MySQL Servers thiab nthuav cov MySQL Server nplaub tshev thiab xaiv cov qauv tsim nyog rau koj lub kaw lus kom txav mus rau qhov sab xis.
Image -
Xaiv Applications txhawm rau nthuav nws, tom qab ntawd xaiv txhua yam tshwj tsis yog MySQL rau Visual Studio. Ib zaug ntxiv, xaiv tus txoj cai-ntsib xubkom kab nws rau kev teeb tsa.
Nco ntsoov tias koj xaiv X64 lossis X86, nyob ntawm koj lub PC processor thiab seb nws yog 32-ntsis lossis 64-ntsis.
Image -
Thaum kawg, xaiv Cov Ntaub Ntawv, thiab ntxiv nws cov khoom. Qhov kev xaiv no muab qee qhov piv txwv databases koj tuaj yeem saib.
Image -
Xaiv Execute. Koj tuaj yeem xaiv Qhia Paub meej kom pom cov xwm txheej ntawm kev teeb tsa.
Image -
Tam sim no tus installer yuav pib rub tawm MySQL.
Yog koj xaiv qhov "web " rub tawm ua ntej, koj yuav pom cov ntsuas kev nce qib rau txhua qhov rub tawm.
Image -
Thaum txhua yam rub tawm, MySQL yuav pib txhim kho. Thaum tus xwm txheejntawm txhua yam hloov pauv mus rau Ua tiav, xaiv Tom ntej.
Image -
Tus wizard yuav coj koj los ntawm kev teeb tsa. Configure MySQL Server raws li hauv qab no:
- Group Replication: Xaiv Standalone MySQL Server / Classic MySQL Replication.
- Type thiab Networking: Xaiv lub neej ntawd Config Hom Development Computer, uas yuav teeb khoom rau koj ua haujlwm hauv zos.
- Authentication Method: Xaiv Siv Strong Password Encryption for Authentication.
- Accounts and Roles: Sau tus password rau koj lub hauv paus MySQL (piv txwv li, admin) tus neeg siv. Nquag, koj tuaj yeem (thiab yuav tsum) teeb tsa tsawg kawg yog ib tus neeg siv ib txwm muaj lub npe thiab tus password, tab sis txij li thaum koj nyuam qhuav sim tawm, tus account hauv paus yuav txaus.
- Windows Kev Pabcuam: Koj tuaj yeem khaws cov kev hloov pauv ntawm no, tab sis koj yuav tsum xaiv Pib MySQL Server ntawm System Startup kom lov tes taw nws. Raws li txoj cai dav dav, sim tsis txhob tso cov kev pabcuam uas koj tsis xav tau khiav ntawm koj lub tshuab.
Image -
Xaiv Execute txhawm rau siv cov teeb tsa.
Image -
Xaiv Tiav txhawm rau siv koj cov teeb tsa.
Image -
Rov ua cov txheej txheem no rau lwm yam khoom.
Image - Xaiv Finish kom ua tiav qhov kev teeb tsa. Koj tsis tas yuav pib ib qho ntawm cov apps ntawm theem no.
Yuav Ua Li Cas Pib thiab Nres MySQL Server
Tus yuam sij rau kev ua haujlwm nrog MySQL yog lub server khiav. Koj tuaj yeem pib thiab nres lub server los ntawm Windows Services app.
-
Nyob hauv Windows Search box, nkag mus services.
Image -
Xaiv Qhib txhawm rau khiav Cov Kev Pabcuam app.
Image -
Thaum Cov Kev Pabcuam app pib, nrhiav qhov kev pabcuam MySQL. Nws lub npe yuav yog "MySQL" nrog tus lej version tom qab nws (hauv qhov no, MySQL80).
Image -
Xaiv qhov kev pabcuam MySQL, thiab koj yuav tau txais kev xaiv nyob rau sab laug pane. Yog tias qhov kev pabcuam raug tso tseg, xaiv Start Yog tias nws tau ua haujlwm lawm, koj tuaj yeem xaiv Restart, Pause, los yog Stop Koj tuaj yeem siv qhov no kom paub tseeb tias MySQL tsuas yog khiav thaum koj xav siv nws.
Image
