diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-01-13 11:50:33 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-01-13 11:50:33 +0400 |
| commit | 1f0ad6c6b3421a815ea6373c66aaf693852342cf (patch) | |
| tree | b5362aa495d81fd8940e0c299a15d374e41b433e /mysql-test/r/create_drop_user.result | |
| parent | a68ad5d50f5a3a6f7ef4d573e889aa97cfc6d749 (diff) | |
| download | mariadb-git-1f0ad6c6b3421a815ea6373c66aaf693852342cf.tar.gz | |
MDEV-7288 USER/ROLE: CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS
Diffstat (limited to 'mysql-test/r/create_drop_user.result')
| -rw-r--r-- | mysql-test/r/create_drop_user.result | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/mysql-test/r/create_drop_user.result b/mysql-test/r/create_drop_user.result new file mode 100644 index 00000000000..3c388545199 --- /dev/null +++ b/mysql-test/r/create_drop_user.result @@ -0,0 +1,43 @@ +CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pw1'; +SELECT password FROM mysql.user WHERE user='u1'; +password +*2B602296A79E0A8784ACC5C88D92E46588CCA3C3 +CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pw2'; +Warnings: +Note 1972 Can't create user 'u1'@'localhost'; it already exists +SELECT password FROM mysql.user WHERE user='u1'; +password +*2B602296A79E0A8784ACC5C88D92E46588CCA3C3 +CREATE OR REPLACE USER u1@localhost IDENTIFIED BY 'pw3'; +SELECT password FROM mysql.user WHERE user='u1'; +password +*77B4A70CEFD76DB9415F36D291E74C110D2738E0 +CREATE OR REPLACE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pw4'; +ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS +SELECT password FROM mysql.user WHERE user='u1'; +password +*77B4A70CEFD76DB9415F36D291E74C110D2738E0 +DROP USER IF EXISTS u1@localhost; +DROP USER IF EXISTS u1@localhost; +Warnings: +Note 1973 Can't drop user 'u1'@'localhost'; it doesn't exist +DROP USER u1@localhost; +ERROR HY000: Operation DROP USER failed for 'u1'@'localhost' +CREATE OR REPLACE USER u1@localhost; +CREATE USER u1@localhost; +ERROR HY000: Operation CREATE USER failed for 'u1'@'localhost' +DROP USER u1@localhost; +CREATE USER u1; +CREATE USER u1, u2; +ERROR HY000: Operation CREATE USER failed for 'u1'@'%' +CREATE USER u2; +ERROR HY000: Operation CREATE USER failed for 'u2'@'%' +CREATE OR REPLACE USER u1 IDENTIFIED BY PASSWORD 'password', u2; +ERROR HY000: Password hash should be a 41-digit hexadecimal number +CREATE OR REPLACE USER u1 IDENTIFIED BY PASSWORD 'abcdefghijklmnop', u2; +DROP USER u1; +DROP USER IF EXISTS u1, u2; +Warnings: +Note 1973 Can't drop user 'u1'@'%'; it doesn't exist +DROP USER u2; +ERROR HY000: Operation DROP USER failed for 'u2'@'%' |