'infinidb_vtable.$vtable_936' doesn't exist

2 posts / 0 new
Last post
priyanka.jain
priyanka.jain's picture
Offline
Last seen: 3 years 2 weeks ago
Joined: Aug 29 2011
Junior Boarder

Posts: 3

Priyanka Jain
'infinidb_vtable.$vtable_936' doesn't exist

Trying to run a query on infinidb database using Java code,gets the following error

[b]com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'infinidb_vtable.$vtable_936' doesn't exist[/b]

I have granted all rights to all users on infinidb_vtable database using the following command:

grant ALL on infinidb_vtable.* to root;

Still the error exists.Please help.

radams
radams's picture
Offline
Last seen: 4 days 18 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
Re: 'infinidb_vtable.$vtable_936' doesn't exist

Hi,

Here is some information on granting privileges.

Idbmysql
mysql>use mysql;
mysql>grant all on .* to ‘’@’’ identified by ‘’;
mysql>flush privileges;

Here is an example of the grant statement:

grant all on retail.* to ‘root’@’10.1.1.1’ identified by ‘mypassword’;

thanks,

Robert
Calpont