Professional Web Applications Themes

Access denied for user - MySQL

Hello everyone. I created a new user with the grant command and yet, I can't login into the database I must mention that the user was created but all the privileges are set to 'N'. This is what i get trying to login with the new user I created. "ERROR 1045 (28000): Access denied for user 'nsac''localhost' (using password: YES)" Any help is appreciated Ray...

  1. #1

    Default Access denied for user

    Hello everyone.

    I created a new user with the grant command and yet, I can't login into
    the database I must mention that the user was created but all the
    privileges are set to 'N'.

    This is what i get trying to login with the new user I created.

    "ERROR 1045 (28000): Access denied for user 'nsac''localhost' (using
    password: YES)"

    Any help is appreciated
    Ray

    Ray Muforosky Guest

  2. #2

    Default Re: Access denied for user

    Ray Muforosky wrote:
    > I created a new user with the grant command and yet, I can't login into
    > the database I must mention that the user was created but all the
    > privileges are set to 'N'.
    If you granted privileges to the user for one database, the user's row
    in the mysql.user table will have all 'N' values, but there will also be
    a row for that user for a particular database in the mysql.db table,
    with 'Y' values for privileges you chose to grant to that user.

    In other words, this command:

    GRANT ALL ON *.* TO 'nsac''localhost' IDENTIFIED BY 'password';

    results in a row in the mysql.user table with 'Y' values.
    However, a different command:

    GRANT ALL ON mydatabase.* TO 'nsac''localhost' IDENTIFIED BY 'password';

    results in a row in the mysql.user table with 'N' values, and a row in
    the mysql.db table with 'Y' values. In this case, the user has 'N'
    privileges by default, except for having 'Y' privileges on the one
    database "mydatabase".

    Regards,
    Bill K.
    Bill Karwin Guest

  3. #3

    Default Re: Access denied for user

    Ray Muforosky wrote:
    > I created a new user with the grant command and yet, I can't login into
    > the database I must mention that the user was created but all the
    > privileges are set to 'N'.
    If you granted privileges to the user for one database, the user's row
    in the mysql.user table will have all 'N' values, but there will also be
    a row for that user for a particular database in the mysql.db table,
    with 'Y' values for privileges you chose to grant to that user.

    In other words, this command:

    GRANT ALL ON *.* TO 'nsac''localhost' IDENTIFIED BY 'password';

    results in a row in the mysql.user table with 'Y' values.
    However, a different command:

    GRANT ALL ON mydatabase.* TO 'nsac''localhost' IDENTIFIED BY 'password';

    results in a row in the mysql.user table with 'N' values, and a row in
    the mysql.db table with 'Y' values. In this case, the user has 'N'
    privileges by default, except for having 'Y' privileges on the one
    database "mydatabase".

    Regards,
    Bill K.
    Bill Karwin Guest

Similar Threads

  1. MySQL Access denied for user - Plesk / FC 2
    By rossn8tor@hotmail.com in forum Coldfusion Server Administration
    Replies: 1
    Last Post: November 9th, 04:31 PM
  2. MX2004 User Authentication: Access Denied
    By yep29 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 11th, 08:54 PM
  3. 401 Access Denied, but only for one user
    By Jeff Stewart in forum ASP.NET Web Services
    Replies: 3
    Last Post: April 4th, 10:13 PM
  4. How to show a Access Denied Page when User is not in Role?
    By Malik Asif Joyia in forum ASP.NET Security
    Replies: 1
    Last Post: July 9th, 01:03 PM
  5. Replies: 4
    Last Post: February 7th, 08:26 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139