diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/grant2.result | 1 | ||||
| -rw-r--r-- | mysql-test/t/grant2.test | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/grant2.result b/mysql-test/r/grant2.result index 821f67536f3..e6c78fdfdd4 100644 --- a/mysql-test/r/grant2.result +++ b/mysql-test/r/grant2.result @@ -23,6 +23,7 @@ grant select on `my\_1`.* to mysqltest_4@localhost with grant option; ERROR 42000: 'mysqltest_1'@'localhost' is not allowed to create new users grant select on `my\_1`.* to mysqltest_4@localhost identified by 'mypass' with grant option; +ERROR 42000: Access denied for user 'mysqltest_1'@'localhost' to database 'mysql' show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test index 3b1200f8a6e..58f91fddcc2 100644 --- a/mysql-test/t/grant2.test +++ b/mysql-test/t/grant2.test @@ -36,6 +36,7 @@ set @@sql_mode='NO_AUTO_CREATE_USER'; select @@sql_mode; --error 1211 grant select on `my\_1`.* to mysqltest_4@localhost with grant option; +--error 1044 grant select on `my\_1`.* to mysqltest_4@localhost identified by 'mypass' with grant option; disconnect user1; |