Tag: CLI

MySQL is a popular, modern, and fully featured relational database management software that is free and open source. It is used by companies worldwide for mission-critical enterprise data storage and processing, as the backend for large customer-facing applications, and as a component of robust, well-established web software stacks.

Strict mode in MySQL and MariaDB controls the handling of invalid or missing values in data-changing queries. This includes INSERT, UPDATE, and CREATE TABLE statements. With MySQL strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.

What is a GitHub gist?

One of GitHub's most innovative features is Gist, which lets you store and distribute code snippets without setting up a full-fledged repository. Code strings, bash scripts, markdown, text files, and other small pieces of data are all acceptable alternatives to just code snippets. It can be used to quickly distribute a piece of code to others for anything like a demonstration, a how-to, or any solution without setting up a standard repository. Additionally, you can use it to embed elsewhere or on your website.

This tutorial demonstrates how to quickly and easily uninstall software on Ubuntu. Uninstalling software can be done using several techniques. It shows you how to uninstall software using these various methods.

System administrators do well to further their security practices by removing users from MySQL who no longer require access. They should ensure that they get released as users change, and turnover happens. It provides security and safeguards against unlawful access to data.

A fundamental part of managing users in MySQL is removing permissions no longer required for a user. Administrators should ensure that terminated users or those whose roles have changed within the company have had permissions removed from their user profiles. This action secures the system against unlawful access to information.

After an administrator creates a MySQL user via the command line on Linux, the next step is to grant permissions to that user. The goal is to ensure that the user is able to log in and access the MySQL server to perform tasks. This article shows you how to grant permissions to a MySQL user on Linux via the command line.

Previous Series:
MySQL via Command Line 101: Basic Database Interaction

Next Series:
MySQL via Command Line 102: Basic User Interaction

When working with MySQL in the command line, it is important to ensure proper selection of the database you wish to work with. Administering a server has its challenges without unnecessary errors due to an incorrect database selection. This article shows you how to select a MySQL database in Linux via the command line.