In early 2020, the World Economic Forum (WEF) published an annual report on global risks, and oddly enough, cybercrime was one of the five global risks for all of humanity! Cyber attacks on infrastructure, the destruction of natural ecosystems, extreme heat waves, political polarization and economic confrontations are ranked in […]
How To Enable Automatic Updates on Linux
Keeping your services up to date is very important and at the same time a very simple task. This requires a small amount of time, and in turn, it is critically necessary in order to secure your data. Before making any changes to your server, you should be familiar with […]
How To Use The DENSE_RANK () Function on MySQL
DENSE_RANK () is a window function that assigns the rank of each row within a section or result set without spaces in the ranking of values.The row rank is increased by one from among the different rank values that go before the row. The syntax for the DENSE_RANK () function […]
How To Use The Whoami Command on Linux
The Whoami command prints the username with a valid user ID. This command is able to display the name of the logged in user. Using whoami Command syntax whoami [OPTION] To display the username, enter the following: whoami Next, you will see the username (example – user1): user1 The command […]
How To Use Uptime Command on Linux
The main goal of the Uptime team is to show how long the system has been running. Also, this command will display the time for you, the number of registered users as well as the average load of your system. Using Uptime The syntax for this command is as follows: […]
How To Enable The General MySQL Query Log on Linux
There are two potential possibilities to accomplish this: 1. Add to my.cnf file permanently or 2. include general queries for MySQL on versions higher than 5.1.29 1. Add to my.cnf file forever vim /etc/my.cnf log = /home/general-query.log Install via MySQL Console SET general_log = 1; Start server systemctl restart mysqld […]
How to Install and Use Curl on CentOS 8
Curl is a command line tool for transferring data from or to a remote server. With curl, you can upload data using various network protocols such as HTTP, SFTP, FTP, HTTPS and SCP. Install Curl on CentOS The Curl package is available in the standard CentOS 8 repositories. To install […]
How to Install Dotclear on Ubuntu 16.04
Dotclear is very popular today. It is a simple blogging engine built around PHP. It contains: Automatic installation Multi-blog and multi-user Static Pages Media manager Custom layout For a successful installation, you need a VPS server with a LAMP stack in Ubuntu 16.04. On most stacks, files for the entire […]
How To Install HTMLDoc on Fedora 29
HTMLDoc is a special dynamic postscript document parser (PDF 1.6). This guide is intended to install HTMLDoc on Fedora 29. After installing HTMLDoc, the creation of a simple one-page document will continue without any headers, footers, borders, or additional elements. Install HTMLDoc First you need to log in to your […]
How To Install HTMLDoc on Ubuntu 18.04
HTMLDoc is a special dynamic postscript document parser (PDF 1.6). This guide is intended to install HTMLDoc on Ubuntu 18.04. After installing HTMLDoc, the creation of a simple one-page document will continue without any headers, footers, borders, or additional elements. Preparing Ubuntu 18.04 for HTMLDoc First, we need to check […]