未知mysql主机怎么办_mysqladmin – 未知的MySQL服务器主机

我正在尝试通过本地网络连接到

mysql服务器.服务器正在运行并正在侦听帖子41322.

dylan~$netstat -ln | s mysql

unix 2 [ ACC ] STREAM LISTENING 41322 /var/run/mysqld/mysqld.sock

我的用户被授予所有地址的所有权限,我可以在本地登录.

dylan~$mysqladmin -P 41322 -h dylan@10.0.0.10 create database test

mysqladmin: connect to server at 'dylan@10.0.0.10' failed

error: 'Unknown MySQL server host 'dylan@10.0.0.10' (1)'

Check that mysqld is running on dylan@10.0.0.10 and that the port is 41322.

You can check this by doing 'telnet dylan@10.0.0.10 41322'

添加–verbose标志不会产生额外的输出.我在服务器上的/etc/mysql/my.cnf中注释掉了bind-address = 127.0.0.1.我可以毫不费力地进入服务器.

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

任何帮助或想法都表示赞赏.