Privileges problems

I'm having trouble with Mysql privileges. If I type mysql from my
default account, 'markus', I get the access denied error 1045 for user
'markus'@'localhost' (using password:YES)

To my knowledge, I don't have a password on that account. I run su and
run mysql -u root mysql to look at the user table. There I have an
account for 'markus'@'localhost' and 'markus'@'%'. To make sure these
accounts are properly privileged, I delete them from the table and then
run 'grant all privileges on *.* to 'markus'@'localhost' with grant
option;. I also run it for '%'. I try running mysql from 'markus'
again, and it fails.

What am I missing regarding the privileges system?

Thanks

>I'm having trouble with Mysql privileges. If I type mysql from my
>default account, 'markus', I get the access denied error 1045 for user
>'markus'@'localhost' (using password:YES)

If you don't have a password on the account, don't try to log in
with one.

>To my knowledge, I don't have a password on that account. I run su and
>accounts are properly privileged, I delete them from the table and then
>run 'grant all privileges on *.* to 'markus'@'localhost' with grant
>option;. I also run it for '%'. I try running mysql from 'markus'
>again, and it fails.
>
>What am I missing regarding the privileges system?


If you don't have a password on the account, don't try to log in
with one.

Gordon Burditt wrote:
> >I'm having trouble with Mysql privileges. If I type mysql from my
> >default account, 'markus', I get the access denied error 1045 for user
> >'markus'@'localhost' (using password:YES)
>
> If you don't have a password on the account, don't try to log in
> with one.

I'm trying to login _without_ a password on an account that was created
without a password, but it still requires a password. If I login with
mysql -p and hit enter at the password prompt, it works. For some
reason it's assigning a blank password instead of not requiring a
password at all.

Any ideas on how to fix this?