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 6ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 7ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 8TLS1.2 ciphers: user requires SSLv3 cipher AES128-SHA 9ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 10ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 11TLS1.2 ciphers: user requires TLSv1.2 cipher AES128-SHA256 12ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 13ERROR 2026 (HY000): SSL connection error: sslv3 alert handshake failure 14SSLv3 ciphers: user is ok with any cipher 15Variable_name Value 16Ssl_cipher AES256-SHA 17Variable_name Value 18Ssl_cipher DHE-RSA-AES256-SHA 19SSLv3 ciphers: user requires SSLv3 cipher AES128-SHA 20Variable_name Value 21Ssl_cipher AES128-SHA 22ERROR 1045 (28000): Access denied for user 'ssl_sslv3'@'localhost' (using password: NO) 23SSLv3 ciphers: user requires TLSv1.2 cipher AES128-SHA256 24ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) 25ERROR 1045 (28000): Access denied for user 'ssl_tls12'@'localhost' (using password: NO) 26drop user ssl_sslv3@localhost; 27drop user ssl_tls12@localhost; 28