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

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.

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.