10 amarro ah in lagu maareeyo keydka macluumaadka MySQLAdmin

Muddo sanado ah marwalba waan maamulaayey xog-ururinteyda MySQL anigoo galaya server-ka MySQL isla markaana fulinaya tilmaamaha, taasi waa:

mysql -u root -p

Oo halkan waxaan ku qoraa lambarka sirta ah waana sameyn karaa waxa aan rabo, si kastaba ha ahaatee waxaan hadda ogaaday: mysqladmin

Nooca MySQL iyo xaalada?

Marka hore, aan hubino nooca MySQL ee rakibay:

mysqladmin -u root -p ping

O si fiican:

sudo service mysql status

Xaaladdayda waxaan ku helayaa tan:

Weli, way garan karaan nooca MySQL ee la socda:

mysqladmin -u root -p version

Sidee loo dejiyaa ama loo beddelaa lambarka sirta ah ee loo yaqaan 'MySQL'?

Meelo badan oo kala duwan, markii server MySQL la rakibo, had iyo jeer looma qaabeysto lambarka sirta ah asal ahaan MySQL, si loo sameeyo lambar sir ah oo xidid ah marka uusan lahayn waa sida ugu fudud ee:

mysqladmin -u root password PASSWORD-QUE-QUIERAN

Haddii kale, oo waxay leeyihiin eray sir ah oo xidid laakiin waxay rabaan inay beddelaan, qaabeynta ayaa ah sidan soo socota:

mysqladmin -u root -pPASSWORD-QUE-TIENEN password 'NUEVO-PASSWORD'

Sidee loo abuuraa xog-ururin ku jirta MySQL?

Sida fudud ee socda:

mysqladmin -u root -p create NOMBRE-DE-DB

Sidee loo tirtiraa xogta ku jirta MySQL?

Aad ugu eg tilmaamtii hore:

mysqladmin -u root -p drop NOMBRE-DE-DB

Sidee loo ogaadaa isku xirnaanta ay la leeyihiin server-ka MySQL?

mysqladmin -u root -p status

Markaan maqaalkan ku qorayo laptop-kayga wuxuu i tusayaa waxyaabaha soo socda:

Waqtiga Uptime: 19381 Mawduucyada: 1 Su'aalo: 9518 Su'aalo Gaaban: 0 Wuxuu Furmaa: 431 Miisas Biyo ah: 1 Miisaska furan: 106 Su'aalo halkii labaad avg: 0.491

Sidoo kale, haddii aad rabto inaad ogaato dhammaan qiimayaasha iyo xaaladaha doorsoomayaasha, kaliya geli:

mysqladmin -u root -p extended-status

Wax soo saarku wuu sii ballaadhi doonaa markan.

Ama haddii kani kuu sheegi waayo macluumaadka aad u baahan tahay, iskuday:

mysqladmin -u root -p variables

Haddii aad rabto inaad dib u buuxiso mudnaanta, taas oo ah, inaad ku daadiso amarka wuxuu noqon lahaa:

mysqladmin -u root -p reload;
mysqladmin -u root -p refresh

Dhamaan amarradan waxay la shaqeynayaan server-ka MySQL ee ku jira localhost, haddii aad rabto inaad ku fuliso tilmaamaha server-ka fog waa inaad ku dartaa:

-h IP-DE-SERVIDOR

Sikastaba, waan ogahay in qaar badan ay doorbidaan PHPMyAdmin kuwa kalena waxay si fudud u doorbidaan terminalka, halkan waxaan ku heynaa talooyin ku saabsan termin

Haddii aad rabto inaad waxbadan ka ogaato MySQLAdmin horay ayaad u ogayd - » mysqladmin –caawin

Salaan