Configuration of MySQL 5.5 on Websitepanel

So I followed these steps to activate MySQL 5.5 on our websitepanel deployment.

The current version of Websitepanel (1.1.0) doesn’t support Mysql by default.  However, with a few small changes you can get the Mysql version 5.5 to work.

• Install mysql as outlined on http://dev.websitepanel.net/installation-guide/installing-mysql-server
• As described on the websitepanel forum, Download the custom build DLL’s.  of the 5.5 provider.
  As supplied by Anatolii Ivashyna, you can find this files here: http://www.aurora.com.ua/software/websitepanel/websitepanel.110.mysqlfix.zip (remember, this files only for 1.1.0 version!)
• Install the latest .Net Connector for MySQL
• update the Web.Config as described by Pavel Тsurbeleu.  Add this code on the bottom (before the end configuration tag)

<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
    <dependentAssembly>
<assemblyIdentity name="MySql.Data" publicKeyToken="c567fc88969c44d" />
<bindingRedirect oldVersion="0.0.0.0-6.3.5.0" newVersion="6.3.6.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>

• Finally add and update the MySQL configuration in website panel.  These where the values I used
  • Internal Address: 127.0.0.1:3306
  • MySQL Installation Folder: C:\Program Files\MySQL\MySQL Server 5.5
  • Database Browser Logon URL: http://phpmyadmin.ourdomain.com/index.php
  • Root login: root
  • Root password: our root password

There is still a bug with deleting the database.  There are solutions available for this problem, but it’s not urgent for me.  So I didn’t tried it.