急急急!!!amoeba连进数据库,但是不能对数据库进行操作
废墟残梦 2017-01-01 02:58:48 对数据库进行增删改查时,报错:
ERROR 1044 (42000): Could not create a validated object, cause: ValidateObject failed
数据库给的权限是:
| GRANT USAGE ON *.* TO 'test1'@'IP地址' IDENTIFIED BY PASSWORD '*FD571203974BA9AFE270FE62151AE967ECA5E0AA' |
| GRANT ALL PRIVILEGES ON `demo`.* TO 'test1'@'IP地址' WITH GRANT OPTION
网上搜了好多,是没有给权限,但是权限已经给了,很纠结!!!
amoeba.xml的配置文件是:
<service name="Amoeba for Mysql" class="com.meidusa.amoeba.mysql.server.MySQLService">
<!-- port -->
<property name="port">8066</property>
<!-- bind ipAddress -->
<property name="ipAddress">IP地址</property>
<property name="connectionFactory">
<bean class="com.meidusa.amoeba.mysql.net.MysqlClientConnectionFactory">
<property name="sendBufferSize">128</property>
<property name="receiveBufferSize">64</property>
</bean>
</property>
<property name="authenticateProvider">
<bean class="com.meidusa.amoeba.mysql.server.MysqlClientAuthenticator">
<property name="user">root</property>
<property name="password">123456</property>
<property name="filter">
<bean class="com.meidusa.toolkit.net.authenticate.server.IPAccessController">
<property name="ipFile">${amoeba.home}/conf/access_list.conf</property>
</bean>
</property>
</bean>
</property>
</service>
dbservers.xml配置是:
<!-- mysql port -->
<property name="port">3306</property>
<!-- mysql schema -->
<property name="schema">demo</property>
<!-- mysql user -->
<property name="user">test1</property>
<property name="password">111111</property>
</factoryConfig>