[OT] Mysql advice

[Mark Haney]

Craig White wrote:
> 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
> 

Well yeah, that's sort of true. I have one user 'root'@'localhost' and 
one 'root'@'chestnut.ercbroadband.org'.  Pretty much what you are 
describing.  Still doesn't help much.  The passwords are the same.


-- 
Libenter homines id quod volunt credunt -- Caius Julius Caesar


Mark Haney
Sr. Systems Administrator
ERC Broadband
(828) 350-2415

Call (866) ERC-7110 for after hours support