Yuav Ua Li Cas Rau Nruab Mysql Server

Cov txheej txheem:

Yuav Ua Li Cas Rau Nruab Mysql Server
Yuav Ua Li Cas Rau Nruab Mysql Server

Video: Yuav Ua Li Cas Rau Nruab Mysql Server

Video: Yuav Ua Li Cas Rau Nruab Mysql Server
Video: Yuav ua li cas rau nruab chav ua mov dab dej 2024, Plaub Hlis Ntuj
Anonim

MySQL yog ib qho ntawm kev tswj hwm kev tswj hwm siv hauv cov txheej txheem sau npe ntawm cov ntawv thov me me thiab nruab nrab. Qhov zoo ntawm DBMS no yog nws qhov hloov tau yooj yim thiab txhawb nqa rau ntau hom rooj. MySQL server ntawm Windows systems tuaj yeem tsim los siv nruab, uas ua tau yooj yim ntawm kev teeb tsa.

Yuav ua li cas rau nruab mysql server
Yuav ua li cas rau nruab mysql server

Tsim nyog

MySQL installer

Cov Lus Qhia

Kauj ruam 1

Rub tawm lub installer los ntawm MySQL qhov chaw tsim tawm thiab khiav nws. Nyob rau hauv lub qhov rai uas qhib, xaiv hom server teeb tsa. Txhawm rau nruab pob tshwj xeeb pob, nyem khawm khawm Custom. Yog tias koj xav tau los teeb tsa cov qauv li niaj zaus rau kev ua haujlwm nrog DBMS, tom qab ntawd nias lub pob Ntaus (Typical).

Kauj ruam 2

Yog tias koj xaiv lub pob Nchuav, tom qab hais kom meej cov khoom sib txuas ntxiv rau kev teeb tsa thiab, yog tias tsim nyog, hloov cov teeb tsa teeb tsa. Tom qab cov txheej txheem kev teeb tsa tiav, kos lub Chaw Nres MySQL Txheej Txheem Kev Teeb Meem Siv thiab nyem Qhov Ua tiav.

Kauj ruam 3

Hauv qhov rai uas tshwm, xaiv Cov Lus Qhia Cov Lus Qhia thiab nyem Next. Hauv seem txuas ntxiv, sau lub tshuab Tus Tsim lossis Siv Tshuab, raws li hom server teeb tsa koj xav tau.

Kauj ruam 4

Xaiv Multifunctional Database, uas yuav ua rau koj ua haujlwm nrog ob lub rooj InnoDB, uas tso cai rau kev ua lag luam, thiab nrog MyISAM. Xaiv qhov chaw tsav uas koj yuav tso cov ntaub ntawv ntawm cov ntaub ntawv, txawm hais tias feem ntau cov kev xaiv no tuaj yeem sab laug ntawm lub neej ntawd.

Kauj ruam 5

Hauv lub npov tom ntej, koj tuaj yeem hais qhia cov xov tooj uas tau tso cai ntau tshaj plaws rau cov neeg rau zaub mov. Yog tias koj xaiv Kev Txiav Txim Siab Txhawb, tom qab ntawd qhov ntau ntawm qhov sib txuas yuav tsis pub tshaj 20, uas yog txaus rau kev teeb tsa ntawm lub khoos phis tawm hauv tsev. Hauv Phau Ntawv Teev Cov Khoom Teev, koj tuaj yeem qhia meej rau koj tus nqi.

Kauj Ruam 6

Khij lub npov nyob ib sab ntawm Enable TCP / IP Networking thiab xaiv qhov chaw nres nkoj los ntawm kev txuas TCP / IP. Feem ntau qhov ntsuas no tuaj yeem sab laug ntawm nws vim. Qhia kom Siv hom nruj, uas ua rau SQL nruj ua raws.

Kauj Ruam 7

Xaiv qhov encoding siv. Txhawm rau kom raug ntawm cov lus Lavxias, koj yuav tsum tau xaiv phau Ntawv Qhia Xaiv Cov Txheej Txheem thiab teev cov cim cp1251. Nyem Tom ntej thiab nyob rau hauv lub tom ntej no tawm txhua yam tseg yog tias koj xav kom tus server khiav ntawm lub system ua kev pabcuam, uas yog txoj kev pom zoo.

Kauj ruam 8

Hauv lub qhov rai tom ntej, sau tus password uas koj yuav siv los tswj tus neeg rau zaub mov. Tsis txhob cia sau dab tsi rau hauv qab, sau txawm tias lo lus zais yooj yim tshaj plaws. Qhov no yuav pab koj kom tsis raug teeb meem yav tom ntej. Neeg rau zaub mov teeb tsa thiab teeb tsa tiav.

Pom zoo: