MySQL permission to mysql database required

Posts   
 
    
jaskey avatar
jaskey
User
Posts: 23
Joined: 09-Jul-2006
# Posted on: 17-Oct-2011 21:45:53   

Hello...

I am attempting to generate an ER project for MySQL using the newest Devart package (I had trial, now I have purchased Professional version).

The problem that I am having is that on the 'Relational Model Data Retrieval Wizard' dialog page, I am getting an error when I hit 'test' because I don't have access to the mysql system database, just the individual database. Because I can't specify the database on the connection dialog, I am at a dead end...

Access denied for user 'services'@'%' to database 'mysql'

LLBLGen Pro version 3.1. Build February 7th, 2011 -----[Core exception]-------------------- at Devart.Data.MySql.bk.t() at Devart.Data.MySql.u.a(String A_0, String A_1, String A_2, String A_3, Int32 A_4, String A_5, Int32 A_6, SshOptions A_7, SslOptions A_8, ProxyOptions A_9, MySqlHttpOptions A_10, HttpOptions A_11) at Devart.Data.MySql.MySqlInternalConnection.Connect(MySqlConnection owner, String userId, String password, String host, String database, Int32 port, Int32 connectionTimeout, MySqlProtocol protocol, Boolean compress, Boolean clientInteractive) at Devart.Data.MySql.MySqlInternalConnection..ctor(o connectionOptions, MySqlConnection owner) at Devart.Data.MySql.ar.a(u A_0, Object A_1, DbConnectionBase A_2) at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, u A_1, DbConnectionBase A_2) at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0) at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection) at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0) at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection) at Devart.Common.DbConnectionBase.Open() at Devart.Data.MySql.MySqlConnection.Open() at SD.LLBLGen.Pro.Gui.Controls.WizardPages.MetaDataRetrievalWizard_Step_ConnectionData.TestConnectionData()

This is a server that I don't have admin access too so I can only connect with my specific database user... how can I get past the 'test'??

thank you... I apologize if this is answered somewhere, I looked in the manual and perused the forums and didn't see anything about this problem.

thank you ja

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 18-Oct-2011 07:09:15   

Indeed the permission is the problem. The user/pass you use must have admin privileges because the database metadata LLBLGen collects is in the system database/tables. Maybe the DBA could give you a backup of the database (without data maybe) so you can install it locally and work with it. When the code is generated you can connect to the real database with your usual db user.

David Elizondo | LLBLGen Support Team