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.
How to install Nginx on Ubuntu
Nginx is one of the most popular web servers in the world. It is also known to be more resource-friendly than Apache in most cases and can be used as a web server or as a reverse proxy.
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 change DNS settings from command line
The command line tool used to change the DNS settings is netsh
which allows you to configure just about any aspect of your network connections in Windows. In order to use the tool the command line needs to be started as Administrator.
How to change computer's IP address from command line
The command line tool used to change the IP address is netsh
which allows you to configure just about any aspect of your network connections in Windows. In order to use the tool the command line needs to be started as Administrator