Hi,

I've encountered a strange problem.

Mysql user root can only log in to the server via the command line
client using the -p option immediately followed by the password. In
other words:

mysql -u root -p FAILS
mysql -u root -pMyPassword SUCCEEDS

Just wondering if anyone has encountered this before.

Some more details:

- logging in from localhost
- in mysql.user, there are two entries for user root
-- root@localhost identified by password
-- root@another.domain (no password)

I do understand that mysql uses the most specific hostname in
authenticating users... but it appears that maybe the password takes
even higher precedence?

I'm of course going to try logging in after removing the root user
without a password (yes, dumb to have that passwordless root anyway)
but has anyone encountered something similar? Or am I right in mysql's
order of authentication logic?

Cheers,
yong

ybakos schreef:
> Hi,
>
> I've encountered a strange problem.
>
> Mysql user root can only log in to the server via the command line
> client using the -p option immediately followed by the password. In
> other words:
>
> mysql -u root -p FAILS
> mysql -u root -pMyPassword SUCCEEDS
>
> Just wondering if anyone has encountered this before.
>
> Some more details:
>
> - logging in from localhost
> - in mysql.user, there are two entries for user root
> -- root@localhost identified by password
> -- root@another.domain (no password)
>
> I do understand that mysql uses the most specific hostname in
> authenticating users... but it appears that maybe the password takes
> even higher precedence?
>
> I'm of course going to try logging in after removing the root user
> without a password (yes, dumb to have that passwordless root anyway)
> but has anyone encountered something similar? Or am I right in mysql's
> order of authentication logic?
>
> Cheers,
> yong
>

maybe its this?:
http://dev.mysql.com/doc/refman/5.1/...-too-long.html


--
Luuk

Thanks Luuk. I agree this might be it, since the pwd is 9 chars long.
I can't verify right now due to some dependencies, but will post a
follow up to this thread when I've verified this.



On Apr 5, 2:21am, Luuk <L...@invalid.lan> wrote:
>
> maybe its this?:http://dev.mysql.com/doc/refman/5.1/...-too-long.html
>

On Mon, 7 Apr 2008 08:39:23 -0700 (PDT), ybakos
<humanoriented@gmail.com> wrote:

>Thanks Luuk. I agree this might be it, since the pwd is 9 chars long.
>I can't verify right now due to some dependencies, but will post a
>follow up to this thread when I've verified this.

Neat. When you do could you please not top post?
>
>
>
>On Apr 5, 2:21am, Luuk <L...@invalid.lan> wrote:
>>
>> maybe its this?:http://dev.mysql.com/doc/refman/5.1/...-too-long.html
>>

Strange. We have several passwords > 9 char on Solaris, famous for
only paying attention to the first 8.


--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
================================================== =========================