Thread: MySQL problem
View Single Post
  #1  
Old 22nd June 2008, 14: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 20:09. Reason: adding more info
Reply With Quote
Sponsored Links