|
1
by brian
clean slate |
1 |
# Test of grants when lower_case_table_names is on |
2 |
use mysql; |
|
3 |
||
4 |
# mixed-case database name for testing |
|
5 |
create database MYSQLtest; |
|
6 |
||
7 |
# check that database name gets forced to lowercase |
|
8 |
grant all on MySQLtest.* to mysqltest_1@localhost; |
|
9 |
show grants for mysqltest_1@localhost; |
|
10 |
||
11 |
# now force it to mixed case, but see that it is lowercased in the acl cache |
|
12 |
select * from db where user = 'mysqltest_1'; |
|
13 |
update db set db = 'MYSQLtest' where db = 'mysqltest' and user = 'mysqltest_1' and host = 'localhost'; |
|
14 |
flush privileges; |
|
15 |
show grants for mysqltest_1@localhost; |
|
16 |
select * from db where user = 'mysqltest_1'; |
|
17 |
||
18 |
# clear out the user we created |
|
19 |
#
|
|
20 |
# can't use REVOKE because of the mixed-case database name |
|
21 |
delete from db where db = 'MYSQLtest' and user = 'mysqltest_1' and host = 'localhost'; |
|
22 |
flush privileges; |
|
23 |
drop user mysqltest_1@localhost; |
|
24 |
||
25 |
drop database MYSQLtest; |
|
26 |
||
27 |
# End of 4.1 tests |