diff options
author | unknown <msvensson@neptunus.(none)> | 2006-05-29 15:05:31 +0200 |
---|---|---|
committer | unknown <msvensson@neptunus.(none)> | 2006-05-29 15:05:31 +0200 |
commit | 88a3ee71e3c35b28c9223ccd2d592c05f73d0c11 (patch) | |
tree | 0d41717c8178e064c005be4ebfd8b50daec857af /mysql-test/r/grant.result | |
parent | 8d28735d1359adf1a8fbcc86b82373bf3df8343c (diff) | |
download | mariadb-git-88a3ee71e3c35b28c9223ccd2d592c05f73d0c11.tar.gz |
Update after merge to 5.0
mysql-test/r/grant.result:
Reorder test result
mysql-test/t/grant.test:
Add "use test"
sql/sql_acl.cc:
Add check if host is NULL
Add check if grant_name->host.hostname is null
Diffstat (limited to 'mysql-test/r/grant.result')
-rw-r--r-- | mysql-test/r/grant.result | 37 |
1 files changed, 19 insertions, 18 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result index 8185789a939..eec95cbd32a 100644 --- a/mysql-test/r/grant.result +++ b/mysql-test/r/grant.result @@ -624,6 +624,25 @@ GRANT USAGE ON *.* TO 'mysqltest_7'@'' IDENTIFIED BY PASSWORD '*2FB071A056F9BB74 drop user mysqltest_7@; show grants for mysqltest_7@; ERROR 42000: There is no such grant defined for user 'mysqltest_7' on host '' +create database mysqltest; +use mysqltest; +create table t1(f1 int); +GRANT DELETE ON mysqltest.t1 TO mysqltest1@'%'; +GRANT SELECT ON mysqltest.t1 TO mysqltest1@'192.%'; +show grants for mysqltest1@'192.%'; +Grants for mysqltest1@192.% +GRANT USAGE ON *.* TO 'mysqltest1'@'192.%' +GRANT SELECT ON `mysqltest`.`t1` TO 'mysqltest1'@'192.%' +show grants for mysqltest1@'%'; +Grants for mysqltest1@% +GRANT USAGE ON *.* TO 'mysqltest1'@'%' +GRANT DELETE ON `mysqltest`.`t1` TO 'mysqltest1'@'%' +delete from mysql.user where user='mysqltest1'; +delete from mysql.db where user='mysqltest1'; +delete from mysql.tables_priv where user='mysqltest1'; +flush privileges; +drop database mysqltest; +use test; create table t1 (a int); create table t2 as select * from mysql.user where user=''; delete from mysql.user where user=''; @@ -834,21 +853,3 @@ insert into mysql.user select * from t2; flush privileges; drop table t2; drop table t1; -create database mysqltest; -use mysqltest; -create table t1(f1 int); -GRANT DELETE ON mysqltest.t1 TO mysqltest1@'%'; -GRANT SELECT ON mysqltest.t1 TO mysqltest1@'192.%'; -show grants for mysqltest1@'192.%'; -Grants for mysqltest1@192.% -GRANT USAGE ON *.* TO 'mysqltest1'@'192.%' -GRANT SELECT ON `mysqltest`.`t1` TO 'mysqltest1'@'192.%' -show grants for mysqltest1@'%'; -Grants for mysqltest1@% -GRANT USAGE ON *.* TO 'mysqltest1'@'%' -GRANT DELETE ON `mysqltest`.`t1` TO 'mysqltest1'@'%' -delete from mysql.user where user='mysqltest1'; -delete from mysql.db where user='mysqltest1'; -delete from mysql.tables_priv where user='mysqltest1'; -flush privileges; -drop database mysqltest; |