Setup MySQL

MySQL Installation sudo apt-get -y install mysql-server mysql-client be sure to be root install mysql server + client Secure the mysql Installation sudo mysql_secure_installation Enter password for user root: <– Enter the MySQL root password Press y|Y for Yes, any other key for No: <– Press y if you want this function or press Enter otherwise. Using existing password weiterlesen…

Ubuntu MySQL 5.7 fix after Ubuntu Upgrade

There are bugs with MySQL after Ubuntu Upgrade.  (4 new server installations) Bring it to work in just one line of code: sudo mv /etc/mysql/my.cnf /etc/mysql/my.cnf.bak && sudo rm -r /etc/mysql/mysql.conf.d/ && sudo mv /etc/mysql/debian.cnf /etc/mysql/debian.cnf.bak && sudo apt purge mysql-server mysql-server-5.7 mysql-server-core-5.7 && sudo apt install mysql-server sudo ln -s /etc/mysql/mysql.conf.d /etc/mysql/conf.d && sudo service mysql weiterlesen…

SSH Tunnel over http proxy

UNBLOCK YOURSELF GUIDE you need a SOCKS5 to handle every connection type? ssh is blocked? add an aditional ssh port nano /etc/ssh/sshd_config # This is ssh server systemwide configuration file. Port 22 Port 8080 # Add this line to accept ssh connections on 8080 service sshd restart SSH config file nano ~/.ssh/config ## Outside of the firewall, with HTTPS weiterlesen…

DNS not reachable NETWORK FIX

ADD to /etc/resolv.conf nameserver 8.8.8.8nameserver 8.8.4.4   sometimes the DNS from the ISP is not reachable, or not correctly delivered by the DHCP to fix you can add this line inside Linux or routers through ssh to add a static Nameserver   add this lines to /etc/systemd/resolved.conf [Resolve]DNS=8.8.8.8FallbackDNS=8.8.4.4   restart systemd resolver by: sudo systemctl daemon-reload && sudo weiterlesen…

TS³ SSH AdminToken

TS3 – Teamspeak 3 – create Server Admin Token above Telnet/SSH 1. restart the TS3-Server above SSH and create a new ServerQueryAdminPasswort  >./ts3server_startscript.sh restart serveradmin_password= 2. Connect by Telnet in Windows (PuTTY / PuttyTray). telnet localhost 10011 3. Login >login serveradmin <password> # select virtual Server if unknown (optional) #Default: >serverlist >use 1 4. Create an weiterlesen…