Fedora Linux Support Community & Resources Center

Go Back   FedoraForum.org > Fedora 19/20 > Using Fedora
FedoraForum Search

Forgot Password? Join Us!

Using Fedora General support for current versions. Ask questions about Fedora that do not belong in any other forum.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 12th February 2012, 01:32 PM
gkasica Offline
Registered User
 
Join Date: May 2008
Location: Jackson, WI
Age: 48
Posts: 44
windows_7chrome
/usr/bin/mysqladmin: connect to server at 'localhost' failed

THe following just began happening a couple days ago after an automated yum update put mySQL up to mysql-server-5.5.20-1.fc16.i686

Everything else appears normal and working but I don'tknow the cauae and before I try to blndly muck with a working peoduction system was hoping someone had some knowledge of what at why this is happening.

/etc/cron.daily/logrotate:

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
error: error running non-shared postrotate script for /var/log/mysqld.log of '/var/log/mysqld.log '

Other items updated at that time are below from yum.log:

Feb 10 06:16:43 Updated: php-common-5.3.10-1.fc16.i686
Feb 10 06:16:44 Updated: coreutils-libs-8.12-6.fc16.i686
Feb 10 06:16:53 Updated: coreutils-8.12-6.fc16.i686
Feb 10 06:16:58 Updated: pam-1.1.5-5.fc16.i686
Feb 10 06:17:00 Updated: 1:samba-winbind-clients-3.6.3-78.fc16.i686
Feb 10 06:17:02 Updated: chkconfig-1.3.57-3.fc16.i686
Feb 10 06:17:03 Updated: 2:qemu-common-0.15.1-4.fc16.i686
Feb 10 06:17:05 Updated: mysql-libs-5.5.20-1.fc16.i686
Feb 10 06:17:05 Updated: php-pdo-5.3.10-1.fc16.i686
Feb 10 06:17:12 Updated: mysql-5.5.20-1.fc16.i686
Feb 10 06:17:27 Updated: 1:samba-common-3.6.3-78.fc16.i686
Feb 10 06:17:28 Updated: openssh-5.8p2-24.fc16.i686
Feb 10 06:17:30 Updated: spice-glib-0.9-1.fc16.i686
Feb 10 06:17:33 Updated: php-cli-5.3.10-1.fc16.i686
Feb 10 06:17:36 Updated: php-5.3.10-1.fc16.i686
Feb 10 06:17:41 Updated: 1:samba-3.6.3-78.fc16.i686
Feb 10 06:17:43 Updated: 2:qemu-system-m68k-0.15.1-4.fc16.i686
Feb 10 06:17:45 Updated: 2:qemu-user-0.15.1-4.fc16.i686
Feb 10 06:17:48 Updated: 2:qemu-system-mips-0.15.1-4.fc16.i686
Feb 10 06:17:50 Updated: 2:qemu-system-cris-0.15.1-4.fc16.i686
Feb 10 06:17:51 Updated: 2:qemu-system-arm-0.15.1-4.fc16.i686
Feb 10 06:17:53 Updated: 2:qemu-system-sh4-0.15.1-4.fc16.i686
Feb 10 06:17:56 Updated: 2:qemu-system-x86-0.15.1-4.fc16.i686
Feb 10 06:17:57 Updated: 2:qemu-img-0.15.1-4.fc16.i686
Feb 10 06:17:58 Updated: strigi-libs-0.7.7-1.fc16.i686
Feb 10 06:18:00 Updated: tclx-8.4.0-18.fc16.i686
Feb 10 06:18:00 Updated: tclx-devel-8.4.0-18.fc16.i686
Feb 10 06:18:01 Updated: strigi-devel-0.7.7-1.fc16.i686
Feb 10 06:18:01 Updated: 2:qemu-0.15.1-4.fc16.i686
Feb 10 06:18:03 Updated: php-devel-5.3.10-1.fc16.i686
Feb 10 06:18:04 Updated: spice-gtk-0.9-1.fc16.i686
Feb 10 06:18:05 Updated: spice-gtk3-0.9-1.fc16.i686
Feb 10 06:18:06 Updated: mysql-bench-5.5.20-1.fc16.i686
Feb 10 06:18:07 Updated: mysql-devel-5.5.20-1.fc16.i686
Feb 10 06:18:08 Updated: php-odbc-5.3.10-1.fc16.i686
Feb 10 06:18:08 Updated: php-pgsql-5.3.10-1.fc16.i686
Feb 10 06:18:09 Updated: php-mysql-5.3.10-1.fc16.i686
Feb 10 06:18:09 Updated: php-imap-5.3.10-1.fc16.i686
Feb 10 06:18:11 Updated: pam-devel-1.1.5-5.fc16.i686
Feb 10 06:18:11 Updated: php-dba-5.3.10-1.fc16.i686
Feb 10 06:18:12 Updated: php-mbstring-5.3.10-1.fc16.i686
Feb 10 06:18:12 Updated: php-xmlrpc-5.3.10-1.fc16.i686
Feb 10 06:18:13 Updated: php-snmp-5.3.10-1.fc16.i686
Feb 10 06:18:13 Updated: php-gd-5.3.10-1.fc16.i686
Feb 10 06:18:14 Updated: php-xml-5.3.10-1.fc16.i686
Feb 10 06:18:15 Updated: php-soap-5.3.10-1.fc16.i686
Feb 10 06:18:15 Updated: php-bcmath-5.3.10-1.fc16.i686
Feb 10 06:18:16 Updated: php-ldap-5.3.10-1.fc16.i686
Feb 10 06:18:16 Updated: culmus-fonts-common-0.121-1.fc16.noarch
Feb 10 06:18:20 Updated: 1:samba-swat-3.6.3-78.fc16.i686
Feb 10 06:18:21 Updated: openssh-askpass-5.8p2-24.fc16.i686
Feb 10 06:18:21 Updated: openssh-clients-5.8p2-24.fc16.i686
Feb 10 06:18:22 Updated: openssh-server-5.8p2-24.fc16.i686
Feb 10 06:18:26 Updated: 1:samba-winbind-3.6.3-78.fc16.i686
Feb 10 06:18:35 Updated: 1:samba-client-3.6.3-78.fc16.i686
Feb 10 06:18:43 Updated: mysql-server-5.5.20-1.fc16.i686
Feb 10 06:18:44 Updated: ntsysv-1.3.57-3.fc16.i686
Feb 10 06:19:08 Updated: 1:java-1.6.0-openjdk-1.6.0.0-63.1.11.fc16.i686
Feb 10 06:19:09 Updated: cifs-utils-5.3-1.fc16.i686
Feb 10 06:19:12 Updated: 1:libsmbclient-3.6.3-78.fc16.i686
Feb 10 06:19:14 Updated: gnupg-1.4.12-1.fc16.i686
Feb 10 06:19:22 Updated: 1:numpy-1.6.1-2.fc16.i686
Feb 10 06:19:23 Updated: net-tools-1.60-126.fc16.i686
Feb 10 06:19:25 Updated: clutter-1.8.4-1.fc16.i686

Thanks in advance and please ask if you need more information.

George
__________________
===[George R. Kasica]=== +1 262 677 0766
georgek@netwrx1.com +1 206 374 6482 FAX
http://www.netwrx1.com/georgek Jackson, WI USA
georgek@netwrx1.com
ICQ #12862186

("`-''-/").___..--''"`-._
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'
Reply With Quote
  #2  
Old 14th February 2012, 02:57 AM
BradW Offline
Registered User
 
Join Date: May 2004
Location: Concord, CA
Posts: 88
windows_vistafirefox
My solution

Hello,

I stopped this error on my system by just running the /etc/cron.daily/logrotate script once as root.

If you search Google, there is some less-than-current information on this issue.

Brad
Reply With Quote
  #3  
Old 14th February 2012, 03:02 AM
gkasica Offline
Registered User
 
Join Date: May 2008
Location: Jackson, WI
Age: 48
Posts: 44
windows_7ie
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

I've done that here as well with no effect as far as I can tell - and just reran it now so we'll see inthe morning what happens. I believe those scripts run as root normally in any case though.
It seem to run normally as root with no errors but thenext day when itruns as part of the cron jobs it produces the error.
__________________
===[George R. Kasica]=== +1 262 677 0766
georgek@netwrx1.com +1 206 374 6482 FAX
http://www.netwrx1.com/georgek Jackson, WI USA
georgek@netwrx1.com
ICQ #12862186

("`-''-/").___..--''"`-._
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'

Last edited by gkasica; 14th February 2012 at 03:04 AM. Reason: added details
Reply With Quote
  #4  
Old 14th February 2012, 07:36 AM
BradW Offline
Registered User
 
Join Date: May 2004
Location: Concord, CA
Posts: 88
windows_vistafirefox
Re: My solution

I also ran this from the command line as root:

/usr/sbin/logrotate /etc/logrotate.conf

Last edited by BradW; 14th February 2012 at 07:37 AM. Reason: Added "as root"
Reply With Quote
  #5  
Old 14th February 2012, 12:16 PM
gkasica Offline
Registered User
 
Join Date: May 2008
Location: Jackson, WI
Age: 48
Posts: 44
windows_7ie
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

OK. So far today I DO NOT see the error after rerunning the above 2items last night. WIll give it a day to seeif its really gone then close ths if it is.
__________________
===[George R. Kasica]=== +1 262 677 0766
georgek@netwrx1.com +1 206 374 6482 FAX
http://www.netwrx1.com/georgek Jackson, WI USA
georgek@netwrx1.com
ICQ #12862186

("`-''-/").___..--''"`-._
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_.)' ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'
Reply With Quote
  #6  
Old 16th February 2012, 12:34 PM
gkasica Offline
Registered User
 
Join Date: May 2008
Location: Jackson, WI
Age: 48
Posts: 44
windows_7ie
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

Still working will consider this closed.
Reply With Quote
  #7  
Old 21st February 2012, 04:23 AM
BradW Offline
Registered User
 
Join Date: May 2004
Location: Concord, CA
Posts: 88
windows_vistafirefox
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

Unfortunately, this error returns upon reboot.
Reply With Quote
  #8  
Old 5th March 2012, 11:12 PM
pjoh Offline
Registered User
 
Join Date: Nov 2007
Posts: 84
linuxchrome
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

what fixed this for me was doing as stated in /etc/logrotate.d/mysqld file i.e.

# If the root user has a password you have to create a
# /root/.my.cnf configuration file with the following
# content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: This /root/.my.cnf should be readable ONLY
# for root !

password is mysql root users password

don't forget to
sudo chmod 600 /root/.my.cnf
Reply With Quote
  #9  
Old 6th March 2012, 06:18 AM
BradW Offline
Registered User
 
Join Date: May 2004
Location: Concord, CA
Posts: 88
windows_vistafirefox
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

Hi PJ,

I created .my.cnf, and will see how it goes next time I reboot.

It seems like something has changed though, since I've been running this same config for years, and this is yet another new one!

Brad
Reply With Quote
  #10  
Old 6th March 2012, 10:33 AM
pjoh Offline
Registered User
 
Join Date: Nov 2007
Posts: 84
linuxchrome
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

i agree, something changed.
found this in the update details for mysql-5.5.20-1.fc16
"Re-include the mysqld logrotate script, now that it's not so bogus"

https://admin.fedoraproject.org/upda...3cf494628490b3
Reply With Quote
  #11  
Old 6th March 2012, 02:14 PM
BradW Offline
Registered User
 
Join Date: May 2004
Location: Concord, CA
Posts: 88
windows_vistafirefox
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

Hi PJ,

I guess it's the price we pay for being on the bleeding edge!

Thanks for your help.

Brad
Reply With Quote
  #12  
Old 10th March 2012, 04:45 PM
BradW Offline
Registered User
 
Join Date: May 2004
Location: Concord, CA
Posts: 88
windows_vistafirefox
Re: /usr/bin/mysqladmin: connect to server at 'localhost' failed

Hi PJ,

Works fine after reboot. Adding /root/.my.cnf is good!

Brad
Reply With Quote
Reply

Tags
connect, failed, localhost, server

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
vmware-server cannot connect to localhost mb77 Using Fedora 0 5th June 2008 06:25 AM
cannot connect to X server localhost:10.0 suneesh Security and Privacy 3 3rd April 2008 03:33 AM
mysql error connect to server at 'localhost' failed peter5898 Using Fedora 6 12th February 2007 01:16 PM
can not find "mysqladmin" after install MySQL server 4.1.11 misaki Using Fedora 4 3rd June 2005 03:06 AM
localhost@127.0.0.1:4001 failed to connect Evert Using Fedora 0 4th July 2004 09:12 PM


Current GMT-time: 13:29 (Friday, 24-10-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat
Morondava - Debre Zeyit Photos - Schofield Barracks Travel Photos on Instagram