Server Administration
Secure a Site With a Free Let’s Encrypt Certificate
Get a free, trusted TLS certificate for your site with certbot and Let's Encrypt. Install certbot, issue the certificate against a live Apache virtual…
//
Tag: Command Line
Server Administration
Redirect HTTP to HTTPS in Apache
Force every visitor onto HTTPS with a permanent Apache redirect. This tutorial adds a mod_rewrite rule and a cleaner port-80 virtual host, restarts Apache,…
Database Administration
Reset the MySQL root Password From the Terminal
Reset the MySQL root password from the terminal when you are locked out, using skip-grant-tables recovery mode and ALTER USER to set a new…
Database Administration
Create a MySQL Table From the Terminal
Create a MySQL table from the terminal with a single CREATE TABLE statement: typed columns, an AUTO_INCREMENT primary key, and sensible defaults, confirmed with…
Server Administration
Create an Apache Virtual Host
Create an Apache virtual host to serve multiple sites from one Apache install. Define a block with ServerName and DocumentRoot, add a hosts-file entry,…
Database Administration
Join Tables in MySQL
Join tables in MySQL to combine related rows in a single query. Learn INNER JOIN for matches, LEFT JOIN to keep unmatched rows, table…