How To Reset The MySQL 5.5 Server root Password

Author: , March 16th, 2022

Had an old server, needed to get root.

For MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html For some other v5.7 nodes, I had admin access via a different user’s login, so all I needed was this:

How To Fix Server Ownership When Files Have Been Altered By Mistake

Author: , March 16th, 2022

Situation: Newbie mistake, used copy-and-paste to create a script that used variables with the incorrect variable name, then ran chown -R / OUCH Resolution: Since I had aa clone host nearby, I decided to export the remote root fs via NFS, mount it on the fouled nnode, and use find magic to repair. Here are […]

How To Fix Email Service Unavailable Delivery Issues with IPv6 on Amazon Linux

Author: , July 16th, 2021

PROBLEM: Email delivery to Google was failing with a “Service Unavailable” error:

Note that the network address for the destination is shown as IPv6! That is the root cause of the issue: 1. Sendmail is sending mail from the IPv6 address instead of the IPv4 address 2. Google rejects IPv6 senders without proper reverse […]

How To Enable HTTPS For Grafana Using Existing LetsEncrypt Certificates

Author: , July 15th, 2020