diff options
author | unknown <serg@serg.mylan> | 2004-11-27 23:07:30 +0100 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2004-11-27 23:07:30 +0100 |
commit | 257763a9a35ff4212f71ccf356859d115899f430 (patch) | |
tree | 6aee196afde28c5ab6978f8c8b0563c01cdb5f8e /mysql-test/r/grant2.result | |
parent | cf1de7d9da102d11c3ac81efc5dbb51077dc235f (diff) | |
download | mariadb-git-257763a9a35ff4212f71ccf356859d115899f430.tar.gz |
create/drop/rename user cleanup
dbug/user.r:
help cralified
include/mysqld_error.h:
new error message added
mysql-test/r/grant.result:
results updated
mysql-test/r/grant2.result:
results updated
mysql-test/t/grant.test:
results updated
mysql-test/t/grant2.test:
results updated
sql/share/czech/errmsg.txt:
error message updated
sql/share/danish/errmsg.txt:
error message updated
sql/share/dutch/errmsg.txt:
error message updated
sql/share/english/errmsg.txt:
error message updated
sql/share/estonian/errmsg.txt:
error message updated
sql/share/french/errmsg.txt:
error message updated
sql/sql_acl.cc:
changed error reporting for create/drop/rename user to be consistent with drop table
sql/share/german/errmsg.txt:
error message updated
sql/share/greek/errmsg.txt:
error message updated
sql/share/hungarian/errmsg.txt:
error message updated
sql/share/italian/errmsg.txt:
error message updated
sql/share/japanese/errmsg.txt:
error message updated
sql/share/korean/errmsg.txt:
error message updated
sql/share/norwegian-ny/errmsg.txt:
error message updated
sql/share/norwegian/errmsg.txt:
error message updated
sql/share/polish/errmsg.txt:
error message updated
sql/share/portuguese/errmsg.txt:
error message updated
sql/share/romanian/errmsg.txt:
error message updated
sql/share/russian/errmsg.txt:
error message updated
sql/share/serbian/errmsg.txt:
error message updated
sql/share/slovak/errmsg.txt:
error message updated
sql/share/spanish/errmsg.txt:
error message updated
sql/share/swedish/errmsg.txt:
error message updated
sql/share/ukrainian/errmsg.txt:
error message updated
Diffstat (limited to 'mysql-test/r/grant2.result')
-rw-r--r-- | mysql-test/r/grant2.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/grant2.result b/mysql-test/r/grant2.result index f2782f6f605..edfd1a07680 100644 --- a/mysql-test/r/grant2.result +++ b/mysql-test/r/grant2.result @@ -66,7 +66,7 @@ create table t1(c1 int); create table t2(c1 int, c2 int); create user 'mysqltest_1'; create user 'mysqltest_1'; -ERROR HY000: Operation CREATE USER failed for 1 of the requested users +ERROR HY000: Operation CREATE USER failed for 'mysqltest_1'@'%' create user 'mysqltest_2' identified by 'Mysqltest-2'; create user 'mysqltest_3' identified by password 'fffffffffffffffffffffffffffffffffffffffff'; grant select on *.* to 'mysqltest_2'; @@ -139,7 +139,7 @@ drop user 'mysqltest_1', 'mysqltest_3'; grant all on test.t1 to 'mysqltest_1'; ERROR 42000: 'root'@'localhost' is not allowed to create new users drop user 'mysqltest_1'; -ERROR HY000: Operation DROP USER failed for 1 of the requested users +ERROR HY000: Operation DROP USER failed for 'mysqltest_1'@'%' drop table t1, t2; insert into mysql.db set user='mysqltest_1', db='%', host='%'; flush privileges; @@ -169,16 +169,16 @@ drop user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; create user 'mysqltest_1', 'mysqltest_2' identified by 'Mysqltest-2', 'mysqltest_3' identified by password 'fffffffffffffffffffffffffffffffffffffffff'; rename user 'mysqltest_1' to 'mysqltest_1a', 'mysqltest_2' TO 'mysqltest_2a', 'mysqltest_3' TO 'mysqltest_3a'; drop user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; -ERROR HY000: Operation DROP USER failed for 3 of the requested users +ERROR HY000: Operation DROP USER failed for 'mysqltest_1'@'%','mysqltest_2'@'%','mysqltest_3'@'%' drop user 'mysqltest_1a', 'mysqltest_2a', 'mysqltest_3a'; create user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; create user 'mysqltest_1a', 'mysqltest_2', 'mysqltest_3a'; -ERROR HY000: Operation CREATE USER failed for 1 of the requested users +ERROR HY000: Operation CREATE USER failed for 'mysqltest_2'@'%' rename user 'mysqltest_1a' to 'mysqltest_1b', 'mysqltest_2a' TO 'mysqltest_2b', 'mysqltest_3a' TO 'mysqltest_3b'; -ERROR HY000: Operation RENAME USER failed for 1 of the requested users +ERROR HY000: Operation RENAME USER failed for 'mysqltest_2a'@'%' drop user 'mysqltest_1', 'mysqltest_2', 'mysqltest_3'; drop user 'mysqltest_1b', 'mysqltest_2b', 'mysqltest_3b'; -ERROR HY000: Operation DROP USER failed for 1 of the requested users +ERROR HY000: Operation DROP USER failed for 'mysqltest_2b'@'%' create user 'mysqltest_2' identified by 'Mysqltest-2'; drop user 'mysqltest_2' identified by 'Mysqltest-2'; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'Mysqltest-2'' at line 1 |