Creating Users in MySQL and Percona 8 – caching_sha2_password error.

If you’ve started using MySQL 8, you’ll notice your usually commands for creating a user no longer function. That’s because it’s changed in MySQL 8, you need to now create a user, then grant privileges.

Let’s create a user:

1
CREATE USER ‘newuser’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘user_password’;

“Creating Users in MySQL and Percona 8 – caching_sha2_password error.”Continue reading

CentoOS openssl: Create a self-signed ECC certificate

Self-signed certificates and Elliptic Curve Cryptography

There are many reasons to self-sign SSL certificates, but we find them particularly useful for staging sites and in the early stages of a project. We have a three command guide to self-signing an SSL certificate if you aren’t interested in ECC.

If you also are interested in ECC, you may know that the main reason for using elliptic curves as the basis for communication over SSL is the small key size – where regular DSA would require 1024 bits, ECDSA (the elliptic-curve variant of DSA) would require about 160 bits. The computational power required for communication over ECDSA is also less.

“CentoOS openssl: Create a self-signed ECC certificate”Continue reading

Protected: Centos/Redhat: Bash History Display Date And Time For Each Command (who was did it?)

This content is password protected. To view it please enter your password below:

Protected: WTF: Ubuntu 20: Full disabling Snaps in Ubuntu 20.04 – back from dark nightmare to light of server Linux

This content is password protected. To view it please enter your password below:

Scroll to top