Peb qhia koj yuav ua li cas rau nruab MySQL ntawm Windows

MYSQL ua

Database managers yog cov cuab yeej tseem ceeb hauv txhua qhov project uas yuav tsum tau tuav cov ntaub ntawv sib txawv. Yog li ntawd, MySQL sawv cev rau ib qho ntawm cov kev xaiv nrov tshaj plaws ntawm kev ua lag luam rau ntau yam laj thawj uas koom nrog, qhov tseem ceeb tshaj plaws, qhov tseeb tias nws yog dawb thiab qhib qhov chaw.. Txawm li cas los xij, nws qhov kev teeb tsa cuam tshuam nrog cov kauj ruam uas feem ntau hem, tshwj xeeb tshaj yog rau cov neeg pib hauv ntiaj teb no. Yog li, Peb yuav qhia koj txhua yam koj xav paub txog yuav ua li cas rau nruab MySQL ntawm koj lub khoos phis tawj Windows..

Nyob rau hauv txoj kev no, nws yuav txaus rau koj ua raws li cov lus qhia thaum koj ua tiav cov txheej txheem, suav nrog cov cuab yeej database no rau hauv koj lub cev.

MySQL yog dab tsi?

Ua ntej pib nrog cov kauj ruam dhau los rau nruab MySQL ntawm Windows, nws tsim nyog paub tias qhov software no yog dab tsi. MySQL yog ib qho system taw qhia rau kev tswj hwm cov ntaub ntawv sib raug zoo uas, raws li nws koom nrog Oracle loj, muaj ob daim ntawv tso cai, uas yog, General Public rau kev siv dawb thiab lwm yam lag luam.. Hauv qhov kev nkag siab no, koj tuaj yeem nkag mus rau cov txiaj ntsig ntawm tus thawj tswj hwm dawb, txawm hais tias lub tuam txhab muaj lwm yam kev hloov pauv uas yuav raug them nyiaj.

Txawm li cas los xij, peb tab tom tham txog qhov nrov tshaj plaws database system nyob rau hauv lub ntiaj teb no thiab qhov tseem ceeb yog vim hais tias peb tuaj yeem suav 100% ntawm nws lub peev xwm dawb thiab dawb. Tsis tas li ntawd, peb muaj ib tug piv txwv ntawm dab tsi lub cuab tam muaj peev xwm, nyob rau hauv lub fact tias nws yog siv los ntawm loj loj xws li Facebook, Twitter los yog YouTube.

Cov kauj ruam rau nruab MySQL ntawm koj lub khoos phis tawj Windows

Yuav ua li cas rau nruab MySQL ntawm Windows yog ib lo lus nug uas yuav zoo li nyuaj hauv kev xyaum vim muaj pes tsawg tus kauj ruam cuam tshuam. Txawm li cas los xij, ntawm no peb qhia koj tias nws yooj yim heev.

Rub tawm MySQL

Ua ntej tshaj plaws, peb yuav pib rub tawm GPL version ntawm MySQL uas yuav tso cai rau koj siv software dawb thiab dawb.. Txhawm rau ua qhov no, nkag mus rau official website thiab mus rau ntu "downloads«, nyob rau sab saum toj ntawm lub interface.

Download GPL

Koj yuav mus rau nplooj ntawv rub tawm, txawm li cas los xij, qhov txuas uas txaus siab rau peb yog nyob hauv qab ntawm qhov screen pom tias yog «MySQL Community (GPL) Downloads".

Tam sim ntawd, mus rau ntu MySQL Installer thiab xaiv lub operating system uas koj yuav nruab nws. Hauv peb qhov xwm txheej, nws yog Windows. Qhov no yuav coj mus txog ob peb txoj kev xaiv uas muaj tib lub npe, tab sis qhov sib txawv, ib qho 2.4MB thiab ib qho 435.7MB.

Installer Download

Thawj yog tsis muaj dab tsi ntau tshaj li hauv internet installer, yog li yog tias koj muaj kev sib txuas hauv internet zoo, koj tuaj yeem siv nws. Rau nws feem, qhov thib ob yog hnyav dua vim nws yog qhov kev xaiv offline, uas yog, tus installer nrog tag nrho cov khoom.. Qhov kev xaiv no muaj txiaj ntsig yog tias koj tsis muaj qhov rub tawm nrawm thiab xav nruab sai.

Tom ntej no, lub xaib yuav qhia cov lus rau koj los tsim ib tus account thiab nkag mus, txawm li cas los xij, koj tuaj yeem zam nws los ntawm kev xaiv hauv qab «Tsis ua tsaug, cia li pib kuv download".

Hla cov ntaub ntawv

Txhim kho MySQL

Thaum cov ntaub ntawv teeb tsa tau rub tawm, khiav nws nrog cov cai tswj hwm kom tsis txhob muaj teeb meem kev tso cai. Txhawm rau ua qhov no, koj tsuas yog yuav tsum nyem rau ntawm tus installer thiab xaiv "Run as administrator".

Cov ntsiab lus uas thiab tej yam kev mob

Tam sim ntawd thawj qhov screen ntawm cov txheej txheem yuav nthuav tawm, qhov twg Peb yuav tsum lees txais cov nqe lus thiab cov xwm txheej thiab tom qab ntawd nyem rau ntawm "Tom ntej".

Tom ntej no, peb yuav tsum xaiv hom kev teeb tsa uas peb xav ua ntawm peb qhov system. MySQL muaj cov kev xaiv hauv qab no:

Hom kev teeb tsa

  • Tus tsim tawm Default: Nws muaj tag nrho cov khoom tsim nyog rau kev txhim kho ib puag ncig. Qhov kev xaiv no yog qhov pom zoo tshaj plaws rau txhua tus, txij li nws suav nrog qhov xav tau los ntawm lub neej ntawd rau kev tswj hwm thiab tsim cov ntaub ntawv.
  • server nkaus xwb: Qhov kev xaiv no yuav nruab tsuas yog MySQL Server Cheebtsam, uas yog, dab tsi yog qhov tsim nyog los khaws cov databases thiab tau txais kev sib txuas.
  • Cov neeg siv khoom nkaus xwb: Nrog rau lwm txoj hauv kev no koj yuav tau txais cov neeg siv MySQL nkaus xwb. Nws muaj txiaj ntsig zoo rau cov neeg uas tsuas yog xav tau txuas mus rau lub server los ntawm lawv lub computer.
  • Tag nrho cov: yog qhov ua tiav ntawm MySQL Server. Txawm hais tias nws yuav siv sij hawm ntau qhov chaw cia, nws yog lwm qhov kev xaiv pom zoo rau cov neeg uas tsis xav ua kom nyuaj heev.
  • Kev cai: Qhov no yog qhov kev cai installation, qhov twg koj tuaj yeem xaiv cov khoom uas koj xav tau los koom ua ke. Nws raug pom zoo rau cov neeg siv siab heev.

Hauv kauj ruam tom ntej, tus installer yuav tso saib cov npe ntawm MySQL software ntxiv thiab muaj peev xwm ntxiv cov kev xaiv tshiab. Yog tias koj muaj kev xav tau ntxiv rau kev tswj hwm koj cov ntaub ntawv, koj tuaj yeem ntxiv lawv ntawm no.

Cov khoom thiab nta

Tom qab ntawd, Koj yuav mus rau qhov system xav tau kev tshuaj ntsuam xyuas qhov twg lub cuab yeej yuav txheeb xyuas yog tias koj muaj txhua yam koj xav tau los khiav nws. Feem ntau, qhov no yog qhov chaw uas koj pib lub installation ntawm Microsoft Visual C ++ yog tias koj tsis muaj nws.

Cov kauj ruam kawg, ua ntej kev txhim kho, yog saib cov ntsiab lus ntawm tag nrho cov txheej txheem nrog cov cuab yeej uas yuav raug muab tso ua ke. Yog tias txhua yam yog lawm, nyem rau ntawm "Tom ntej" khawm kom pib lub installation.

Cov khoom siv rau nruab

Configuring MySQL

Tom qab lub installation, tus wizard yuav nyob twj ywm qhib vim peb yuav tsum mus rau MySQL configuration. Cov kauj ruam no yog qhov tseem ceeb rau nws txoj haujlwm kom raug ob qho tib si hauv kev tswj hwm cov peev txheej thiab hauv kev sib txuas network.

Ua ntej peb yuav tsum xaiv seb tus neeg rau zaub mov yuav ua haujlwm li cas hauv ob txoj kev xaiv los ntawm MySQL:

  • Standalone MySQL Server / Classic MySQL Replication
  • Sandbox InnoDB Cluster Teeb.

Thawj qhov kev xaiv yog qhov pom zoo tshaj plaws, vim tias nws yuav tso cai rau koj los ua haujlwm ib leeg lossis cov neeg siv khoom rov ua dua.. Rau nws feem, qhov kev xaiv thib ob yog tsom rau cov servers uas yuav yog ib feem ntawm pawg database.

Tom qab ntawd, peb yuav tsum tau txhais hom MySQL neeg rau zaub mov uas peb xav tau, qhov no yuav tso cai rau lub cuab yeej siv qhov tsim nyog tshaj plaws rau kev siv uas koj xav muab rau nws.. Hauv qhov kev nkag siab ntawd, nyem rau ntawm "Config Type" drop-down menu thiab koj yuav pom cov kev xaiv muaj:

  • Txhim Kho Computer: Qhov no yog qhov kev xaiv zoo tshaj plaws rau cov uas khiav ob qho tib si MySQL server thiab cov lus nug cov neeg siv khoom ntawm tib lub computer.
  • server-lub computer: taw qhia rau cov servers uas koj tsis tas yuav muaj tus neeg siv khoom khiav.
  • lub computer tshwj xeeb: Qhov kev xaiv no yog rau cov cav tov tag nrho rau kev khiav MySQL, yog li lawv cov peev txheej yuav tau txais tag nrho los ntawm lub cuab yeej.

Nyob rau hauv cov teeb meem feem ntau configuration, peb ib txwm xaiv thawj qhov kev xaiv.

Tom ntej no, ntawm tib lub vijtsam peb yuav kho yam uas cuam tshuam nrog kev sib txuas. Yog li ntawd, qhib lub thawv "TCP/IP" nrog Chaw nres nkoj 3306 thiab nco ntsoov qhib nws ntawm koj lub router kom tso cai rau cov chaw taws teeb sib txuas. Peb tawm hauv seem raws li nws yog thiab nyem rau ntawm "Tom ntej".

Server hom thiab network configuration

Ntawm no peb yuav kho qhov cuam tshuam txog kev nkag mus thiab kev lees paub. Ua li no, koj yuav tau muab tus neeg siv hauv paus tus password thiab koj tuaj yeem ntxiv cov neeg siv ntxiv.

root user configuration

Cov kauj ruam tom ntej yog los teeb tsa lub npe ntawm MySQL kev pabcuam ntawm Windows thiab txoj kev koj xav kom nws khiav. Yog li, koj yuav tuaj yeem xaiv yog tias koj xav kom nws pib nrog kev tso cai ntawm tus account hauv zos lossis nrog tus neeg siv tshwj xeeb tsim rau lub cuab yeej. Qhov no yuav nyob ntawm seb koj tswj koj cov servers li cas.

Windows Service Configuration

Thaum kawg, peb yuav tsum nyem rau ntawm "Ua tiav" khawm ntawm lub vijtsam tom ntej txhawm rau pib cov kev pabcuam thiab cov khoom cuam tshuam nrog MySQL.

Configuration Summary

Yog tias txhua yam pib raug, ces koj tuaj yeem txuas mus rau lub server los tsim koj cov databases.


Cov ntsiab lus ntawm tsab xov xwm ua raws li peb cov ntsiab cai ntawm kev tswj hwm kev ncaj nceesCov. Tshaj tawm ib qho yuam kev nyem no.

Yog thawj tus tuaj tawm tswv yim

Tso koj saib

Koj email chaw nyob yuav tsis tsum luam tawm. Yuav tsum tau teb cov cim nrog *

*

*

  1. Lub luag haujlwm rau cov ntaub ntawv: Miguel Ángel Gatón
  2. Lub hom phiaj ntawm cov ntaub ntawv: Tswj SPAM, kev tswj xyuas tawm tswv yim.
  3. Sau raws cai: Koj kev tso cai
  4. Kev sib txuas lus ntawm cov ntaub ntawv: Cov ntaub ntawv yuav tsis raug xa mus rau lwm tus neeg thib peb tsuas yog los ntawm kev txiav txim siab raug cai.
  5. Cov ntaub ntawv khaws cia: Cov Ntaub Ntawv khaws tseg los ntawm Occentus Networks (EU)
  6. Txoj Cai: Txhua lub sijhawm koj tuaj yeem txwv, rov qab thiab tshem tawm koj cov ntaub ntawv.