MySQL

SSL

Création de la clé privée

• On se place dans le dossier /etc/ssl/private qui contient les clés et certificats privées :

cd /etc/ssl/private

• On génère la clé privée :

sudo openssl genrsa -out mysql.key 2048

Cette clé va nous permettre de signer nos propres certificats.

Création du certificat auto-signé

• On lance la création de certificat auto-signé :

openssl req -new -x509 -nodes -days 500 -key mysql.key -out mysql.crt You are about to be asked to enter information that will be incorporated into your certificate request. What you are about to enter is what is called a Distinguished Name or a DN. There are quite a few fields but you can leave some blank For some fields there will be a default value, If you enter '.', the field will be left blank. - - - -- Country Name (2 letter code) [AU]:FR State or Province Name (full name) [Some-State]:Lunan Locality Name (eg, city) []:Lunan Organization Name (eg, company) [Internet Widgits Pty Ltd]:NCad Network Organizational Unit Name (eg, section) []:Intranet Goulouxiou Common Name (e.g. server FQDN or YOUR name) []:10.0.0.47 Email Address []:tech@ncad.fr