Hi all i have just installed debian etch following that howto but i have a problem about configuring the mysql server.Exactly when i try to run Code: mysqladmin -h myhostname.mydomainname -u root password my-mysqlrootpassword i get this error: Code: mysqladmin: connect to server at 'medic3.medichome' failed error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 113' .The server is running Code: medic3:/home/paul555# ps -ef |grep mysql root 2154 1 0 15:29 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe mysql 2191 2154 0 15:29 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 2192 2154 0 15:29 ? 00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld root 2648 2626 0 16:01 pts/0 00:00:00 grep mysql and i have created ok the root password previously with Code: mysqladmin -u root password my-mysqlrootpassword .Does anyone have an idea?
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
Please install phpMyAdmin, then open the mysql.user table in phpMyAdmin. You should have two records for root there, one with localhost in the Host column and one with another hostname (which seems to be wrong). Correct this other hostname. And while you're at it, you can also set the password for this user.
I found my mistake.I just hadn't set a password for user root at myhostname Sorry for my mistake and thanks for your time
I still have this similar problem. Code: mysqladmin -u root password xxxxxxxx mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Code: mysqladmin -h myhostname -u root password xxxxxxxxx mysqladmin: connect to server at 'myhostname' failed error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' Stuck in this step.