Tutorials - Other

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

Standard weights:

medium -> font-weight : 500;

semi-bold ->font-weight : 600;

Font Face

Example

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

Step 1: remove all history

rm -rf .git

Those are three functions allow you to determine the nature of a variable, with a bit different.

Comparison table

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

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;

To repair a broken grub boot from a linux live CD/DVD/USB. For the grub2 EFI boot from uEFI mode and BIOS for BIOS mode.

Then install boot-repair tool from PPA

#Add PPA

sudo add-apt-repository ppa:yannubuntu/boot-repair

#Update apt

sudo apt-get update

1. get THE UUID from blkid

Ex    /dev/mapper/encrypted-partition: UUID="d62cb037-e5ba-4f49-a92a-69705e4bae2b" TYPE="crypto_LUKS"

not    /dev/mapper/luks-d62cb037-e5ba-4f49-a92a-69705e4bae2b: UUID="f6d930b6-b75b-440c-9b41-67ed538bdd75" TYPE="ext4"