Explore information related to mysql


Different methods of Checking MySQL Version in Linux

This article covers the ways to check the MySQL version in Linux. In fact, MySQL (and its drop-in replacement MariaDB) is the most popular open-source relational database management system. There are some important differences between MySQL versions, so knowing which version is running on your server might be important in some situations.


How to Check MySQL Version with V Command ?

The easiest way to find the MySQL version is with the command:

$ mysql -V

The command mysql –V is not OS specific. This command works on Windows, OS X, and Linux distributions including Ubuntu.

Read More



Install and Use MySQL Workbench on Fedora 35 / 34 / 33 / 32 - Step by step guide

This article covers how to easily manage your SQL databases using MySQL workbench on Fedora. In fact, the MySQL Workbench on Fedora or REHL allows the database managers, developers or DB architects to visually design the Database. It features Database Connection & Instance Management, SQL Editor, Visual EXPLAIN, SQL snippets collections, SSH connection tunneling, Unicode support, Data modeling, ER diagramming, Drag n Drop visual modeling, Database administration, Database account management, Performance monitoring, Performance Schema metrics, MySQL instance dashboard, Database migration, and more.

Read More



Install LAMP Stack on AlmaLinux 8 - Step by step guide ?

This article covers how to install LAMP (Apache, MariaDB, and PHP) Stack on your AlmaLinux 8 system. In fact, LAMP compromises a web server ( Apache ), a database server ( MariaDB or MySQL ), and the PHP scripting language which supports dynamic web pages written in PHP. 

Read More



Install MySQL Workbench on Ubuntu 20.04 LTS - Step by step guide ?

This article covers the process of installing MySQL Workbench on your Ubuntu 20.04 LTS Focal Fossa system. In fact, MySQL workbench is a GUI tool for managing MySQL database system used by database administrators, database architects and developers to visualize database design.


How to Download and Install MySQL Workbench on Ubuntu ?

1. Update and upgrade your system, before any installation:

$ sudo apt update && sudo apt upgrade

2. Now you can download and install Workbench with the command:

$ sudo apt install mysql-workbench

Read More



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 mycli


MyCLI 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.

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com