Maitiro ekupenda iyo MySQL / MariaDB koni

Muchidzidzo ichi tichadzidza maitiro Maitiro ekupenda iyo MySQL / MariaDB koni zvinoenderana nekumisikidzwa kwaunoda, uchisimbisa nerudzi rwe data uye nevamwe. Kune izvi isu tichagovana yekumisikidza kurongeka uye nhanho dzekuti dziite.

MySQL / MariaDB console coloring inoshanda sei?

Mutengi weMysql anotsigira kushandiswa kweinotsanangurwa locator yekuburitsa dhata. Saka isu tinokwanisa kumisikidza grcat (Generic Colouriser) kugadzirisa mysql kuburitsa. Grcat inoverenga iyo yakapihwa yekumisikidza faira, inogadzirisa zvinobuda maererano neregexp, uye inowedzera mavara Iyo grc bhuku rinogona kutaridzwa pamwe nemirairo man grc o pano.

Nzira yekupenda sei iyo MySQL / MariaDB koni?

Kupenda iyo MySQL kana MariaDB koni isu tinofanirwa kutevedzera anotevera matanho:

Isa MySQL kana MariaDB

Zviripachena, iva neMySQL kana MariaDB yakaiswa.

Isa grc

Grc chishandiso chinotibvumidza isu kupenda edu ekuburitsa mafaera. (Tinogona kuiisa paDebian neDerivatives ne: $ sudo apt-get install grc).

Gadzira .grcat mafaera uye .my.cnf

1. Gadzira faira .grcat mune yedu dhairekitori repamba iro rinotibvumidza isu kumisikidza iwo marongero emavara atinoda kuratidza

   $ cd ~ $ gedit .grcat

   Mune iyo faira rakagadzirwa isu tinofanirwa kuisa inotevera kodhi

   #Dhivha yakasarudzika yemazwi #regexp = [\ w., \: \ -_ /] + regexp =. + Mavara = girini - #Rorudzi rwemiganhu yetafura regexp = [+ \ -] + [+ \ -] | [| ] mavara = tsvuku - #data pakati () uye '' regexp = \ ([\ w \ d, '] + \) mavara = chena - # nhamba regexp = \ s [\ d \.] + \ s * ($ | (? = \ |)) mavara = yero - #date regexp = \ d {4} - \ d {2} - \ d {2} mavara = cyan - # nguva regexp = \ d {2}: \ d { 2}: \ d {2} mavara = cyan - #IP regexp = (\ d {1,3} \.) {3} \ d {1,3} (: \ d {1,5})? mavara = cyan - #schema regexp = `\ w +` mavara = yero - #email regexp = [\ w \. \ -_] + @ [\ w \. \ -_] + mavara = magenta - #Row delimita kana \ G regexp = [*] +. + [*] + Count = mira mavara = chena - #Mazita ekoramu apo \ G regexp = ^ \ s * \ w +: mavara = chena anoshandiswa

2. Gadzira faira .my.cnf mune yedu dhairekitori repamba:

   $ cd ~ $ gedit .my.cnf

   Mune iyo faira rakagadzirwa isu tinofanirwa kuisa inotevera kodhi

   [mysql] pager = grcat ~ / .grcat

Mhanya yedu MySQL / MariaDB mutengi

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

Tanga kunakidzwa

Chidiki diki chinopa hupenyu kune yedu Mysql / MariaDB koni uye iyo inogona kugadzirirwa kune yaunoda, ini handikwanise kupotsa mukana wekutenda Alexei Kalinin yeruzivo rwako runonakidza.