Server Administration
Schedule Tasks With Cron
Run commands on a fixed timetable with cron. This tutorial opens your crontab, explains the five time fields, schedules a nightly logged backup, and…
//
Author: admin
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…
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 an Index and Read EXPLAIN in MySQL
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…
Database Administration
Add a Foreign Key in MySQL
Add a foreign key in MySQL to link two tables and have the database enforce it, rejecting orphan rows while an ON DELETE CASCADE…