端口开启情况(同时打开防火墙)
[root@h102 mycat]# netstat -ant | grep 8066
tcp 0 0 :::8066 :::* LISTEN
[root@h102 mycat]# lsof -i :8066
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 32760 root 60u IPv6 166556 0t0 TCP *:8066 (LISTEN)
[root@h102 mycat]#
[root@h102 mycat]# iptables -L -nv | grep 8066
0 0 ACCEPT tcp -- * * 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:8066
[root@h102 mycat]#
启动服务后确保防火墙开启的情况下,可以直接使用mysql客户端进行连接
[root@h101 ~]# mysql -utest -ptest -P8066 -h 192.168.100.102
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.8-mycat-1.5-GA-20160217103036 MyCat Server (OpenCloundDB)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+----------+
| DATABASE |
+----------+
| TESTDB |
+----------+
1 row in set (0.01 sec)
mysql> use TESTDB
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------+
| Tables in TESTDB |
+------------------+
| company |
| customer |
| customer_addr |
| employee |
| goods |
| hotnews |
| orders |
| order_items |
| travelrecord |
+------------------+
9 rows in set (0.01 sec)
mysql> desc company;
ERROR 3009 (HY000): java.lang.IllegalArgumentException: Invalid DataSource:0
mysql> desc goods;
ERROR 3009 (HY000): java.lang.IllegalArgumentException: Invalid DataSource:0
mysql>
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。