MySQL Cheat Sheet - Quick Reference Guide

  • 24 April 2023
  • ADM

A concise MySQL cheat sheet providing a quick reference guide for common MySQL commands, database and table operations, data manipulation, and more.


Install and use firewalld on Ubuntu

  • 11 May 2020
  • ADM

Firewalld is one of the Linux firewall management tool and it is available on the in the Ubuntu's default repositories, therefore it is available to be installed from these repositories using the apt packaging system.


How to show open database connections in MySQL

  • 07 April 2020
  • ADM

How to show open database connections in MySQL using show status and show processlist command.


How to export and import a .sql file in MySQL from command line

  • 03 February 2017
  • ADM

How to export and import a .sql file in MySQL from command line. Simple commands with multiple parameters.


How to reset MySQL / MariaDB Root Password

  • 01 February 2017
  • ADM

How to reset MySQL / MariaDB Root Password. Simple 6 steps to reset the password.


How to build a LAMP stack (Linux, Apache, MySQL, PHP) on CentOS 7

  • 31 January 2017
  • ADM

How to build a LAMP stack (Linux, Apache, MySQL, PHP) on CentOS 7. The article includes the install + the firewall settings for public access.