[PLUG] MySQL - Can't connect except as root

[drew wymore]

On 5/17/07, Richard C. Steffens <rsteff at comcast.net> wrote:
>
> I can use the mysql monitor to connect to mysql if I specify -u root,
> but not if I specify another user. Using MySQL Administrator I can see
> that the other user is there, but the character count for the password
> does not match the number of characters I used to create the password.
> It appears that I can change the password with MySQL Administrator, but
> it doesn't affect being able to connect as that user. And, when I go
> back to MySQL Administrator, the character count is incorrect, again.
>
> (This is not a production environment, so I'm not concerned about
> publishing the password on this list.)
>
> The user name is bookorama, and the password is bookorama123, both taken
> directly from the book I'm using to re-learn MySQL and PHP. There are 12
> characters in that password, but when I count the * characters in the
> password boxes in MySQL Administrator I find only 8 of them.
>
> The MySQL installation was done using YaST2 on a SuSE 10.1 system.
>
> Any ideas on how to fix this problem?
>
> Thanks.
>
> --
> Regards,
>
> Dick Steffens


Dick,
It sounds like the password is being truncated to 8 characters maybe? Try
just using an 8 character password and see what happens.