1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
--source include/big_test.inc
--source include/not_valgrind.inc
--let $MYSQLD_DATADIR= `select @@datadir`
--source include/mysql_upgrade_preparation.inc
--echo # FR7: test upgrade
REVOKE FLUSH_TABLES, FLUSH_USER_RESOURCES, FLUSH_STATUS,
FLUSH_OPTIMIZER_COSTS ON *.* FROM root@localhost;
--echo # Should be empty
SELECT GRANTEE, PRIVILEGE_TYPE, IS_GRANTABLE FROM INFORMATION_SCHEMA.USER_PRIVILEGES
WHERE PRIVILEGE_TYPE LIKE 'FLUSH_%' ORDER BY 1,2,3;
CREATE USER wl14303@localhost, wl14303_no_reload@localhost;
GRANT RELOAD ON *.* TO wl14303@localhost;
--echo # Should contain root@localhost and wl14303@localhost
SELECT GRANTEE, PRIVILEGE_TYPE, IS_GRANTABLE FROM INFORMATION_SCHEMA.USER_PRIVILEGES
WHERE PRIVILEGE_TYPE = 'RELOAD' ORDER BY 1,2,3;
--let $restart_parameters = restart:--upgrade=FORCE
--let $wait_counter= 10000
--source include/restart_mysqld.inc
--echo # Restart server with defaults
--let $restart_parameters = restart:
--source include/restart_mysqld.inc
--echo # Success criteria: should contain 8 rows: 4 for root and 4 for wl14303
SELECT GRANTEE, PRIVILEGE_TYPE, IS_GRANTABLE FROM INFORMATION_SCHEMA.USER_PRIVILEGES
WHERE PRIVILEGE_TYPE LIKE 'FLUSH_%' ORDER BY 1,2,3;
DROP USER wl14303@localhost, wl14303_no_reload@localhost;
--echo # Cleanup
--source include/mysql_upgrade_cleanup.inc
--echo # End of 8.0 tests
|
