📄 lowercase_table_grant.test
字号:
# Don't test with embedded server-- source include/not_embedded.inc# Test of grants when lower_case_table_names is onuse mysql;# mixed-case database name for testingcreate database MYSQLtest;# check that database name gets forced to lowercasegrant all on MySQLtest.* to mysqltest_1@localhost;show grants for mysqltest_1@localhost;# now force it to mixed case, but see that it is lowercased in the acl cacheselect * from db where user = 'mysqltest_1';update db set db = 'MYSQLtest' where db = 'mysqltest' and user = 'mysqltest_1' and host = 'localhost';flush privileges;show grants for mysqltest_1@localhost;select * from db where user = 'mysqltest_1';# clear out the user we created## can't use REVOKE because of the mixed-case database namedelete from db where db = 'MYSQLtest' and user = 'mysqltest_1' and host = 'localhost';flush privileges;drop user mysqltest_1@localhost;drop database MYSQLtest;# End of 4.1 tests
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -