Kuv yuav pib MariaDB kab hais kom ua li cas?

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

Pib lub plhaub MariaDB

1. Nyob ntawm lus txib , khiav hauv qab no txib kom tso tawm lub plhaub thiab sau nws raws li tus neeg siv hauv paus: /usr/bin/ mysql -u root -p.
2. Thaum koj raug ceeb toom rau tus password, nkag mus rau qhov koj tau teeb tsa ntawm kev teeb tsa, lossis yog tias koj tsis tau teeb tsa, nias Enter kom xa tsis muaj tus password.

Ib yam li ib tug yuav nug, Kuv yuav nkag mus rau MariaDB los ntawm kev hais kom ua li cas?

Qhov rai

1. Qhib cov lus txib kom ua raws li cov kauj ruam no: Pib -> khiav -> cmd -> nias nkag.
2. Nkag mus rau koj lub MariaDb installation folder (Default: C: Program FilesMariaDbMariaDb 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.

Ib sab saum toj no, Kuv yuav pib MariaDB hauv Ubuntu li cas? Txhawm rau nruab MariaDB ntawm Ubuntu 18.04, ua raws li cov kauj ruam no:

1. Hloov cov pob khoom index. sudo apt hloov tshiab.
2. Thaum cov pob ntawv hloov tshiab, nruab MariaDB los ntawm kev muab cov lus txib hauv qab no: sudo apt nruab mariadb-server.
3. Qhov kev pabcuam MariaDB yuav pib ua haujlwm.

Tom qab ntawd, ib tus tuaj yeem nug, Kuv yuav qhib mysql tus neeg siv khoom los ntawm kab hais kom ua li cas?

1. Pib koj qhov kev pabcuam MySQL server los ntawm MySQL home directory. Koj ib qho yog C: MYSQLin yog li xaiv cov npe no hauv kab hais kom ua thiab hom: NET START MySQL.
2. Hom: mysql -u neeg siv -p [pressEnter]
3. Ntaus koj tus password [pressEnter]

Kuv yuav paub li cas yog MariaDB tau nruab rau ntawm 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 hauv paus -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();