Server Administration
Connect to a Remote Server Using SSH Keys
Log in to a remote server without a password using SSH keys. Generate an ed25519 key pair, copy the public key to the server,…
//
Tag: Command Line
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…
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 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…