Server Administration
Create a systemd Service
Create a systemd service to keep a long-running program alive - started at boot, restarted on a crash, logs collected. This tutorial writes a…
//
Tag: Administration
Database Administration
Group and Aggregate Rows With GROUP BY in MySQL
Use GROUP BY in MySQL to collapse rows that share a value into one summary row each, with COUNT, SUM, AVG and MAX computing…
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…