apt-get install tmux apt-get install mariadb-server mysql_secure_installation create user ‘username’ @ ‘%’ identified by ‘password’; grant all privileges on *. * to ‘username’ @ ‘%’ identified by ‘password’; download privileges; systemctl restart mysql nano /etc/mysql/mariadb.conf.d/50-server.cnf (scroll down and change the binding address to 0.0.0.0 and press ctrl + O and enter and ctrl + X)[Use this if you are getting error connecting to database]
apt-get install ufw (This is for the firewall that will protect your server) ufw allow ssh ufw allow 3306 / tcp ufw allow 40 120 ufw allow 30 120 ufw enable Putty- https://www.putty.org/
Heidisql- https://www.heidisql.com/
https://zap-hosting.com/benchmarks
GuardiaN071-a-3338 Use the above coupon code while making the payment, which will give you 20% permanently. I like it and don’t forget to subscribe to the channel. Comment if you need help. .
Source Link
COMMENTS