Author:
erics, March 16th, 2022
Had an old server, needed to get root.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
service mysql stop ~OR~ service mysqld stop cd /etc/init.d; ./mysql<tab> start --skip-grant-tables mysql> update mysql.user set Password=PASSWORD('secret') where user='root'; mysql> flush privileges; mysql> ^D service mysql stop service mysql start ~OR~ service mysqld stop service mysqld start |
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:
|
ALTER USER 'root'@'localhost' IDENTIFIED BY 'secret'; ALTER USER 'root'@'%' IDENTIFIED BY 'secret'; |
Categories: How-To's, Technology Tags: 5.5, Flush, Grant, init.d, Lost, mysql, MySQL 5.5, Password, privileges, recover, Recovery, Reset, root, service, Skip, skip-grant-tables, Tables, User
|
No comments
Author:
erics, 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 […]
Categories: How-To's, Technology Tags: chown, exportfs, Find, howto, mount, nfs, rpcinfo, service, sudo, tips
|
No comments
Author:
erics, July 16th, 2021
PROBLEM: Email delivery to Google was failing with a “Service Unavailable” error:
|
relay=aspmx.l.google.com. [IPv6:2607:f8b0:400d:c0c::1a], dsn=5.0.0, stat=Service unavailable |
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 […]
Categories: How-To's, Technology Tags: Amazon, Amazzon Linux, AWS, Delivery, DSN, Email, howto, IPv4, IPv6, Linux, make, Restart, SendMail, sendmail.cf, sendmail.mc, service, Service Unavailable, SPF, tips, Unavailable
|
No comments
Author:
erics, July 15th, 2020
|
sudo chgrp grafana /etc/letsencrypt/archive/www.yourdomain.com/privkey1.pem sudo chmod g+r /etc/letsencrypt/archive/www.yourdomain.com/privkey1.pem sudo vi /etc/grafana/grafana.ini sudo service grafana-server restart |
|
[server] # Protocol (http, https, socket) ;protocol = http protocol = https # https certs & key file ;cert_file = ;cert_key = cert_file = /etc/letsencrypt/archive/www.yourdomain.com/fullchain1.pem cert_key = /etc/letsencrypt/archive/www.yourdomain.com/privkey1.pem |
Categories: How-To's, Technology Tags: cert, certificate, Certs, chgrp, chmod, Enable, Existing, Grafana, Grafana Server, howto, https, LetsEncrypt, Restart, service, ssl, sudo, tips
|
No comments