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
mysql
|mysqladmin
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