One: Problem description
[root @ localhost mytop 1.6] #/usr/local/webserver/mysql/bin/mysql -u admin – p12345678 – h 172.29.141.112:3306 – e “show databases;”
ERROR 2005 (HY000): Unknown MySQL server host ‘172.29.141.112:3306’ (0)
[root@localhost mytop-1.6]#
 
Two: Problem solving
[root @ localhost mytop 1.6] #/usr/local/webserver/mysql/bin/mysql -u admin – p12345678 172.29.141.112 – P – 3306 – h e “show databases;”
+ — — — — — — — — — — — — — — — — — — — — +
| Database |
+ — — — — — — — — — — — — — — — — — — — — +
| information_schema |
| | blog
| mysql |
| performance_schema |
| Test |
+ — — — — — — — — — — — — — — — — — — — — +
[root @ localhost mytop 1.6] #
 
Three: The problem
Mysql didn’t support mysql-H IP :port. You might have thought something was wrong, but if you thought about it at the time, you would have found it. You would have posted it on the iptub.
 
Four: Other reasons
Firewall issues, /etc/init.d/iptables stop off, or reset