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.
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 ).
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.
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.
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.
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
Here is pretty much awesome tool https://github.com/dbcli/mycli
Besides syntax highlight it offers completion.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With