Linux Resources
- Home
- Linux Resources
Install and Use MyCLI in MySQL / MariaDB / Percona for Auto-Completion and Syntax Highlighting on Ubuntu 20.04 server
This article covers how to install and use the MyCLI tool on your Ubuntu Linux system. In fact, MyCLI is an easy-to-use command line interface (CLI) for MySQL, MariaDB, and Percona, that helps you speed up development with auto-completion and syntax highlighting features.
How to install the MyCLI tool on your Linux system ?
MyCLI tool is based on Python and needs to be installed via pip. Make sure PIP and python development libraries are installed.:
$ yum install python-pip
$ yum -y install python-devel
$ pip install mycliMyCLI Features include:
- Auto-completion as you type for SQL keywords as well as tables, views and columns in the database. Auto-completion is on by default. The REPL will pop up a suggestion menu as soon as you start typing. The suggestions are context sensitive based on the position of the cursor. eg: Only tables are suggested after the FROM keyword, only column names are suggested after the WHERE clause.
- Syntax highlighting using Pygments. Syntax highlighting has plenty of themes that can be changed via the config file.
- Smart-completion (enabled by default) will suggest context-sensitive completion.
- SELECT * FROM <tab> will only show table names.
- SELECT * FROM users WHERE <tab> will only show column names.
- Support for multiline queries.
- Favorite queries with optional positional parameters. Favorite Queries are a way to save frequently used queries with a short name. Save a query using \fs alias query and execute it with \f alias whenever you need.
- Timing of sql statments and table rendering.
- Config file is automatically created at ~/.myclirc at first launch.
- Log every query and its results to a file (disabled by default).
- Pretty prints tabular data (with colors).
- Support for SSL connections.
- There are two types of keybindings available. Emacs mode and Vi mode
- Cross-platform support – runs under Linux and macOS. The software may run under Windows but this is not tested.
Install OBS Studio on Ubuntu 20.04 LTS - Step by step guide ?
This article covers the process of installing OBS studio on your Ubuntu Linux system. In fact, OBS Studio is a free open source software for capturing, compositing, encoding, recording, and streaming video content.
Main features of OBS Studio includes:
- Live to stream.
- Video recording.
- Fully configurable with multiple video sources.
- Individual audio mixer with per-source supporting filters.
- Video transitions.
- Real-time video/audio capturing and mixing.
- Free and open-source.
- Export to multiple formats.
- Drag and drop.
Install Budgie on Linux Mint 20 - Step by step guide ?
This article covers the process of installing and removing the Budgie Welcome Screen application on a Linux Mint 20 system. In fact, the Budgie Desktop environment is popular because of its simplicity yet user-friendly and easy to use. Budgie uses GNOME technologies at its core and is integrated very well with the GNOME stack.
Install / Enable RPM Fusion on Rocky Linux 8 - Step by step guide ?
This article covers how to install RPM fusion on AlmaLinux 8 / Rocky Linux 8. In fact, RPM Fusion is a repository specifically for Fedora Linux which is an amalgamation of the software repositories Livna, Freshrpms, and Dribble to bundle resources.
How to Disable or Enable any repository like RPM Fusion from Rocky Linux 8 system ?
1. Install Yum Utils:
$ sudo dnf install yum-utils2. Command syntax to enable or disable repo:
$ sudo yum-config-manager --disable repository-ID3. To get the ID list the repositories using:
$ dnf repolistLet's say we want to disable Fusion then the command will be:
$ sudo yum-config-manager --disable rpmfusion-free-updatesTo enable the same in the future, use:
$ sudo yum-config-manager --enable rpmfusion-free-updates4. To List, all the enabled and disabled repositories simply type:
$ dnn repolist all
Fix the "The repository does not have a release file" Error in Ubuntu - Step by step guide ?
This article covers ways to resolve faulty Linux system PPAs error "The repository does not have a release file". You can eaily reinstall the software again with fresh PPAs which are supported by your system.
Install nload to Monitor Real Time Network Traffic on Ubuntu 20.04 Linux system - Step by step guide ?
This article covers the different ways to easily install nload on your Ubuntu system. In fact, nload is a command-line utility that can be used to monitor network traffic and bandwidth usage in real time. It visualizes the in-comming and out-going traffic using two graphs and also provides additional information like min/max network usage and total transferred data.
