[OT] Mysql advice
Craig White
craigwhite at azapple.com
Fri Sep 19 18:03:13 UTC 2008
On Fri, 2008-09-19 at 13:59 -0400, Mark Haney wrote:
> Craig White wrote:
>
> >>>
> >> It's not lost or mistyped. I can enter 'mysql -u root -p' and enter the
> >> correct password and it works fine. But, used to I could just enter
> >> 'mysql' at the bash prompt and I would go straight into 'mysql>' without
> >> needing a password.
> > ----
> > that requires configuration file /root/.my.cnf
> >
> > Craig
> >
>
> I did. No change.
----
as I first replied in the thread, mysql considers root connecting via
socket and root connecting via network to be 2 different users and thus
there should be 2 different root users set up in mysql, one just simply
root and one root at localhost
Craig
More information about the users
mailing list