| Bug #22777 | CREATE_USER_PRIV doesnt work (?) | ||
|---|---|---|---|
| Submitted: | 28 Sep 2006 11:49 | Modified: | 28 Oct 2006 11:59 |
| Reporter: | Vladimir Kolesnikov | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.22-mac | OS: | MacOS (OS X 10.4.7) |
| Assigned to: | CPU Architecture: | Any | |
[28 Sep 2006 11:59]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version of MySQL server, 5.0.24a, and send the reults of select current_user(), user(); from the same session where you executed CREATE USER.
[9 Oct 2006 10:21]
Sergei Golubchik
Try the other way around - all privileges 'N', Create_user_priv='Y'
[28 Oct 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".

Description: Looks like CREATE_USER_PRIV doesnt work. If this is expected, then i was unable to find anything in docs, so this might be a documentation issue. Or this privilege is not about creating users? (docs are very short about its meaning) How to repeat: Let me just paste a cli log vkolesn-macmini:~/co/common vlad$ /usr/local/mysql/bin/mysql -uroot --host=localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 125 to server version: 5.0.22-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from mysql.user where user='root' and host = 'localhost' \G *************************** 1. row *************************** Host: localhost User: root Password: Select_priv: Y ... <all privileges = Y> ... Create_user_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 1 row in set (0.00 sec) mysql> create user u; Query OK, 0 rows affected (0.00 sec)