MySQL Cheat Sheet - Quick Reference Guide
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
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
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
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
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
How to build a LAMP stack (Linux, Apache, MySQL, PHP) on CentOS 7. The article includes the install + the firewall settings for public access.