View Single Post
  #6  
Old 11th July 2007, 09:37
paul55 paul55 is offline
Junior Member
 
Join Date: Apr 2007
Location: Greece
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Default

When i run
Code:
mysqladmin -h localhost -u root password myrootsqlpassword
i get
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
but when i run
Code:
mysqladmin -hlocalhost -u root -p version
it connects
Code:
mysqladmin  Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.32-Debian_7etch1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 13 min 19 sec

Threads: 1  Questions: 141  Slow queries: 0  Opens: 135  Flush tables: 1  Open tables: 17  Queries per second avg: 0.032
while when i run
Code:
mysqladmin -h myhostname -u root -p version
i get
Code:
mysqladmin: connect to server at 'medic3' failed
error: 'Access denied for user 'root'@'medic3.medichome' (using password: YES)'
Code:
netstat -tap
gives
Code:
# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:4137                  *:*                     LISTEN     2450/rpc.statd
tcp        0      0 *:mysql                 *:*                     LISTEN     2148/mysqld
tcp        0      0 *:sunrpc                *:*                     LISTEN     1828/portmap
tcp        0      0 *:auth                  *:*                     LISTEN     2321/inetd
tcp        0      0 *:ftp                   *:*                     LISTEN     2481/proftpd: (acce
tcp        0      0 192.168.123.168:domain  *:*                     LISTEN     2049/named
tcp        0      0 localhost.locald:domain *:*                     LISTEN     2049/named
tcp        0      0 *:smtp                  *:*                     LISTEN     2381/master
tcp        0      0 localhost.localdoma:953 *:*                     LISTEN     2049/named
tcp6       0      0 *:imaps                 *:*                     LISTEN     2293/couriertcpd
tcp6       0      0 *:pop3s                 *:*                     LISTEN     2311/couriertcpd
tcp6       0      0 *:pop3                  *:*                     LISTEN     2298/couriertcpd
tcp6       0      0 *:imap2                 *:*                     LISTEN     2281/couriertcpd
tcp6       0      0 *:www                   *:*                     LISTEN     2513/apache2
tcp6       0      0 *:domain                *:*                     LISTEN     2049/named
tcp6       0      0 *:ssh                   *:*                     LISTEN     2410/sshd
tcp6       0      0 *:smtp                  *:*                     LISTEN     2381/master
tcp6       0      0 ip6-localhost:953       *:*                     LISTEN     2049/named
tcp6       0      0 *:https                 *:*                     LISTEN     2513/apache2
tcp6       0      0 ::ffff:192.168.123.:ssh ::ffff:192.168.123:4113 ESTABLISHED2560/sshd: paul555

Last edited by paul55; 11th July 2007 at 10:49.
Reply With Quote