mysqladmin - Unknown MySQL server host

Posted by ert on Server Fault See other posts from Server Fault or by ert
Published on 2011-03-19T20:35:26Z Indexed on 2011/03/20 0:11 UTC
Read the original article Hit count: 644

Filed under:
|

I'm trying to connect to a mysql server over a local network. The server is running and listening to post 41322.

dylan~$ netstat -ln | s mysql
unix  2      [ ACC ]     STREAM     LISTENING     41322    /var/run/mysqld/mysqld.sock

My user is granted all rights from all addresses, and I can log in locally.

dylan~$ mysqladmin -P 41322 -h [email protected] create database test
mysqladmin: connect to server at '[email protected]' failed
error: 'Unknown MySQL server host '[email protected]' (1)'
Check that mysqld is running on [email protected] and that the port is 41322.
You can check this by doing 'telnet [email protected] 41322'

Adding a --verbose flag gives no additional output. I've commented out bind-address=127.0.0.1 in /etc/mysql/my.cnf on the server. I can ssh into the server without a problem.

dylan~$ ps a | grep mysql
11131 pts/3    S      0:00 /bin/sh /usr/bin/mysqld_safe
11170 pts/3    Sl     0:03 /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
11171 pts/3    S      0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
13710 pts/1    S+     0:00 grep mysq

Any help or thoughts are appreciated.

© Server Fault or respective owner

Related posts about mysql

Related posts about mysqladmin