Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Unhappy Unanswered: How to allow users to create new user ?

    Hellas,

    I trie to create a user how has the privileges to add new mysql users with the same or less privileges than himself. So I use :

    GRANT ALL PRIVILEGES ON dbexample.* TO myUser@"%" IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

    But when the user tries to add a user, it says that he has no access to mysql databse. (the grant tables)

    Now I wonder if I do anything wrong, or if it is not possible for a non-super user to create a new user and he may only give his privileges to an existing user ?

    If so, what are the minimum privileges I have to give a user so he can add new users, and what are the risks ?

    Thanks for any help here !

  2. #2
    Join Date
    Jul 2004
    Posts
    2
    Nobody seems to know anything, poor me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •