Reset MySQL password

´´$ sudo systemctl stop mysql$ sudo mkdir -p /var/run/mysqld$ sudo chown mysql:mysql /var/run/mysqld$ sudo /usr/sbin/mysqld –skip-grant-tables –skip-networking & FLUSH PRIVILEGES;USE mysql;update user set plugin=“mysql_native_password“;ALTER USER ‚root’@’localhost‘ IDENTIFIED BY ‚N3w_p@ssw0rD.‘;quit !fix! error: plugin ‚auth_socket‘ is not loaded !fix! mysql root passwort does not work

Simple VPN with OpenVPN Server Script

Create OpenVPN Server and Client wget https://git.io/vpn -O openvpn-ubuntu-install.sh chmod +x openvpn-ubuntu-install.sh sudo ./openvpn-ubuntu-install.sh Copy the from the Script generated *.ovpn file to your Client Desktop Get The Client from: https://openvpn.net/download-open-vpn/ Import the *.ovpn file inside the Windows Client or use the terminal openvpn with the *.ovpn file as parameter. Internet by OpenVPN: Routing Configuration Weiterlesen…

Lets Encrypt ACME Challenge for Wildcard Certificate

You need access to the DNS and be able to create txt records. certbot certonly –manual –preferred-challenges dns –server https://acme-v02.api.letsencrypt.org/directory –manual-public-ip-logging-ok -d ‚*.hg-system.com‘ -d hg-system.com Change hg-system.com to your Domain Name… Create the txt Record in your DNS. Type TXT Name _acme-challenge Value the command shows above Note that you need to change the acme Weiterlesen…

Secure Nginx with SSL

Step 1 — Installing Certbot sudo apt-get install certbot python3-certbot-nginx Step 2 — Obtaining an SSL Certificate sudo certbot –nginx -d example.com -d www.example.com Step 3 — Updating Diffie-Hellman (Optional) sudo openssl dhparam -out /etc/ssl/certs/dhparam.pem 2048 (more secure but takes a bit longer) editor /etc/nginx/sites-available/default replace /etc/letsencrypt/ssl-dhparams.pem with your generated /etc/ssl/certs/dhparam.pem   Step 4 — Remove Weiterlesen…