Kuv yuav txuas rau MariaDB los ntawm Windows li cas?

2024 Tus sau: Lynn Donovan | [email protected]. Kawg hloov kho: 2023-12-15 23:47

Qhov rai

1. Qhib cov lus txib kom ua raws li cov kauj ruam no: Pib -> khiav -> cmd -> nias nkag.
2. Coj mus rhaub rau koj MariaDb installation folder (Default: C: Program Files MariaDbMariaDb Server 12in)
3. Ntaus hauv: mysql -u root -p.
4. PAUB TIAS TXHUA YAM TSEEM CEEB RAU *.
5. Khiav cov lus txib kawg no: FLUSH PRIVILEGES;
6. Txhawm rau tawm hom: tawm.

Kuj nug, dab tsi yog qhov chaw nres nkoj rau MariaDB?

Kev teeb tsa lossis hloov TCP chaw nres nkoj Cov chaw nres nkoj kev xaiv teem lub MySQL los yog MariaDBserver chaw nres nkoj tus lej uas yuav raug siv thaum mloog TCP / IP txuas. Cov default chaw nres nkoj tus lej yog 3306 tab sis koj tuaj yeem hloov nws raws li qhov xav tau.

Tom qab, lo lus nug yog, MariaDB puas zoo dua mysql? Txhim kho Replication: MariaDB kev ua si sai dua thiab muaj kev nyab xeeb dua qub nrog kev hloov tshiab mus txog 2x sai dua nrog tsoos MySQL Replicationsetups. MariaDB replication yog rov qab sib xws nrog MySQL servers, yog li migrating koj pawg rau MariaDB yog ua tau los ntawm kev siv ib qho ntawm ib lub sij hawm.

Hais txog qhov no, kuv yuav nkag mus rau hauv mysql database li cas?

Tsim MySQL Databases thiab cov neeg siv

1. Ntawm kab hais kom ua, nkag mus rau MySQL raws li tus neeg siv hauv paus: mysql -uroot -p.
2. Ntaus MySQL root password, thiab nias Enter.
3. Ntaus q kom tawm ntawm qhov program mysql.
4. Txhawm rau nkag mus rau MySQL raws li tus neeg siv koj nyuam qhuav tsim, ntaus cov lus txib hauv qab no.
5. Ntaus tus neeg siv tus password, thiab tom qab ntawd nias Enter.

Kuv yuav paub li cas version ntawm MariaDB kuv muaj Windows?

Yuav ua li cas txheeb xyuas MariaDB version

1. Nkag mus rau hauv koj li MariaDB piv txwv, hauv peb rooj plaub peb nkag mus siv cov lus txib: mysql -u root -p.
2. Tom qab koj nkag rau hauv koj tuaj yeem pom koj lub version hauv cov ntawv txais tos- tseem ceeb hauv qhov screen-lob hauv qab no:
3. Yog tias koj tsis tuaj yeem pom koj cov version ntawm no koj tuaj yeem khiav cov lus txib hauv qab no kom pom nws: SELECT VERSION();