- Inside OpenAccess: "test database connection" works fine, and
- "Check setting", all checking results are green. and
- The same login credential, I can use it to login to GoDaddy to do everything on my MySQL. (It must admin.)
My question is that, is there special steps I might missed on OpenAccess side? Thanks for your help!!!
Here is the full compiling log (my IP and name are modified):
------ Rebuild All started: Project: Model, Configuration: Debug Any CPU ------
C:\Windows\Microsoft.NET\Framework\v3.5\Csc.exe /noconfig /nowarn:1701,1702 /errorreport:prompt /warn:4 /define:DEBUG;TRACE /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Core.dll" /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Data.DataSetExtensions.dll" /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Xml.Linq.dll" /reference:"C:\Program Files (x86)\Telerik\OpenAccess ORM\bin\Telerik.OpenAccess.dll" /reference:"C:\Program Files (x86)\Telerik\OpenAccess ORM\bin\Telerik.OpenAccess.Query.dll" /debug+ /debug:full /filealign:512 /optimize- /out:obj\Debug\Model.dll /resource:App.config,Model.App.config /target:library myModel.cs Properties\AssemblyInfo.cs
Compile complete -- 0 errors, 0 warnings
Model -> C:\Proj\Model\Model\bin\Debug\Model.dll
c:\program files (x86)\telerik\openaccess orm\sdk\VEnhance.exe -assembly:C:\Proj\Model\Model\obj\Debug\Model.dll -config:C:\Proj\Model\Model\App.config -debug+ -verbose+
Enhancement complete -- 0 errors, 0 warnings
Model -> C:\Proj\Model\Model\bin\Debug\Model.dll
c:\program files (x86)\telerik\openaccess orm\bin\VSchema.exe -assembly:C:\Proj\Model\Model\bin\Debug\Model.dll -migrate
SELECT command denied to user 'user1'@'75.149.111.11' for table 'proc'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.SchemaProvider.GetProcedures(String[] restrictions)
at MySql.Data.MySqlClient.ISSchemaProvider.GetProcedures(String[] restrictions)
at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions)
at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions)
at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName, String[] restrictionValues)
at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName)
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.Ado2Relational.GetProcedures(ConnectionImp conImp, String catalog, String schemaPattern, String procedureNamePattern)
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DatabaseMetaDataImp.getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
at OpenAccessRuntime.Relational.sql.MySqlSqlDriver.getProcedures(Connection con, ControlParams param, List`1 result)
at OpenAccessRuntime.Relational.sql.SqlDriver.checkDDL(ICollection`1[] tables, Connection con, StreamWriter errors, StreamWriter fix, ControlParams controlParams, StreamWriter messages)
at OpenAccessRuntime.Relational.sql.MySqlSqlDriver.checkDDL(ICollection`1[] tables, Connection con, StreamWriter errors, StreamWriter fix, ControlParams controlParams, StreamWriter messages)
at OpenAccessRuntime.DataObjects.tools.ant.SchemaMigrationTask.migrateDatabase()
OpenAccess Error: Telerik.OpenAccess: Updating SQL schema failed. MySql.Data.MySqlClient.MySqlException: SELECT command denied to user 'user1'@'75.149.111.11' for table 'proc'
OpenAccess Error: SELECT command denied to user 'user1'@'75.149.111.11' for table 'proc'
Update DatabaseSchema complete -- 2 errors, 0 warnings
========== OpenAccess All: 0 succeeded, 1 failed, 0 skipped ==========
OpenAccess : Build Cancelled due to enhancement error(s).