Ok, I'm making progress with MySql and GoDaddy - here is where I am now, but could do with some assistance please.
I noticed that the version of MySql.Data.dll in the Sitefinity \bin folder is v22.214.171.124, however this doesn't have the AllowPartiallyTrustedClients attribute, so won't work in a medium trust environment. However v126.96.36.199 and higher *does* have the attribute, so I downloaded this and put it in the \bin folder. I also needed to add a binding redirect to web.config to force Sitefinity to use this version:
<assemblyIdentity name="MySql.Data" publicKeyToken="c5687fc88969c44d"/>
<bindingRedirect oldVersion="188.8.131.52" newVersion="184.108.40.206"/>
So far so good - Sitefinity is still working fine on my PC after making these changes. However if you change to medium trust you'll find that it throws a security exception when MySql attempts to open a socket connection via System.Net. Apparently it's a known problem with MySql and medium trust, and requires the SocketPermission to be granted.
It turns out that GoDaddy have had this permission in place for a couple of years - my problem all along was your version of MySql.Data.dll, which doesn't allow partially trusted callers!
After making the above changes in GoDaddy I now get a new exception:
Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Telerik.DataAccess.ProviderDatabaseUpgradeException: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[ProviderDatabaseUpgradeException: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.]
Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +2180
Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +673
Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings) +91
Telerik.ManagerBase`1.SetProvider(String providerName) +203
Telerik.ManagerBase`1..ctor(String providerName) +89
Telerik.Cms.Web.UrlHelper.Initialize(CmsHttpModule cmsModule) +38
Telerik.Cms.Web.CmsHttpModule.Init(HttpApplication context) +86
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo handlers) +729
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +298
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +107
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +289
The database on GoDaddy is a copy of what's on my dev PC (I used mysqldump then ran the script on GoDaddy). I also followed the user manual first, and created content in each module. Any ideas what the problem might be?
Thanks in advance