How to Change Authentication Method in MySQL

First, to check what is being used run this,
SELECT user, authentication_string, plugin, host FROM mysql.user;
If the user you are having issues with is set to auth_socket then you may need to change it to method with mysql_native_password
Like this,
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Change root to the user you need and set the password to whatever the password is supposed to be.

Installing software into a FreeNAS jail

Go to Jails
On the right side of the page click the triple dots next to the Plex jail and select Shell
type “whoami” and make sure the response is root (if not use su – or sudo)
type vi /usr/local/etc/pkg/repos/FreeBSD.conf and press enter
If the file exists, look for a line with “FreeBSD: { enabled: no }” and change the no to a yes
OR
If the file is empty type out “FreeBSD: { enabled: yes }
(if you are unfamiliar with vi, to edit just press the letter “a” then type the above stuff without the quotes)
To save, hit the escape button twice and type “:wq” without the quotes
type “exit”
Hit the triple dots again and hit restart for the plex jail
After a few seconds and it is back online hit the triple dots and go to shell
type “pkg update -f” if it prompts you for anything say yes
type “pkg upgrade” and if it prompts you for anything hit yes
You should now be able to install what you need by doing: “pkg install wget ca_root_nss curl perl5 -y”

How to set a static IP address in RHEL8

How to set a static IP address in RHEL8
# get the current connection name
[root@localhost ~]# nmcli con show
NAME UUID TYPE DEVICE
ens160 6b0e7866-7d4f-4668-afbf-a485f9a1e6db ethernet ens160

# Note the NAME of the connection
# To see what IP, gateway and DNS you are currently using do
[root@localhost ~]# nmcli con show ens160 | grep ipv4
ipv4.method: auto
ipv4.dns: 8.8.4.4
ipv4.addresses: 192.168.0.33/32
ipv4.gateway: 192.168.0.1

# If that doesn’t show the information you need, try this command instead:
[root@localhost ~]# nmcli con show ens160 | grep IP4
IP4.ADDRESS[1]:
IP4.GATEWAY[1]:
IP4.DNS[1]:
IP4.DNS[2]:
# set a static IP of 192.168.0.33
[root@localhost ~]# nmcli con mod ens160 ipv4.address 192.168.0.33 ipv4.gateway 192.168.0.1 ipv4.dns 8.8.4.4 ipv4.method manual
# apply new settings to device
[root@localhost ~]# nmcli dev reapply ens160
NOTE : Your connection name, IP address, gateway and DNS information will probably be different to the above, so change it where necessary.