/usr/local/mysql/bin/mysql -uroot -p123 -h 192.168.3.96
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.3.96' (111)
 
1、查看mysql服务的端口,netstat -nlp,如果服务端口不是3306,需要用-p参数指定
2、查看iptables是否开启
3、检查用户权限
select User,Host from mysql.user;
如果没有权限的话,需要添加上去
grant all on *.* to 'root'@'192.168.3.%' identified by '123';
flush privileges;