Umbala weConsole ye-MySQL / iMariaDB

Kule tutorial siza kufunda ukuba Umbala weConsole ye-MySQL / iMariaDB ngokokumisela okufunayo, ukuqaqambisa ngohlobo lwedatha kunye nabanye. Ngale nto siza kwabelana ngoqwalaselo olungagqibekanga kunye namanyathelo okuqhuba.

Isebenza njani imibala ye-MySQL / MariaDB yokufaka imibala?

Umxhasi weMysql uxhasa ukusetyenziswa kwesixeliweyo esichazwe kwangaphambili kwimveliso yedatha. Ke sinako ukumisela i-grcat (i-Generic Colouriser) ukuqhubekeka nokukhupha i-mysql. I-Grcat ifunda ifayile yoqwalaselo ebonelelweyo, icacisa imveliso ngokokuregexp, kwaye yongeza imibala. Isikhokelo se-grc sinokujongwa ngomyalelo man grc o apha.

Ungayifaka njani imibala ikhonsoli ye-MySQL / MariaDB?

Ukufaka imibala kwikhonsoli ye-MySQL okanye iMariaDB kufuneka silandele la manyathelo alandelayo:

Faka i-MySQL okanye iMariaDB

Ngokucacileyo, faka i-MySQL okanye iMariaDB.

Faka igrc

I-Grc sisixhobo esivumela ukuba sifake imibala kwiifayile zethu zokukhupha. (Singayifaka kwiDesbian kunye neeDerivatives nge: $ sudo apt-get install grc).

Yenza iifayile zegr .im.cnf

1. Yenza ifayile .kwi kulawulo lwethu lwasekhaya oluya kusivumela ukuba sibeke ubumbeko lwemibala esifuna ukuyibonisa:

   $ cd ~ iidola zeedig

   Kwifayile eyenziweyo kufuneka sibeke le khowudi ilandelayo:

   #Umda omiselweyo wamagama #regexp = [\ w., \: \ -_ /] + regexp =. + Imibala = eluhlaza - # Umbala wemida yetafile regexp = [+ \ -] + [+ \ - ] | [|] Colours = red - #data between () and '' regexp = \ ([\ w \ d, '] + \) colours = mhlophe - # manani regexp = \ s [\ d \.] + \ s * ($ | (? = \ |)) imibala = tyheli - # umhla regexp = \ d {4} - \ d {2} - \ d {2} imibala = cyan - #time regexp = \ d {2} : \ d {2}: \ d {2} imibala = cyan - #IP regexp = (\ d {1,3} \.) {3} \ d {1,3} (: \ d {1,5} )? imibala = cyan - #schema regexp = `\ w +` imibala = tyheli - #email regexp = [\ w \. \ -_] + @ [\ w \. \ -_] + imibala = i-magenta - #Row delimiter xa \ G regexp = [*] +. + [*] + Count = misa imibala = mhlophe - # Amagama ekholamu asetyenziswa xa \ G regexp = ^ \ s * \ w +: imibala = emhlophe isetyenzisiwe

2. Yenza ifayile .im.cnf kulawulo lwethu lwasekhaya:

   $ cd ~ iidola zeedola .im.cnf

   Kwifayile eyenziweyo kufuneka sibeke le khowudi ilandelayo:

   [mysql] isikhangeli = grcat ~ / .grcat

Sebenzisa umxhasi wethu we-MySQL / MariaDB

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

Qala ukonwabela

Icebo elincinci eliza kunika ubomi kwikhonsoli yethu yeMysql / MariaDB kwaye inokuqwalaselwa ngendlela othanda ngayo, andikwazi ukuphoswa lithuba lokubulela UAlexei Kalinin ngolwazi lwakho olunomdla.