Cant get schema from MySQL

Nov 26, 2012 at 9:35 AM
Edited Nov 26, 2012 at 9:42 AM

Hello, I have a problem with MySQL.

I try to execute this code:

DataTable table = MyCon.GetSchema("Tables");
string providername = "MySql.Data.MySqlClient";
DatabaseReader dbReader = new DatabaseReader(MyConStr, providername);
var schema = dbReader.ReadAll();

 

and then error http://pix.am/ckVz.png

MySQL version 5.6.7

DataBase Shema Reader v1.2.5.0

Coordinator
Nov 27, 2012 at 7:56 AM

it's possible there's some privileges required- for InnoDb tables you need Process privilege. The database schema reader requires you to have sufficient privileges (it can't circumvent the security model).

otherwise, MySql has changed their metadata somehow. I don't see anything in the documentation. The referential constraints table is still listed against MySql 5.6 so it should be there: http://dev.mysql.com/doc/refman/5.6/en/referential-constraints-table.html

 

The current general available release is still 5.5.28 (5.6.7 is a Release Candidate released September 2012; there was a 5.6.8 release November 2012).

I'll get a recent version and see if it's ok. 

 

Coordinator
Nov 27, 2012 at 3:43 PM

I'm running MySql 5.6.7-rc

No special configuration, just standard databases- sakila, world, northwind, a couple of real world schemas.

Database Schema Reader reads the databases fine.

Could it be a permissions problem?

Nov 28, 2012 at 1:37 PM

Thank you, I reinstall MySql, delete appserv and then all reads fine.