mysql amoeba 链接111_通过Amoeba连接Mysql

安装好amoeba后，启动

修改两个文件，amoeba-mysql-binary-2.2.0/conf目录下dbServers.xml和amoeba.xml(即设置下mysql连接密码)

vi dbServers.xml

改为(其中为注释，要去掉)

123456

vi amoeba.xml

password

改为

123456

启动amoeba

/root/amoeba-mysql-binary-2.2.0/bin/amoeba start

log4j:WARN log4j config load completed from file:/root/amoeba-mysql-binary-2.2.0/conf/log4j.xml

2015-10-15 17:05:10,393 INFO context.MysqlRuntimeContext - Amoeba for Mysql current versoin=5.1.45-mysql-amoeba-proxy-2.2.0

log4j:WARN ip access config load completed from file:/root/amoeba-mysql-binary-2.2.0/conf/access_list.conf

2015-10-15 17:05:10,649 INFO net.ServerableConnectionManager - Amoeba for Mysql listening on 0.0.0.0/0.0.0.0:8066.

2015-10-15 17:05:10,649 INFO net.ServerableConnectionManager - Amoeba Monitor Server listening on /127.0.0.1:50513.连接mysql(端口改为8066即可)

mysql -uroot  -h127.0.0.1 -P8066 -p123456

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 1719451110

Server version: 5.1.45-mysql-amoeba-proxy-2.2.0 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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 |

+--------------------+

| information_schema |

| bbp |

| lmis |

| mtms |

| myisam |

| mysql |

| performance_schema |

| test |

| zabbix |

+--------------------+

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！