Prev Previous Post   Next Post Next
  #1  
Old 22nd June 2008, 13:57
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default MySQL problem

Hi folks,


Ubuntu 7.04 server amd64


It just comes to my notice on running following commands

$ sudo /etc/init.d/mysql stop
Code:
 * Stopping MySQL database server mysqld       [fail]

$ sudo /etc/init.d/mysql start
Code:
 * Starting MySQL database server mysqld        [ OK ] 
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

I suppose the problem is caused by running several 'apt-get update' and 'apt-get upgrade'. Before MySQL start/stop without problem nor having warning.


Please advise how to fix this problem. TIA


Edit-1 :
$ sudo cat /etc/mysql/debian.cnf
Code:
Password:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = EdKLb0cr3GElkUdM
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user     = debian-sys-maint
password = EdKLb0cr3GElkUdM
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

"user = debian-sys-maint" is still there.


Edit-2:

$ sudo netstat -tap
Code:
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name   
tcp        0      0 *:20000                 *:*                     LISTEN     5717/perl           
tcp        0      0 *:nfs                   *:*                     LISTEN     -                   
tcp        0      0 *:poppassd              *:*                     LISTEN     5066/inetd          
tcp        0      0 *:mysql                 *:*                     LISTEN     4774/mysqld         
tcp        0      0 localhost.lo:bacula-dir *:*                     LISTEN     5605/bacula-dir     
tcp        0      0 *:8333                  *:*                     LISTEN     5574/httpd.vmware   
tcp        0      0 localhost.loc:bacula-fd *:*                     LISTEN     5565/bacula-fd      
tcp        0      0 localhost.loc:bacula-sd *:*                     LISTEN     5402/bacula-sd      
tcp        0      0 *:sunrpc                *:*                     LISTEN     4185/portmap        
tcp        0      0 *:webmin                *:*                     LISTEN     5721/perl           
tcp        0      0 *:www                   *:*                     LISTEN     5557/apache2        
tcp        0      0 *:41424                 *:*                     LISTEN     -                   
tcp        0      0 172.16.103.1:domain     *:*                     LISTEN     4609/named          
tcp        0      0 172.16.59.1:domain      *:*                     LISTEN     4609/named          
tcp        0      0 *:ftp                   *:*                     LISTEN     5346/proftpd: (acce 
tcp        0      0 mail.satimis.com:domain *:*                     LISTEN     4609/named          
tcp        0      0 localhost.locald:domain *:*                     LISTEN     4609/named          
tcp        0      0 mail.satimis.com:ssh    *:*                     LISTEN     5178/sshd       
tcp        0      0 localhost.localdoma:ipp *:*                     LISTEN     4691/cupsd          
tcp        0      0 *:824                   *:*                     LISTEN     5310/rpc.rquotad    
tcp        0      0 *:smtp                  *:*                     LISTEN     5132/master         
tcp        0      0 *:985                   *:*                     LISTEN     5046/rpc.mountd     
tcp        0      0 localhost.localdoma:953 *:*                     LISTEN     4609/named          
tcp        0      0 *:34362                 *:*                     LISTEN     5270/rpc.statd      
tcp        0      0 *:https                 *:*                     LISTEN     5557/apache2        
tcp        0      0 *:8222                  *:*                     LISTEN     5574/httpd.vmware   
tcp        1      0 mail.satimis.com:49999  128.241.220.88:www      CLOSE_WAIT 8657/npviewer.bin   
tcp        1      0 mail.satimis.com:52503  static.88-198-197-1:www CLOSE_WAIT 8657/npviewer.bin   
tcp        1      0 mail.satimis.com:43337  cf-in-f127.google.c:www CLOSE_WAIT 8657/npviewer.bin   
tcp        1      0 mail.satimis.com:54761  128.241.220.90:www      CLOSE_WAIT 8657/npviewer.bin   
tcp        0      0 mail.satimis.com:54554  128.241.220.88:www      ESTABLISHED8657/npviewer.bin   
tcp        1      0 mail.satimis.com:48350  cf-in-f165.google.c:www CLOSE_WAIT 8657/npviewer.bin   
tcp        1      0 mail.satimis.com:48347  cf-in-f165.google.c:www CLOSE_WAIT 8657/npviewer.bin   
tcp        1      0 mail.satimis.com:34771  www.howtoforge.com:www  CLOSE_WAIT 8657/npviewer.bin   
tcp        0      0 mail.satimis.com:34770  www.howtoforge.com:www  CLOSE_WAIT 8657/npviewer.bin   
tcp6       0      0 *:imaps                 *:*                     LISTEN     4940/couriertcpd    
tcp6       0      0 *:pop3s                 *:*                     LISTEN     4975/couriertcpd    
tcp6       0      0 *:pop3                  *:*                     LISTEN     4953/couriertcpd    
tcp6       0      0 *:imap2                 *:*                     LISTEN     4920/couriertcpd    
tcp6       0      0 *:domain                *:*                     LISTEN     4609/named          
tcp6       0      0 *:smtp                  *:*                     LISTEN     5132/master         
tcp6       0      0 ip6-localhost:953       *:*                     LISTEN     4609/named

$ cat /etc/hosts
Code:
127.0.0.1       localhost.localdomain   localhost
192.168.0.10    mail.satimis.com        mail
#               mail.satimis.com        mail
#127.0.0.1      satimis.com

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts



B.R.
satimis

Last edited by satimis; 22nd June 2008 at 19:09. Reason: adding more info
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
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
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 18:40
help with mysql connection problem please... shd0w Technical 14 29th June 2007 17:56
MySQL Cluster Howto-Lo0 problem tfunky HOWTO-Related Questions 12 24th June 2007 23:09
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 20:49
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53


All times are GMT +2. The time now is 20:22.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.