Solutions

Solution Exercice 1 :

CREATE USER 'jean'@'%' IDENTIFIED BY 'JeanSecurePass!23' REQUIRE SSL;

Solution Exercice 2 :

[mysqld]
plugin-load-add=validate_password.so
validate_password.policy=MEDIUM

Puis, changez le mot de passe de jean :

ALTER USER 'jean'@'%' IDENTIFIED BY 'JeanNewStrongPass!2024';

Solution Exercice 3 :

UPDATE mysql.user SET Host='localhost' WHERE User='root';
FLUSH PRIVILEGES;