diff options
Diffstat (limited to 'mysql-test/main/require_secure_transport.result')
-rw-r--r-- | mysql-test/main/require_secure_transport.result | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/mysql-test/main/require_secure_transport.result b/mysql-test/main/require_secure_transport.result index c9df2f90..570f868b 100644 --- a/mysql-test/main/require_secure_transport.result +++ b/mysql-test/main/require_secure_transport.result @@ -1,8 +1,17 @@ -CREATE TABLE t1 (t int(1)); SET GLOBAL require_secure_transport=ON; -ERROR 28000: Access denied for user 'root'@'localhost' (using password: NO) +connect(localhost,root,,test,MASTER_PORT,MASTER_SOCKET); +connect without_ssl,localhost,root,,,,,TCP NOSSL; +ERROR 08004: Connections using insecure transport are prohibited while --require_secure_transport=ON. +connect with_ssl,localhost,root,,,,,TCP SSL; +SELECT (VARIABLE_VALUE <> '') AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher'; +have_ssl +1 +disconnect with_ssl; connection default; SET GLOBAL require_secure_transport=OFF; +connect without_ssl,localhost,root,,,,,TCP NOSSL; +SELECT (VARIABLE_VALUE <> '') AS have_ssl FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME='Ssl_cipher'; +have_ssl +0 disconnect without_ssl; connection default; -DROP TABLE t1; |