diff options
Diffstat (limited to 'mysql-test/main/skip_grants.test')
| -rw-r--r-- | mysql-test/main/skip_grants.test | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/mysql-test/main/skip_grants.test b/mysql-test/main/skip_grants.test index 7594285aed7..b74cd41b039 100644 --- a/mysql-test/main/skip_grants.test +++ b/mysql-test/main/skip_grants.test @@ -160,7 +160,7 @@ alter user baz@baz identified with mysql_native_password as password("baz"); show create user baz@baz; drop user bar@foo; drop user baz@baz; -# need to restart the server to restore the --skip-grant state +# Need to restart the server to restore the "--skip-grant-tables" state --source include/restart_mysqld.inc --enable_ps_protocol @@ -168,3 +168,22 @@ drop user baz@baz; --echo # --echo # End of 10.3 tests --echo # + +--echo # +--echo # MDEV-24815 Show "--skip-grant-tables" state in SYSTEM VARIABLES +--echo # + +SELECT @@skip_grant_tables AS EXPECT_1; + +# Also check when the server starts without "--skip-grant-table" option +--let $restart_parameters = "--skip-skip-grant-tables" +--source include/restart_mysqld.inc +SELECT @@skip_grant_tables AS EXPECT_0; + +# Need to restart the server to restore the "--skip-grant-tables" state +--let $restart_parameters = "--skip-grant-tables" +--source include/restart_mysqld.inc + +--echo # +--echo # End of 10.10 tests +--echo # |