[OT] Mysql advice

[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 
> >> 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 password in mysql to reflect the changed root 
> >> password and edited .my.cnf to the new password, but now when I'm in root 
> >> and type 'mysql' I get this:
> >>
> >> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
> >> password: YES)
> >>
> >> I know the root pwd in mysql is correct as our databases are working just 
> >> fine on it.
> >>
> >> The reason I have a problem with this is because I'm trying to install a 
> >> Zenoss RPM I built for FC6 and on startup Zenoss inits it's DB and tables, 
> >> but it can't because it can't login as the root user.
> >>
> >> How do I fix this?  I'm sure it's something silly, but I've googled until I 
> >> can't take it any more.
> >>
> > 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 doing it confusing).  At least if
> > you do the above you can have a few guesses at what you might have
> > entered. 
> > 
> 
> 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 
> because it simply can't enter 'mysql' at the prompt and setup it's 
> tables, it refuses to start correctly.
----
check /etc/init.d/zenoss...

# environment variables
export ZENHOME="/opt/zenoss"
export RUNUSER="zenoss"
export SNMPD_CONF="/etc/snmp/snmpd.conf"
export MY_CNF="/etc/my.cnf"
export ZOPE_USERNAME="admin"
export ZOPE_PASSWORD="zenoss"
export ZOPE_LISTEN_PORT="8080"

check /opt/zenoss/etc/zenbackup.conf

I definitely don't have zenoss run or connect to mysql as root but
created a mysql user named zenoss and this user has sufficient
privileges to do whatever it needs to do.

Craig