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