How To Use GROUP BY and ORDER BY in SQL
Learn how to use GROUP BY and ORDER BY in SQL to organize and sort data with practical examples and best practices.
Blue-Green Deployments on DOKS with Gateway API
Run blue-green deployments on Kubernetes with Gateway API—safe cutover, instant rollback, and zero-downtime releases with managed databases.
How To Reset Your MySQL or MariaDB Root Password on Ubuntu 18.04
Forgetting passwords happens to the best of us. If you forget or lose the **root** password to your MySQL or MariaDB database, you can still gain access and reset the password if you have access to the server and a sudo-enabled user account. In this tutorial you’ll reset the root password for your MySQL or MariaDB database running on Ubuntu 18.04.
How To Install and Configure Zabbix to Securely Monitor Remote Servers on Ubuntu 16.04
Zabbix is open source monitoring software for networks and applications. It offers real-time monitoring of thousands of metrics collected from servers, virtual machines, and any other kind of network device. These metrics can help you determine the current health of your IT…
Cómo instalar la versión más reciente de MySQL en Debian 9
MySQL es un destacado sistema de administración de bases de datos de código abierto que se usa para almacenar y recuperar datos para una gran variedad de aplicaciones populares. MySQL está representado por la letra M en la sigla de la pila LAMP,…
How to Access MySQL Error Logs
Oftentimes, the root cause of slowdowns, crashes, or other unexpected behavior in MySQL can be determined by analyzing its error logs. On Ubuntu systems, the default location for the MySQL is /var/log/mysql/error.log. In many cases, the error logs are most easily read with the less program, a…
How To Create and Manage Databases in MySQL and MariaDB on a Cloud Server
MySQL and MariaDB are database management software that use the SQL querying language. In this guide, we will discuss how to create and manage databases from within the MySQL or MariaDB interface. This guide will cover how to create, view, switch to, and delete databases.
How To Troubleshoot Socket Errors in MySQL
MySQL manages connections to the database server through the use of a socket file, a special kind of file that facilitates communications between different processes. The MySQL server’s socket file is named mysqld.sock and on Ubuntu systems it’s usually stored in the /var/run/mysqld/…
Set Up OwnCloud for Secure Self-Hosted File Storage on Ubuntu
Install, configure, and secure OwnCloud on Ubuntu for private, self-hosted file storage. Step-by-step setup, HTTPS, and user management included.
How To Install the LLMP stack (Linux, Lighttpd, MySQL and PHP) on Ubuntu 12.04
LLMP is an open source web server that powers numerous websites in the world that focuses on increased performance and a light memory footprint. Together with the very popular MySQL database server and the PHP server side dynamic scripting language, Lighttpd is a strong alternative to the more resource intensive, but otherwise very powerful, LAMP stack.
