diff options
Diffstat (limited to 'mysql-test/t/secure_auth_func.test')
| -rw-r--r-- | mysql-test/t/secure_auth_func.test | 132 |
1 files changed, 0 insertions, 132 deletions
diff --git a/mysql-test/t/secure_auth_func.test b/mysql-test/t/secure_auth_func.test deleted file mode 100644 index 10dc383035d..00000000000 --- a/mysql-test/t/secure_auth_func.test +++ /dev/null @@ -1,132 +0,0 @@ -############# mysql-test\t\secure_auth_func.test ########################## -# # -# Variable Name: secure_auth # -# Scope: GLOBAL # -# Access Type: Dynamic # -# Data Type: boolean # -# Default Value: FALSE # -# Values: TRUE / 1, FALSE / 0 # -# # -# # -# Creation Date: 2008-02-22 # -# Author: Sharique Abdullah # -# # -# Description: Test Cases of Dynamic System Variable "secure_auth " # -# that checks behavior of this variable in the following ways# -# * Default Value # -# * Valid & Invalid values # -# * Scope & Access method # -# * Cache behaviors # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html#option_mysqld_secure_auth # -# # -########################################################################### - ---echo ** Setup ** ---echo -# -# Setup -# - ---source include/not_embedded.inc - -# -# Save initial value -# - -SET @old_secure_auth = @@GLOBAL.secure_auth; - ---echo '#--------------------FN_DYNVARS_144_01-------------------------#' -# -# Testing command line option value -# - -SELECT @@GLOBAL.secure_auth; ---echo 1 / ON Expected - ---echo '#--------------------FN_DYNVARS_144_02-------------------------#' -# -# Value OFF -# -SET GLOBAL secure_auth = OFF; - -# -# Creating user with password in NEW format -# -CREATE USER 'testUser'@'localhost' IDENTIFIED BY 'newpass'; - ---echo ** Connecting con_user1 using testUser ** -connect (con_user1,localhost,testUser,newpass,); - ---echo ** Connection default** -connection default; - -# -# Setting password in OLD format -# -SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass'); - ---echo ** Connecting con_user2 using testUser ** -connect (con_user2,localhost,testUser,newpass,); - ---echo ** Connection default** -connection default; - ---echo '#--------------------FN_DYNVARS_144_03-------------------------#' -# -# Value ON -# -SET GLOBAL secure_auth = ON; - -# -# Setting password in NEW format -# -SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass'); - ---echo ** Connecting con_user3 using testUser ** -connect (con_user3,localhost,testUser,newpass,); ---echo ** Connection default ** -connection default; - -# -# Setting password in OLD format -# -SET PASSWORD FOR 'testUser'@'localhost' = OLD_PASSWORD('newpass'); - ---echo ** Connecting con_user4 using testUser ** ---disable_query_log ---error ER_SERVER_IS_IN_SECURE_AUTH_MODE -connect (con_user4,localhost,testUser,newpass,); ---enable_query_log ---echo Expected error "Server is in secure auth mode" - ---echo ** Connection default** -connection default; - -# -# Setting password back in NEW format -# -SET PASSWORD FOR 'testUser'@'localhost' = PASSWORD('newpass'); - ---echo ** Connecting con_user4 using testUser ** -connect (con_user4,localhost,testUser,newpass,); - ---echo ** Connection default ** -connection default; - -# -# Cleanup -# - -SET GLOBAL secure_auth = @old_secure_auth; - ---echo Disconnecting Connections con_user1, con_user2, con_user3, con_user4 -disconnect con_user1; -disconnect con_user2; -disconnect con_user3; -disconnect con_user4; - -REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testUser'@'localhost'; - -DROP USER 'testUser'@'localhost'; |