This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE USER USER@HOST IDENTIFIED WITH mysql_native_password BY 'PASSWORD'; | |
GRANT ALL PRIVILEGES ON database.* to USER@HOST; | |
flush privileges; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Source: https://www.tecmint.com/reset-wordpress-admin-password-via-mysql-command/ | |
$ echo -n "newpass" | md5sum |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### 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: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### 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: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
deny from nnn.nnn.nnn.nnn |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
openssl req -in your.csr -noout -text |