diff options
Diffstat (limited to 'mysql-test/suite/funcs_1/t')
12 files changed, 0 insertions, 89 deletions
diff --git a/mysql-test/suite/funcs_1/t/charset_collation.test b/mysql-test/suite/funcs_1/t/charset_collation.test index 186eb1f5b85..44199c60251 100644 --- a/mysql-test/suite/funcs_1/t/charset_collation.test +++ b/mysql-test/suite/funcs_1/t/charset_collation.test @@ -18,7 +18,6 @@ DROP USER dbdict_test@localhost; CREATE USER dbdict_test@localhost; ---echo # Establish connection con (user=dbdict_test) connect (con,localhost,dbdict_test,,); ################################################################################ # @@ -100,8 +99,6 @@ ORDER BY collation_name, character_set_name; # Cleanup ---echo # Switch to connection default + disconnect con connection default; disconnect con; DROP USER dbdict_test@localhost; - diff --git a/mysql-test/suite/funcs_1/t/is_basics_mixed.test b/mysql-test/suite/funcs_1/t/is_basics_mixed.test index 21efafb5afa..c0b03a84478 100644 --- a/mysql-test/suite/funcs_1/t/is_basics_mixed.test +++ b/mysql-test/suite/funcs_1/t/is_basics_mixed.test @@ -43,7 +43,6 @@ SHOW DATABASES LIKE 'information_schema'; # # Note: The "for query purposes only" is checked in other tests. # High privileged user (root) ---echo # Switch to connection default connection default; USE test; SELECT DATABASE(); @@ -54,14 +53,12 @@ SELECT DATABASE(); DROP USER 'testuser1'@'localhost'; CREATE USER 'testuser1'@'localhost'; # Low privileged user ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); SELECT DATABASE(); USE information_schema; SELECT DATABASE(); # ---echo # Switch to connection default and close connection testuser1 connection default; disconnect testuser1; DROP USER 'testuser1'@'localhost'; @@ -89,7 +86,6 @@ CREATE DATABASE information_schema; # # 1. High privileged user (root) ---echo # Switch to connection default (user=root) connection default; --source suite/funcs_1/datadict/basics_mixed1.inc @@ -99,12 +95,10 @@ DROP USER 'testuser1'@'localhost'; CREATE USER 'testuser1'@'localhost'; GRANT ALL ON *.* TO testuser1@localhost; SHOW GRANTS FOR testuser1@localhost; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); --source suite/funcs_1/datadict/basics_mixed1.inc ---echo # Switch to connection default (user=root) and close connection testuser1 connection default; disconnect testuser1; DROP USER 'testuser1'@'localhost'; @@ -270,7 +264,6 @@ GRANT CREATE VIEW ON information_schema.* TO 'u_6_401018'@'localhost'; # Check 1: Show that a "simple" user (<> root) has the permission to SELECT # on some INFORMATION_SCHEMA table. ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); SELECT table_schema,table_name FROM information_schema.tables @@ -298,7 +291,6 @@ SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE FROM information_schema.tables WHERE table_schema = 'db_datadict'; GRANT SELECT ON db_datadict.v2 to testuser2@localhost; # ---echo # Establish connection testuser2 (user=testuser2) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , db_datadict); SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE @@ -307,7 +299,6 @@ SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE FROM information_schema.tables WHERE table_schema = 'db_datadict'; # Cleanup ---echo # Switch to connection default and close connections testuser1 and testuser2 connection default; disconnect testuser1; disconnect testuser2; @@ -445,13 +436,11 @@ DROP USER 'testuser1'@'localhost'; CREATE USER 'testuser1'@'localhost'; GRANT ALL ON test.* TO 'testuser1'@'localhost'; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); --source suite/funcs_1/datadict/basics_mixed3.inc # Cleanup ---echo # Switch to connection default and close connections testuser1 and testuser2 connection default; disconnect testuser1; DROP USER 'testuser1'@'localhost'; diff --git a/mysql-test/suite/funcs_1/t/is_column_privileges.test b/mysql-test/suite/funcs_1/t/is_column_privileges.test index cb8c50c01b7..7c0d7c7c063 100644 --- a/mysql-test/suite/funcs_1/t/is_column_privileges.test +++ b/mysql-test/suite/funcs_1/t/is_column_privileges.test @@ -131,17 +131,14 @@ WITH GRANT OPTION; eval $select; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); eval $select; ---echo # Establish connection testuser2 (user=testuser2) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , db_datadict); eval $select; ---echo # Establish connection testuser3 (user=testuser3) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser3, localhost, testuser3, , db_datadict); @@ -158,12 +155,10 @@ GRANT SELECT(f1, f3) ON db_datadict.t1 TO 'testuser2'@'localhost'; --echo # FIXME: Is it intended that *my* grants to others are *NOT* shown here? eval $select; ---echo # Switch to connection testuser2 (user=testuser2) connection testuser2; eval $select; # Cleanup ---echo # Switch to connection default and close connections testuser1,testuser2,testuser3 connection default; disconnect testuser1; disconnect testuser2; @@ -214,71 +209,59 @@ let $my_show = SHOW GRANTS FOR 'testuser1'@'localhost'; eval $my_select; eval $my_show; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); eval $my_select; eval $my_show; ---echo # Switch to connection default connection default; GRANT SELECT (f1,f3) ON db_datadict.my_table TO 'testuser1'@'localhost'; eval $my_select; eval $my_show; ---echo # Switch to connection testuser1 connection testuser1; eval $my_select; eval $my_show; ---echo # Switch to connection default connection default; ALTER TABLE db_datadict.my_table DROP COLUMN f3; GRANT UPDATE (f1) ON db_datadict.my_table TO 'testuser1'@'localhost'; eval $my_select; eval $my_show; ---echo # Switch to connection testuser1 connection testuser1; eval $my_select; eval $my_show; --error ER_BAD_FIELD_ERROR SELECT f1, f3 FROM db_datadict.my_table; ---echo # Switch to connection default connection default; ALTER TABLE db_datadict.my_table CHANGE COLUMN f1 my_col BIGINT; eval $my_select; eval $my_show; ---echo # Switch to connection testuser1 connection testuser1; eval $my_select; eval $my_show; ---echo # Switch to connection default connection default; DROP TABLE db_datadict.my_table; eval $my_select; eval $my_show; ---echo # Switch to connection testuser1 connection testuser1; eval $my_select; eval $my_show; ---echo # Switch to connection default connection default; REVOKE ALL ON db_datadict.my_table FROM 'testuser1'@'localhost'; eval $my_select; eval $my_show; ---echo # Switch to connection testuser1 connection testuser1; eval $my_select; eval $my_show; ---echo # Switch to connection default and close connection testuser1 connection default; disconnect testuser1; DROP USER 'testuser1'@'localhost'; diff --git a/mysql-test/suite/funcs_1/t/is_column_privileges_is_mysql_test.test b/mysql-test/suite/funcs_1/t/is_column_privileges_is_mysql_test.test index 33269fe929c..200ee66e2a1 100644 --- a/mysql-test/suite/funcs_1/t/is_column_privileges_is_mysql_test.test +++ b/mysql-test/suite/funcs_1/t/is_column_privileges_is_mysql_test.test @@ -45,7 +45,6 @@ eval $my_show1; eval $my_show2; eval $my_show3; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); eval $my_select; @@ -54,7 +53,6 @@ eval $my_show2; eval $my_show3; # Cleanup ---echo # Switch to connection default and close connection testuser1 connection default; DROP USER 'testuser1'@'localhost'; DROP DATABASE db_datadict; diff --git a/mysql-test/suite/funcs_1/t/is_columns.test b/mysql-test/suite/funcs_1/t/is_columns.test index c5fe18fef20..5fb72713742 100644 --- a/mysql-test/suite/funcs_1/t/is_columns.test +++ b/mysql-test/suite/funcs_1/t/is_columns.test @@ -148,7 +148,6 @@ eval $my_show1; eval $my_show2; eval $my_show3; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); --source suite/funcs_1/datadict/datadict_bug_12777.inc @@ -158,7 +157,6 @@ eval $my_show1; eval $my_show2; eval $my_show3; ---echo # Establish connection testuser2 (user=testuser2) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , db_datadict); --source suite/funcs_1/datadict/datadict_bug_12777.inc @@ -169,7 +167,6 @@ eval $my_show2; --error ER_TABLEACCESS_DENIED_ERROR eval $my_show3; ---echo # Switch to connection default and close connections testuser1, testuser2 connection default; disconnect testuser1; disconnect testuser2; diff --git a/mysql-test/suite/funcs_1/t/is_schema_privileges.test b/mysql-test/suite/funcs_1/t/is_schema_privileges.test index 1f408d71b39..fdf09a6f94b 100644 --- a/mysql-test/suite/funcs_1/t/is_schema_privileges.test +++ b/mysql-test/suite/funcs_1/t/is_schema_privileges.test @@ -115,7 +115,6 @@ ORDER BY grantee,table_schema,privilege_type; let $show_testuser1 = SHOW GRANTS FOR 'testuser1'@'localhost'; let $show_testuser2 = SHOW GRANTS FOR 'testuser2'@'localhost'; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); GRANT SELECT ON db_datadict_4.* TO 'testuser2'@'localhost'; @@ -132,7 +131,6 @@ eval $show_testuser1; --error ER_DBACCESS_DENIED_ERROR eval $show_testuser2; ---echo # Establish connection testuser2 (user=testuser2) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , test); --echo # Root granted SELECT db_datadict_1 to me -> visible @@ -145,7 +143,6 @@ eval $my_select; eval $show_testuser1; eval $show_testuser2; ---echo # Switch to connection default and close connections testuser1 and testuser2 connection default; disconnect testuser1; disconnect testuser2; @@ -197,73 +194,55 @@ ORDER BY grantee,table_schema,privilege_type; ############ Check grant SCHEMA eval $my_select; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); eval $my_select; ---echo # Switch to connection default connection default; GRANT UPDATE ON db_datadict.* TO 'testuser1'@'localhost'; eval $my_select; ---echo # Switch to connection testuser1 eval $my_select; ############ Check RENAME SCHEMA # Implement this if RENAME SCHEMA is again available. # Note(mleich): I expect that RENAME has no impact on the result sets, because # the schema_name is not migrated. -# --echo # Switch to connection default # connection default; # RENAME SCHEMA db_datadict TO db_datadictx; # eval $my_select; -# --echo # Switch to connection testuser1 # eval $my_select; # RENAME SCHEMA db_datadictx TO db_datadict; ############ Check extend PRIVILEGES (affects PRIVILEGE_TYPE) on SCHEMA ---echo # Switch to connection default connection default; GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost'; eval $my_select; ---echo # Switch to connection testuser1 eval $my_select; ############ Check extend PRIVILEGES (affects IS_GRANTABLE) on SCHEMA --echo # Switch to connection default connection default; GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost' WITH GRANT OPTION; eval $my_select; ---echo # Switch to connection testuser1 eval $my_select; ############ Check DROP SCHEMA # No impact, because there is no "maintenance" of privileges. ---echo # Switch to connection default connection default; DROP SCHEMA db_datadict; eval $my_select; ---echo # Switch to connection testuser1 eval $my_select; ############ Check REVOKE PRIVILEGE ---echo # Switch to connection default connection default; REVOKE UPDATE ON db_datadict.* FROM 'testuser1'@'localhost'; eval $my_select; ---echo # Switch to connection testuser1 eval $my_select; ############ Check RENAME USER ---echo # Switch to connection default connection default; RENAME USER 'testuser1'@'localhost' TO 'the_user'@'localhost'; eval $my_select; ---echo # Switch to connection testuser1 eval $my_select; ---echo # Close connection testuser1 disconnect testuser1; ---echo # Establish connection the_user (user=the_user) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (the_user, localhost, the_user, , test); eval $my_select; ---echo # Close connection the_user disconnect the_user; ############ Check DROP USER ---echo # Switch to connection default connection default; eval $my_select; DROP USER 'the_user'@'localhost'; diff --git a/mysql-test/suite/funcs_1/t/is_schema_privileges_is_mysql_test.test b/mysql-test/suite/funcs_1/t/is_schema_privileges_is_mysql_test.test index 3f60f71fe9a..f1e0d571057 100644 --- a/mysql-test/suite/funcs_1/t/is_schema_privileges_is_mysql_test.test +++ b/mysql-test/suite/funcs_1/t/is_schema_privileges_is_mysql_test.test @@ -45,7 +45,6 @@ eval $my_show1; eval $my_show2; eval $my_show3; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); eval $my_select; @@ -54,8 +53,6 @@ eval $my_show2; eval $my_show3; # Cleanup ---echo # Switch to connection default and close connection testuser1 connection default; DROP USER 'testuser1'@'localhost'; DROP DATABASE db_datadict; - diff --git a/mysql-test/suite/funcs_1/t/is_schemata_is_mysql_test.test b/mysql-test/suite/funcs_1/t/is_schemata_is_mysql_test.test index 9bfbf0cf335..6b515bc596a 100644 --- a/mysql-test/suite/funcs_1/t/is_schemata_is_mysql_test.test +++ b/mysql-test/suite/funcs_1/t/is_schemata_is_mysql_test.test @@ -45,7 +45,6 @@ eval $my_show1; eval $my_show2; eval $my_show3; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); eval $my_select; @@ -54,8 +53,6 @@ eval $my_show2; eval $my_show3; # Cleanup ---echo # Switch to connection default and close connection testuser1 connection default; DROP USER 'testuser1'@'localhost'; DROP DATABASE db_datadict; - diff --git a/mysql-test/suite/funcs_1/t/is_statistics.test b/mysql-test/suite/funcs_1/t/is_statistics.test index 458892a6d91..3cdc5568960 100644 --- a/mysql-test/suite/funcs_1/t/is_statistics.test +++ b/mysql-test/suite/funcs_1/t/is_statistics.test @@ -139,7 +139,6 @@ eval $my_select; eval $my_show1; eval $my_show2; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , test); # nothing visible for testuser1 @@ -148,7 +147,6 @@ eval $my_show1; --error ER_DBACCESS_DENIED_ERROR eval $my_show2; ---echo # Establish connection testuser2 (user=testuser2) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , test); # nothing visible for testuser2 @@ -157,7 +155,6 @@ eval $my_select; eval $my_show1; eval $my_show2; ---echo # Switch to connection default connection default; GRANT SELECT ON db_datadict.t1 TO 'testuser1'@'localhost' WITH GRANT OPTION; GRANT SELECT(f1,f5) ON db_datadict_2.t3 TO 'testuser1'@'localhost'; @@ -165,33 +162,28 @@ eval $my_select; eval $my_show1; eval $my_show2; ---echo # Switch to connection testuser1 connection testuser1; eval $my_select; eval $my_show1; --error ER_DBACCESS_DENIED_ERROR eval $my_show2; ---echo # Switch to connection testuser2 connection testuser2; eval $my_select; --error ER_DBACCESS_DENIED_ERROR eval $my_show1; eval $my_show2; ---echo # Switch to connection default connection default; REVOKE SELECT,GRANT OPTION ON db_datadict.t1 FROM 'testuser1'@'localhost'; eval $my_show1; ---echo # Switch to connection testuser1 # nothing visible for testuser1 connection testuser1; eval $my_select; eval $my_show1; # Cleanup ---echo # Switch to connection default and close connections testuser1, testuser2 connection default; disconnect testuser1; disconnect testuser2; diff --git a/mysql-test/suite/funcs_1/t/is_table_constraints.test b/mysql-test/suite/funcs_1/t/is_table_constraints.test index 79766fc1dff..d1659517e79 100644 --- a/mysql-test/suite/funcs_1/t/is_table_constraints.test +++ b/mysql-test/suite/funcs_1/t/is_table_constraints.test @@ -132,7 +132,6 @@ eval $my_show1; --replace_column 6 ### 7 ### 8 ### 9 ### 10 ### 11 ### 12 ### eval $my_show2; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); SHOW GRANTS FOR 'testuser1'@'localhost'; @@ -143,7 +142,6 @@ eval $my_show1; eval $my_show2; # Cleanup ---echo # Switch to connection default and close connection testuser1 connection default; disconnect testuser1; DROP USER 'testuser1'@'localhost'; diff --git a/mysql-test/suite/funcs_1/t/is_table_privileges.test b/mysql-test/suite/funcs_1/t/is_table_privileges.test index 5ea0dd7c6a7..df28f2caaef 100644 --- a/mysql-test/suite/funcs_1/t/is_table_privileges.test +++ b/mysql-test/suite/funcs_1/t/is_table_privileges.test @@ -115,7 +115,6 @@ let $my_select = SELECT * FROM information_schema.table_privileges WHERE table_name LIKE 'tb%' ORDER BY grantee,table_schema,table_name,privilege_type; ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); --replace_result $other_engine_type <other_engine_type> @@ -126,21 +125,18 @@ GRANT SELECT ON db_datadict.tb3 TO 'testuser3'@'localhost'; eval $my_select; SHOW GRANTS FOR 'testuser1'@'localhost'; ---echo # Establish connection testuser2 (user=testuser3) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , db_datadict); # we see only table privileges for this user, and not any other privileges eval $my_select; SHOW GRANTS FOR 'testuser2'@'localhost'; ---echo # Establish connection testuser3 (user=testuser3) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser3, localhost, testuser3, , db_datadict); # we see only table privileges for this user, and not any other privileges eval $my_select; SHOW GRANTS FOR 'testuser3'@'localhost'; ---echo # Switch to connection default and close the other connections connection default; disconnect testuser1; disconnect testuser2; diff --git a/mysql-test/suite/funcs_1/t/is_user_privileges.test b/mysql-test/suite/funcs_1/t/is_user_privileges.test index 0f0e398d75b..a61e9187d15 100644 --- a/mysql-test/suite/funcs_1/t/is_user_privileges.test +++ b/mysql-test/suite/funcs_1/t/is_user_privileges.test @@ -117,7 +117,6 @@ eval $my_select1; eval $my_select2; --horizontal_results ---echo # Establish connection testuser1 (user=testuser1) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser1, localhost, testuser1, , db_datadict); --vertical_results @@ -129,7 +128,6 @@ eval $my_show; --echo --echo # Now add SELECT on *.* to testuser1; ---echo # Switch to connection default connection default; GRANT SELECT ON *.* TO 'testuser1'@'localhost'; --echo # @@ -147,7 +145,6 @@ eval $my_select1; eval $my_select2; --horizontal_results ---echo # Switch to connection testuser1 # check that this appears connection testuser1; --vertical_results @@ -156,7 +153,6 @@ eval $my_select2; --horizontal_results eval $my_show; ---echo # Establish connection testuser2 (user=testuser2) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser2, localhost, testuser2, , db_datadict); --vertical_results @@ -166,7 +162,6 @@ eval $my_select2; --horizontal_results eval $my_show; ---echo # Establish connection testuser3 (user=testuser3) --replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK connect (testuser3, localhost, testuser3, , test); --vertical_results @@ -178,7 +173,6 @@ eval $my_show; --echo --echo # Revoke privileges from testuser1; ---echo # Switch to connection default connection default; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testuser1'@'localhost'; --vertical_results @@ -186,7 +180,6 @@ eval $my_select1; eval $my_select2; --horizontal_results ---echo # Switch to connection testuser1 # check for changes connection testuser1; --vertical_results @@ -211,7 +204,6 @@ CREATE TABLE db_datadict.tb_66 ( c1 TEXT ); --echo --echo # Add ALL on db_datadict.* (and select on mysql.user) to testuser1; ---echo # Switch to connection default connection default; GRANT ALL ON db_datadict.* TO 'testuser1'@'localhost' WITH GRANT OPTION; GRANT SELECT ON mysql.user TO 'testuser1'@'localhost'; @@ -220,7 +212,6 @@ eval $my_select1; eval $my_select2; --horizontal_results ---echo # Switch to connection testuser1 connection testuser1; --vertical_results eval $my_select1; @@ -246,7 +237,6 @@ ENGINE = $other_engine_type; --echo --echo # Revoke privileges from testuser1; ---echo # Switch to connection default connection default; REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'testuser1'@'localhost'; --vertical_results @@ -254,7 +244,6 @@ eval $my_select1; eval $my_select2; --horizontal_results ---echo # Switch to connection testuser1 # check for changes connection testuser1; --vertical_results @@ -278,7 +267,6 @@ CREATE TABLE db_datadict.tb_59 ( c1 TEXT ) ENGINE = $other_engine_type; # Cleanup ---echo # Switch to connection default and close connections testuser1,testuser2,testuser3 connection default; disconnect testuser1; disconnect testuser2; |