Optimize MySQL Performance with Mysqltuner

MySQL Optimization

This short tutorial describes the steps to optimize the performance of a MySQL database with the mysqltuner script. This tool can be used for MySQL and MariaDB. Install mysqltuner The mysqltuner High-Performance MySQL Tuning Script is available as a package on Debian 10 and Ubuntu 20.04, install it with at: sudo apt install mysqltuner For ... Read more

How to set a VNC password

VNC Password

The Linux TigerVNC Server provides a command to set a new password. Set VNC Password The command is "vncpasswd", the password is stored in encrypted form into the file ~/.vnc/passwd of the home directory of the user. Run: vncpasswd to set a new password for the currently logged-in user. The command will then prompt for the ... Read more

How to enable auto updates in Ubuntu 20.04

Ubuntu Auto Update

It is important to keep your Linux server up to date with security updates. Linux distributions like Ubuntu and Debian release updates on a daily basis, so keeping the system up-to-date can become a tedious task. Fortunately, there is an option to install security updates automatically. Here are the steps to enable automatic security updates ... Read more

How to convert filenames or text to lowercase on the Linux command line

Linux tolower command

There is no simple 'tolower' command on the bash, but you can convert uppercase characters to lowercase with a little shell script. The script uses the tr command internally for converting the chars. Create a shell script with the name 'tolower' that converts all text that is given as a command-line argument to lower case: ... Read more