Re: [OT] Mysql advice

2008-09-19 Thread Craig White
On Fri, 2008-09-19 at 13:33 -0400, Mark Haney wrote: > Chris G wrote: > > On Fri, Sep 19, 2008 at 11:18:05AM -0400, Mark Haney wrote: > >> I have a funky problem that I hope someone can help me with. I've got a > >> mysql data running (on FC6, sadly) on a system where the root password was > >>

Re: [OT] Mysql advice

2008-09-19 Thread Dennis Kaptain
> > And as my new pwd HAS a #, this is why it's a problem. > Amazing... simply amazing. I'm glad you got it figured out. Dennis K __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.y

Re: [OT] Mysql advice

2008-09-19 Thread Mark Haney
Dennis Kaptain wrote: 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. I think the problem you are having is not with mysql at all but

Re: [OT] Mysql advice

2008-09-19 Thread Dennis Kaptain
> > 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. > I think the problem you are having is not with mysql at all but rather the zen

Re: [OT] Mysql advice

2008-09-19 Thread 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 'mys

Re: [OT] Mysql advice

2008-09-19 Thread Craig White
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 '

Re: [OT] Mysql advice

2008-09-19 Thread Mark Haney
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

Re: [OT] Mysql advice

2008-09-19 Thread Dennis Kaptain
> > Nope, the password is the correct password when I do that. That's not > my problem. Really, that in itself /isn't/ a problem. The problem > stems from the fact that zenoss wants to be able to automatically have > root access to mysql to setup the db it uses for monitoring. And > becau

Re: [OT] Mysql advice

2008-09-19 Thread Craig White
On Fri, 2008-09-19 at 13:34 -0400, Mark Haney wrote: > Dennis Kaptain wrote: > > > > > > > I found this via a google search for "recover mysql root password" > > http://www.cyberciti.biz/tips/recover-mysql-root-password.html > > > > It looks like exactly what you need if you somehow lost/mistyp

Re: [OT] Mysql advice

2008-09-19 Thread Mark Haney
Dennis Kaptain wrote: I found this via a google search for "recover mysql root password" http://www.cyberciti.biz/tips/recover-mysql-root-password.html It looks like exactly what you need if you somehow lost/mistyped/forgot the mysql root password. Good luck Dennis K It's not lost or mis

Re: [OT] Mysql advice

2008-09-19 Thread Mark Haney
Chris G wrote: On Fri, Sep 19, 2008 at 11:18:05AM -0400, Mark Haney wrote: I have a funky problem that I hope someone can help me with. I've got a mysql data running (on FC6, sadly) on a system where the root password was changed a few days ago. Used to, I could just enter 'mysql' at root and

Re: [OT] Mysql advice

2008-09-19 Thread Dennis Kaptain
> Why not initially try getting mysql to ask for the password when you > log in, e.g.:- > > mysql -u root -p > > ... and it will ask for the password for user 'root' in mysql. I'm > just wondering if you mis-typed the password when you changed it in > mysql (I always find the syntax for doi

Re: [OT] Mysql advice

2008-09-19 Thread Chris G
On Fri, Sep 19, 2008 at 11:18:05AM -0400, Mark Haney wrote: > I have a funky problem that I hope someone can help me with. I've got a > mysql data running (on FC6, sadly) on a system where the root password was > changed a few days ago. Used to, I could just enter 'mysql' at root and > could g

Re: [OT] Mysql advice

2008-09-19 Thread Craig White
On Fri, 2008-09-19 at 11:18 -0400, Mark Haney wrote: > I have a funky problem that I hope someone can help me with. I've got a > mysql data running (on FC6, sadly) on a system where the root password > was changed a few days ago. Used to, I could just enter 'mysql' at root > and could get into

Re: [OT] Mysql advice

2008-09-19 Thread landon kelsey
--- On Fri, 9/19/08, Mark Haney <[EMAIL PROTECTED]> wrote: > From: Mark Haney <[EMAIL PROTECTED]> > Subject: [OT] Mysql advice > To: "For users of Fedora Core releases" > Date: Friday, September 19, 2008, 10:18 AM > I have a funky problem that I hope so

[OT] Mysql advice

2008-09-19 Thread Mark Haney
I have a funky problem that I hope someone can help me with. I've got a mysql data running (on FC6, sadly) on a system where the root password was changed a few days ago. Used to, I could just enter 'mysql' at root and could get into the mysql command line. I went in an changed the root pass