Yuav ua li cas thiaj nrhiav tau MySQL txoj hauv Windows?
Yuav ua li cas thiaj nrhiav tau MySQL txoj hauv Windows?

Video: Yuav ua li cas thiaj nrhiav tau MySQL txoj hauv Windows?

Video: Yuav ua li cas thiaj nrhiav tau MySQL txoj hauv Windows?
Video: kev nrhiav hauj lwm nyob Japan 2024, Hlis ntuj nqeg
Anonim

Nyob ntawm Qhov rai desktop, right-click lub My Computer icon, thiab xaiv Properties. Tom ntej no xaiv lub Advanced tab los ntawm System Properties ntawv qhia zaub mov uas tshwm, thiab nias lub pob Environment Variables. Hauv System Variables, xaiv Txoj kev , thiab ces nias lub pob Kho kom raug. Lub Kho kom raug System Variable dialogue yuav tsum tshwm sim.

Ib yam li ib tug yuav nug, Kuv yuav ua li cas thiaj paub yog tias MySQL raug teeb tsa rau Windows?

Rau kuaj yog MySQL tau nruab , ua tshawb xyuas MySQL server xwm txheej thiab saib seb qhov kev pabcuam cuam tshuam puas yog khiav koj tuaj yeem qhib cov kev pabcuam snap-in (los ntawm kev pabcuam ntaus ntawv. msc rau Qhov rai Khiav) thiab kuaj yog tias kev pabcuam yog khiav.

Qhov thib ob, Kuv yuav teeb tsa ib puag ncig hloov pauv hauv MySQL Windows 10 li cas? Ntxiv MySQL rau PATH Ib puag ncig hloov pauv hauv Windows

  1. Ntaus Win + Pause / Break.
  2. Nyem rau Advanced system settings.
  3. Nyob rau hauv qab ntawm lub qhov rais qhib tshiab nyem rau Environment Variables.
  4. Hauv lub qhov rais tshiab Xaiv Path ib puag ncig hloov pauv thiab nyem Kho kom raug.

Hais txog qhov no, kuv yuav nrhiav tau qhov version ntawm MySQL li cas?

  1. Xyuas MySQL Version nrog V hais kom ua. Qhov yooj yim tshaj plaws los nrhiav MySQL version yog nrog cov lus txib: mysql -V.
  2. Yuav Ua Li Cas Nrhiav Tus lej Version nrog mysql Command. Tus neeg siv MySQL command-line yog lub plhaub SQL yooj yim nrog cov tswv yim kho kom raug.
  3. SHOW VARIABLES LIKE Statement.
  4. SELECT VERSION nqe lus.
  5. STATUS Command.

Kuv yuav ua li cas khiav MySQL los ntawm kab hais kom ua hauv Windows?

  1. Ua ntej, qhib koj cov lus txib nrog Administrator.
  2. Mus rau MySQL ntsia cov npe thiab luam txoj hauv kev thiab yav dhau los ntawm kev hais kom ua xws li:- C: Program FilesMySQLMySQL Server 5.7in>
  3. C:Program FilesMySQLMySQL Server 5.7in>mysql -uroot -p [-u rau username -p rau password]

Pom zoo: