Author: Ronald Caldwell

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.

Cloud automation refers to software, tools, and processes that help reduce the manual effort in deploying and maintaining cloud-based IT infrastructure. In other words, it’s about automating tasks on your cloud servers. 

Localhost is a networking term for the hostname of the current server or computer accessing the network. It is used via the loopback network interface to access the network services running on the host. The loopback interface bypasses any local network interface hardware and serves as a method to connect back to the server. Networking and server administration both frequently use the term localhost.

To answer what is the default password for the PostgreSQL user, there isn’t one. When connecting to PostgreSQL on Linux for the first time, many admins have this question, especially if they are from the MySQL world. One important task is how to access PostgreSQL. This tutorial walks you through setting up the default user for PostgreSQL and connecting to the service.

Git is a widely adopted, open source distributed version control system (VCS). It’s commonly used for source code management (SCM) with sites like GitHub and popular projects such as Perl, and Ruby on Rails. It is also used to maintain VCS and SCM for the Linux kernel.

Businesses are more reliant than ever on the servers and infrastructure providing connected access to their services. These systems and applications are in constant use and have high demands and expectations for availability using terms like five nines (99.999 percent uptime) or industry-standard uptime.

Users view an error page when they visit your website and experience an error. All accounts come preset with standard error pages, or you can customize them. This tutorial walks you through how to create custom error pages in cPanel.