gearoidc

openssl req -in your.csr -noout -text

gearoidc

deny from nnn.nnn.nnn.nnn

gearoidc

sudo service ntp stop
sudo ntpdate -s time.nist.gov
sudo service ntp start

sudo service ntp stop ; sudo ntpdate -s time.nist.gov ; sudo service ntp start

gearoidc

$ mysql -u <username> -p  -Bse 'show tables' <dbname> | xargs | perl -pe 's/ /,/g'

$ mysql -u <username> -p  -Bse 'optimize tables <comma seperated list of tables>' <dbname>

gearoidc

### Keybase proof

I hereby claim:

  * I am gearoidc on github.
  * I am gearoidc (https://keybase.io/gearoidc) on keybase.
  * I have a public key whose fingerprint is A656 1504 BB93 6CFB DFCE  1AD8 2085 1F44 0387 491F

To claim this, I am signing this object:

gearoidc

### Keybase proof

I hereby claim:

  * I am gearoidc on github.
  * I am gearoidc (https://keybase.io/gearoidc) on keybase.
  * I have a public key ASAmCF7Mx8KIvQYcYhp6bPOgJTowhwfI9STNZjgNfEIjCQo

To claim this, I am signing this object:

gearoidc

Source: https://www.tecmint.com/reset-wordpress-admin-password-via-mysql-command/

$ echo -n "newpass" | md5sum

gearoidc

CREATE USER USER@HOST IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
GRANT ALL PRIVILEGES ON database.* to USER@HOST;
flush privileges;