設定が有効になっているか確認
SHOW VARIABLES LIKE '%ssl%';
SSL接続を強制する
「REQUIRE SSL」を付与
GRANT ALL PRIVILEGES ON *.* TO user_name@'%' IDENTIFIED BY 'password' REQUIRE SSL;
トラブル
警告：Establishing SSL connection without server's ・・・が表示
* Javaでアクセスしたら、以下のような警告内容が表示される
警告内容
Sat Dec 03 12:58:35 JST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
対応策
* useSSL=true/falseを付与する
# SSLを使わないなら・・・
jdbc:mysql://・・・?useSSL=false
