Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Michele Di Maria 34 posts 239 karma points
    Jun 20, 2018 @ 10:05
    Michele Di Maria
    0

    Umbraco not working after MySQL Upgrade from 5.7 to 8.0

    Hi, after we upgraded our MySQL server (running on Windows) from version 5.7 to 8.0.11 Umbraco stopped working.

    The error that Umbraco shows is Cannot implicitly convert type 'string' to 'System.Guid?' on the startup. Before the upgrade everything was working great.

    What consoles me is that also other applications are having issues (Zabbix for example), so must be something changed in MySQL or some bug of the version 8.0 to cause the issue.

    Do you guys already have this issue? How did you solve it?

    Thanks, Michele

    Copy Link
  • Michele Di Maria 34 posts 239 karma points
    Aug 27, 2018 @ 09:32
    Michele Di Maria
    0

    Hello, am I the only one who is trying to make Umbraco work with MySQL 8?

    Thanks, Michele

    Copy Link
  • Michele Di Maria 34 posts 239 karma points
    Feb 25, 2019 @ 08:38
    Michele Di Maria
    100

    Hello, just to share: I solved the problem.

    In order to let Umbraco work with MySQL Server 8, must use the MySQL Connector version 8.

    Just need to replace the DLL MySql.Data.dll distributed with Umbraco with the version 8.X, then add in the web.config the following:

    <dependentAssembly>
    <assemblyIdentity name="MySql.Data" publicKeyToken="c5687fc88969c44d" culture="neutral" />
    <bindingRedirect oldVersion="0.0.0.0-6.9.9.0" newVersion="8.0.15.0" />
</dependentAssembly>

    And then it works.

    Cheers, Michele

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft