This post is to summarize the steps to install MySQL DB on CentOS/Ubuntu and illustrate how to generate the db data then populate them into your MySQL Database. Install MySQL DB on CentOS7 A couple of steps: 1 Setup Yum Repository rpm -Uvh https://ift.tt/2F9V4ai 2 Install MySQL 8 Community Server Version Disable all repositories in mysql repo file: sed -i ‘s/enabled=1/enabled=0/’ /etc/yum.repos.d/mysql-community.repo Execute following command to install: yum –enablerepo=mysql80-community install mysql-community-server 3 Start MySQL Service service mysqld start…
Posts published in “Linux”
xRDP protocol is a bit slow to connect based on my previous testing. This time, I am trying to use VNC protocol to do connection, which has been proven much faster than xRDP.
My previous post "Connect to GNOME desktop environment via xRDP on CentOS 7 & Ubuntu 18" shows how to use RDP client connecting to linux but connection speed is too slow for regular operation. Compared both, VNC solution is much better for daily operation remote control experience when using it on Linux server.
Most Cloud Providers do not allow you to log in directly using Password. It will ask you to use public/private key to log in. This post is using AWS EC2 instance as an example to enable password authentication for your SSH session. This is not recommended and only for your testing purpose. It dramatically lows down your security configuration.
Ngx_lua_waf is a web application firewall based on lua-nginx-module.
- Prevent SQL injection, local inclusion, partial overflow, fuzzing, xss, SSRF and other web attacks
- Prevent file leaks, such as svn / backup
- Prevent attacks from stress testing tools such as ApacheBench
- Block common scanning hacking tools, scanners
- Block unusual network requests
- Block image attachment class directory php execute permission
- Prevent webshell uploads
Certbot website has explained very well all steps for most of linux OS and situation. You wont get wrong as long as you read the steps carefully. https://certbot.eff.org/
This post is to record those steps on my Nginx web server running on CentOS 7 for my own notes:
The default SSH port on all Operating Systems is port 22. For security measures, it is recommended to use other port instead, such as 2222, 2200. The configuration file located in /etc/ssh/sshd_config folder