Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mysql Color Scheme

Is there a way to set a color scheme for the mysql client? It might sound trivial, but I'd like to be able to set some level of colors for terminal client.

like image 798
Cory Collier Avatar asked Dec 21 '09 14:12

Cory Collier


People also ask

How do I change the background color in MySQL?

Here's how to change MySQL Workbench's colors (INCLUDING THE BACKGROUND COLOR). Open the XML file called code_editor. xml located in the data folder of the MySQL Workbench's installation directory (usually C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data ).

How do I change font color in MySQL?

Click Options on the Tools menu. Click Environment, and then click Fonts and Colors. In the Show settings for list, select Text Editor. Change the font, size, display item, foreground and background colors.

How do I change the color of a command line in MySQL?

Just right-click on the title bar, select defaults you will get access to do everything in terms of color, font & background. Restart the command line to see the changes.

How do I turn MySQL into dark mode?

To enable the dark theme, you need to manually edit the XML file responsible for setting the colors in MySQL Workbench. There's a file called code_editor. xml that stores the color theme for the Workbench code editor. Just replace the code_editor.


2 Answers

I've spent much time trying to solve that question. It took me nearly a year to solve it :) There is nice option in mysql config called "pager".

I've just published my configs for mysql client and grc (availiable in most nix dists). Check it out on github! https://github.com/nitso/colour-mysql-console

enter image description here

like image 72
Ostin Avatar answered Oct 01 '22 23:10

Ostin


Here is pretty much awesome tool https://github.com/dbcli/mycli

Besides syntax highlight it offers completion.

enter image description here

like image 32
n1_ Avatar answered Oct 02 '22 01:10

n1_