Tag: CLI

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.

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.

While the are many ways to create databases, system administrators benefit from knowing how to create a MySQL database in Linux via the command line. Knowing more than one way to accomplish a task provides flexibility in case the usual way you perform it is not an option. Use this tutorial to create a MySQL database via the command line.

Data security is essential to developers, business owners, and system administrators. A vital element of securing data is password management. This guide will teach you how to change a MySQL password in Linux using the command line.

Having access to Ubuntu manual pages (man pages) on your server is an essential asset with which to be familiar. Most Linux-based OS distributions include the man command out of the box. In those cases, there is not much needed. On the other hand, installations that do not have man pages are just a quick command away from having them.

A pipe is a form of redirection in Linux used to connect the STDOUT of one command into the STDIN of a second command. It allows us to narrow the output of a string of commands until we have an easily digestible amount of data. The pipe character is the | symbol and is placed between any two commands. Pipes are one of the most used command-line features that Linux has. Every article showing Linux commands will almost inevitably include pipes. 

Knowing your server's IP address(s) can be useful information to have for various reasons. After all, other than your domain, the server's IP is the main address used to reach the server. Knowing a server's IPs may be necessary when making changes to: DNS, networking, and security. A server may have a single IP, or multiple IPs, but sometimes, you may need a quick method to double-check since it's easy to forget.