Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Unanswered: Creating a new user

    Hi,

    I'm trying to create a new user via GRANT. My command line was

    GRANT ALL on abc.* TO (username)

    But it threw me an error 1044: Access denied for user.

    Anyone know how to fix this? Thanks.

    Frank

  2. #2
    Join Date
    Jul 2003
    Posts
    7

    Re: Creating a new user

    Originally posted by fshlee
    Hi,

    I'm trying to create a new user via GRANT. My command line was

    GRANT ALL on abc.* TO (username)

    But it threw me an error 1044: Access denied for user.

    Anyone know how to fix this? Thanks.

    Frank
    See capnqwest's post (about 20 down) on the same issue- that should help.

  3. #3
    Join Date
    Aug 2003
    Location
    FDR India
    Posts
    24
    Hi

    Sundry *can't* GRANT privileges. By default only the MySQL root has this privilege. So login as root and GRANT privileges.

    Before you do any of the above, please read the relevant section of the manual.

    regards
    theN

  4. #4
    Join Date
    Aug 2003
    Posts
    5
    Originally posted by then
    Hi

    Sundry *can't* GRANT privileges. By default only the MySQL root has this privilege. So login as root and GRANT privileges.

    Before you do any of the above, please read the relevant section of the manual.

    regards
    theN
    Thanks. I just reintall mysql fresh and went thru all the necessary steps from the manual.

Posting Permissions

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