Ungayifaka kanjani imibala ikhonsoli ye-MySQL / MariaDB

Kulesi sifundo sizofunda ukuthi Ungayifaka kanjani imibala ikhonsoli ye-MySQL / MariaDB ngokusho kokucushwa okufunayo, okugqanyiswa ngohlobo lwedatha nokunye. Ngalokhu sizokwabelana ngokuhlelwa okuzenzakalelayo nezinyathelo zokwenza ukuthi kusebenze.

Ngabe isebenza kanjani imibala ye-MySQL / MariaDB?

Iklayenti leMysql lisekela ukusetshenziswa kwesitholi esichazwe ngaphambilini sokukhishwa kwedatha. Ngakho-ke singakwazi ukumisa i-grcat (i-Generic Colouriser) ukucubungula okukhipha i-mysql. I-Grcat ifunda ifayela lokumiswa elinikeziwe, idlulisa okukhiphayo ngokwe-regexp, bese ingeza imibala. Ibhukwana le-grc lingabukwa ngomyalo man grc o lapha.

Ungayifaka kanjani imibala ikhonsoli ye-MySQL / MariaDB?

Ukufaka umbala ikhonsoli ye-MySQL noma iMariaDB kufanele silandele lezi zinyathelo ezilandelayo:

Faka i-MySQL noma iMariaDB

Ngokusobala, ufake i-MySQL noma iMariaDB.

Faka i-grc

I-Grc ithuluzi elisivumela ukufaka imibala kumafayela wethu wokukhipha. (Singayifaka ku-Debian naku-Derivatives nge: $ sudo apt-get install grc).

Dala amafayela .grcat futhi .my.cnf.

1. Dala ifayela .grcat enkombeni yethu yasekhaya ezosivumela ukuthi sibeke ukumiswa kwemibala esifuna ukuyikhombisa:

   $ cd ~ $ gedit .grcat

   Kufayela elidaliwe kufanele sibeke ikhodi elandelayo:

   #Igama elizenzakalelayo lamagama #regexp = [\ w., \: \ -_ /] + regexp =. + Imibala = eluhlaza - # Umbala wemingcele yetafula regexp = [+ \ -] + [+ \ -] | [| ] imibala = red - #data between () no '' regexp = \ ([\ w \ d, '] + \) imibala = emhlophe - # regexp yezinombolo = \ s [\ d \.] + \ s * ($ | (? = \ |)) imibala = ophuzi - #date regexp = \ d {4} - \ d {2} - \ d {2} colours = cyan - #time regexp = \ d {2}: \ d { 2}: \ d {2} imibala = i-cyan - #IP regexp = (\ d {1,3} \.) {3} \ d {1,3} (: \ d {1,5})? imibala = i-cyan - #schema regexp = `\ w +` colors = ophuzi - #email regexp = [\ w \. \ -_] + @ [\ w \. \ -_] + imibala = i-magenta - #Row delimiter lapho \ G regexp = [*] +. + [*] + Count = stop colours = mhlophe - Kusetshenziswa amagama ekholomu # lapho kusetshenziswa \ G regexp = ^ \ s * \ w +: colors = white is used

2. Dala ifayela .my.cnf. kumkhombandlela wethu wasekhaya:

   $ cd ~ $ gedit .my.cnf.

   Kufayela elidaliwe kufanele sibeke ikhodi elandelayo:

   [mysql] isikhangiso = grcat ~ / .grcat

Qalisa iklayenti lethu le-MySQL / MariaDB

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

Qala ukujabulela

Icebo elincane elizonikeza impilo kwikhonsoli yethu yeMysql / MariaDB futhi engalungiswa ngendlela othanda ngayo, angikwazi ukuphuthelwa ithuba lokubonga U-Alexey Kalinin ngemininingwane yakho ethokozisayo.