Xojo and MySQL 8.0

  1. 7 months ago

    Peter T

    is not verified 27 Jan 2019 Albany Creek QLD Australia

    Does Xojo 2018r4 support MySQL 8.0 with SHA256 password encryption?

    I've been struggling to install MySQL and have just finished removing every reference of MySQL on my local PC.

    I'm reinstalling, and thought I'd ask this question before continuing the install.

    Thanks

  2. James D

    27 Jan 2019 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    Can’t help you with your actual question. But I would highly recommend you consider using a docker image to run MySQL locally. That way you can install, run and delete versions with a single command. In my opinion docker is the best thing since sliced loaves from a developer’s point of view.

  3. Peter T

    is not verified 27 Jan 2019 Albany Creek QLD Australia

    Okay. I'll bite. What's a docker image?

  4. Beatrix W

    27 Jan 2019 Pre-Release Testers Europe (Germany)

    It's like a VM but for apps: you download the Docker container for your app and that's it. No installation, no hassle. The Docker container is just huge.

  5. Greg O

    27 Jan 2019 Xojo Inc

    You may also want to try out MAMP. It’s another quick way to get MySQL up and running.

    https://www.mamp.info/en/

  6. @Peter T, @Greg OLone — I love MAMP as it is so easy to use

  7. James D

    27 Jan 2019 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    @Peter T Okay. I'll bite. What's a docker image?

    In a nutshell, Docker is a virtualized Linux kernel. Unlike a VM, it relies on the host system for IO etc. It is available on many platforms such as Mac and Windows and is supported by most of the major vendors. And it is very lightweight.

    A Docker image contains a Linux kernel that has been configured to run a particular application such as MySQL. This means it includes not only the kernel, but also all third party libraries etc that are required to run the application.

    There is a lot more to Docker, but the part we are interested in here is the ability to quickly get an instance of a database server up and running on a local machine. Once Docker is installed, it requires just two commands: One to download an image from the vendor and another to start the image and map it to a local port.

    Of course this means you can quickly test various database versions, clone instances and make changes etc..

  8. James D

    27 Jan 2019 Pre-Release Testers, Xojo Pro Europe (Switzerland)

    @Greg OLone You may also want to try out MAMP. It’s another quick way to get MySQL up and running.

    https://www.mamp.info/en/

    It is now old school. It was a great idea in its day. But we’ve moved on. A Docker image is much lighter on resources and faster to install.

    Also Docker is supported by all the major vendors and they already have the images available for use.

    I’m currently doing some work on SQL Server and I’m running it on my Mac, thanks to an MS provided image.

  9. Christian S

    27 Jan 2019 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    Well, I can say with MBS Xojo SQL Plugin , you can use your own mysql library version.

    That should work with encryption, if you set a few options.

  10. Marius D

    28 Jan 2019 Pre-Release Testers Herford, Germany

    You have to use SSL connection to be able to use SHA256 Passwords.
    But you you could add another user to MySQL 8.0 that is using mysql_native_password. This is working out of the box.

  11. 6 weeks ago
    Edited 6 weeks ago

    Hi
    I am new to Xojo and have a new project to work on. Just a small utility app that connects to a MySQL DB. Seems a good app to get me started on Xojo (25 years programming in VB, VB dot NET etc).
    Question is, the DB Server has just been upgraded to MySQL 8. So I want to be sure that Xojo will connect and work OK. The server is set to use Native Passwords, not SHA, so connections should be OK. But with our VB apps we have had issues when using the old connector (used with MySQL 5.7) and running stored procedures. Because MySQL has changed the way it stores information about procedures, views etc, the old connector can't run procedures and comes up with an error saying it cant check the parameters.
    We got around this (until we update the connector) by adding 'NO_CHECK_PARAMETERS' in the connection string. Not ideal, but it does work.
    Does anybody know if procedures in MySQL 8 work OK in Xojo and if not, is there a similar work around.
    Many thanks
    Mark

or Sign Up to reply!