• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

    MySQL version

    User help
    3
    6
    635
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      mseverin last edited by

      I'm going to convert my H2 database to a MySql database. I have read all the posts I can find and am confident I can manage the conversion but I didn't find anything about what version of MySQL to use and I want to make sure I use a version of MySql that has been tested.

      What is the recommended version of MySQL should I be installing?

      I'm running Mango version 3.7.4.

      1 Reply Last reply Reply Quote 0
      • terrypacker
        terrypacker last edited by

        Since Mango 3.7.0 we are using a JSON type column so as per the release notes:

        * IMPORTANT the User data column in the database is of type JSON for MySQL which is only supported in version 5.7.8 and above

        1 Reply Last reply Reply Quote 0
        • cmusselm
          cmusselm last edited by

          The statement above implies Mango 3.7.x is compatible with MySQL v8.x. Is it possible to get verification this is the case?

          1 Reply Last reply Reply Quote 0
          • terrypacker
            terrypacker last edited by

            @cmusselm I have not explicitly tested v8.x but I have no reason to think it would not work.

            1 Reply Last reply Reply Quote 0
            • cmusselm
              cmusselm last edited by

              Awesome, thank you!

              1 Reply Last reply Reply Quote 0
              • cmusselm
                cmusselm last edited by

                FYI, I did upgrade the MySQL DB to 8.x over a week ago and all is running well; no issues.

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post