Server

Install Apache following this tutorial

Activate SSL Module

sudo a2enmod ssl

sudo service apache2 force-reload

#Or sudo /etc/init.d/apache2 force-reload

Example:

Repair all tables

mysqlcheck -u root -p --auto-repair --check --all-databases

Repair a database

mysqlcheck -u root -p  --repair --databases databasesname

Let's Encrypt is a free, automated, and open certificate authority allow you to get SSL / TLS Certificates for free of charge.

https://letsencrypt.org/

1. How to regain access to Webmin with IP Access Control enabled

Edit : /etc/webmin/miniserv.conf

Add your IP to : "allow"

Example :

allow=12.34.56.78 98.76.54.32

This is the brute-force method. It also removes the configuration of the repository.

Step 1: remove all history

rm -rf .git

For that, regenerate locals and setup locale settings.

Generate locals

Ex:# locale-gen en_US.UTF-8

Or :# locale-gen fr_FR.UTF-8

An also you can use # localedef -i en_US -f UTF-8 en_US.UTF-8

Probleme 1. Showing /index.php/clean_url_path

Show all columns of a table.

Syntax: SHOW COLUMNS FROM the_table_name;

Example: Show all columns of the mysql user table.

mysql> SHOW COLUMNS FROM mysql.user;

Bind

#Bind normal www dir and mysql dir to another directory

/home/DATA/mysql/ /var/lib/mysql    none    bind

/home/DATA/www/ /var/www            none    bind