1create user ssl_sslv3@localhost; 2grant select on test.* to ssl_sslv3@localhost require cipher "AES128-SHA"; 3create user ssl_tls12@localhost; 4grant select on test.* to ssl_tls12@localhost require cipher "AES128-SHA256"; 5TLS1.2 ciphers: user is ok with any cipher 6Variable_name Value 7Ssl_cipher AES128-SHA256 8Variable_name Value 9Ssl_cipher DHE-RSA-AES256-GCM-SHA384 10TLS1.2 ciphers: user requires SSLv3 cipher AES128-SHA 11ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) 12ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) 13TLS1.2 ciphers: user requires TLSv1.2 cipher AES128-SHA256 14Variable_name Value 15Ssl_cipher AES128-SHA256 16ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) 17SSLv3 ciphers: user is ok with any cipher 18ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 19ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 20SSLv3 ciphers: user requires SSLv3 cipher AES128-SHA 21ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 22ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 23SSLv3 ciphers: user requires TLSv1.2 cipher AES128-SHA256 24ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 25ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 26drop user ssl_sslv3@localhost; 27drop user ssl_tls12@localhost; 28