Explore information related to mysql workbench


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



Install MySQL on Ubuntu 18.04 - Step by Step Process ?

This article covers how to install MySQL version 8.0 on an Ubuntu 20.04 server. By completing it, you will have a working relational database that you can use to build your next website or application.

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses Structured Query Language (better known as SQL) to manage its data.


To install MySQL using the APT package repository:

1. Update the package index on your server if you've not done so recently:

$ sudo apt update

2. Then install the mysql-server package:

$ sudo apt install mysql-server

This will install MySQL, but will not prompt you to set a password or make any other configuration changes. 

Because this leaves your installation of MySQL insecure, we will address this next.

Read More



Install MySQL Version 8 on Red Hat Enterprise Linux 8 - Step by Step Process ?

This article covers how to Install MySQL Version 8 on Red Hat Enterprise Linux 8. Now, you should now have a fully functioning MySQL server version 8 running on your Server.


To Install MySQL 8.0 On CentOS 8 / RHEL 8:

1. Install MySQL 8.0 from MySQL Dev Community

Add the official repository of MySQL to install the MySQL community server:

$ rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

Make sure the MySQL repository has been added and enabled by using the following command:

$ yum repolist all | grep mysql | grep enabled


To Manage MySQL server Service on Linux:

1. After the installation of MySQL, start MySQL server service using the following command:

$ systemctl start mysqld

2. The below command will Enable MySQL server at system startup:

$ systemctl enable mysqld

3. Verify that MySQL server is started using the following command:

$ systemctl status mysqld

Read More



MySQL on Ubuntu 20.04 LTS - How to Install and Configure ?

This article will guide you on how to install and configure #MySQL server on the #Linux system Ubuntu 20.04 in this article. Also, we have explored different basic commands to run MySQL server. MySQL is a relational #database that uses SQL to query a database. It facilitates data storing, modifying, and management in a tabular format. To install the latest version of MySQL in #ubuntu: 1. Enable MySQL #Repositories. 2. Install MySQL Repositories. 3. Refresh the Repositories. 4. Install MySQL. 5. Set up MySQL Security. 6. Start, Stop, or Check Status of MySQL Service. 7. Launch MySQL to Enter #Commands.

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