Sida loo midabeeyo qalabka 'MySQL / MariaDB'

Casharkaan waxaan ku baran doonaa Sida loo midabeeyo qalabka 'MySQL / MariaDB' iyadoo la raacayo qaabeynta aad rabto, oo muujineysa nooca xogta iyo kuwa kale. Tan awgeed waxaan la wadaageynaa qaabeynta asalka ah iyo talaabooyinka lagu socodsiinayo.

Sidee buu midabaynta MySQL / MariaDB u shaqeeyaa?

Macaamiisha Mysql waxay taageertaa adeegsiga astaamo qeexan oo soo-saarista xogta ah. Markaa waxaan u habeyn karnaa grcat (Generic Colouriser) si loo farsameeyo wax soo saarka mysql. Grcat wuxuu aqriyaa feylka qaabeynta ee la keenay, wuxuu kala soocaa wax soo saarka sida ku xusan regexp, wuxuuna ku daraa midabbo. Buugga grc waxaa lagu daawan karaa amarka man grc o Halkan.

Sidee loo midabeeyaa qalabka MySQL / MariaDB?

Si aad u midabeyso qalabka 'MySQL' ama 'MariaDB console' waa inaan raacnaa talaabooyinka soo socda:

Ku rakib MySQL ama MariaDB

Sida iska cad, ku rakib MySQL ama MariaDB.

Ku rakib grc

Grc waa aalad noo ogolaaneysa inaan midabeyno feylasha wax soo saarkeena. (Waxaan ku rakibi karnaa Debian iyo Derivatives iyadoo leh: $ sudo apt-get install grc).

Abuur .grcat faylasha iyo .my.cnf

1. Abuur feyl .Gract galka gurigayaga oo noo oggolaan doona inaan dhigno qaabeynta midabada aan dooneyno inaan tusno:

   $ cd ~ $ gedit .grcat

   Faylka la abuuray waa inaan dhignaa nambarka soo socda:

   # Midabka asalka ah ee erayada #regexp = [\ w., \: \ -_ /] + regexp =. + Midabbada = cagaarka - #Color of the miiska xuduudaha regexp = [+ \ -] + [+ \ -] | [| ] midabo = guduud - #data udhaxeysa () iyo '' regexp = \ ([\ w \ d, '] + \) colors = white - # tiro regexp = \ s [\ d \.] + \ s * ($ | ((= = |)) 4}: \ d {2} midabo = cyan - #IP regexp = (\ d {2} \.) {2} \ d {2} (: \ d {2})? colors = cyan - #schema regexp = `\ w + 'colors = yellow - #email regexp = [\ w \. \ -_] + @ [\ w \. \ -_] + colors = magenta - #Row delimiter when \ G regexp = [*] +. + [*] + Count = midabada joogsiga = cadaan - # Magacyada safka marka \ G regexp = ^ \ s * \ w +: midabbada = cadka la isticmaalay

2. Abuur feyl .my.cnf galka gurigeenna:

   $ cd ~ $ gedit .my.cnf

   Faylka la abuuray waa inaan dhignaa nambarka soo socda:

   [mysql] pager = grcat ~ / .grcat

Orod macmiilkeena MySQL / MariaDB

 mysql -u <user> -p -h <hostname>

Bilow inaad ku raaxeysato

Xeelad yar oo nolosheena u siin doonta qalabkayaga 'Mysql / MariaDB' oo loo qaabeyn karo sida aad u jeceshahay, ma seegi karo fursadda inaan ku mahadnaqo Alexei Kalinin macluumaadkaaga xiisaha leh.