Re: [OT] Mysql advice

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



--
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

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux