1. Michael Ayres
  2. Valentina Studio
  3. Samstag, August 25 2018, 04:06 AM
  4.  Abonnieren via E-Mail
Brand new to Valentina Studio Pro I bought for Mac OSX which runs MySql which connects easily to Tableau. Should be simple but I cannot get a basic ODBC and corresponding driver set up to get V to talk with my MySQL. OSX High Sierra. None of my many attempts to set up and ODBC works. Any specific instructions for ODBC/Driver for V to mySLQ on OSX?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Michael,
No, should not be anything special.
But why don’t you use MySQL connection instead of ODBC?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
ODBC connection works for me, what error message do you get when you try to connect?
Anhänge
Kommentar
There are no comments made yet.
Michael Ayres Akzeptierte Antwort
Sergey, Yes, using Valenina's build in mySQL connection seems the simplest and most direct, but when it failed I went to ODBC which fails oo. See is the screen with error with mySQL connector in V:
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Thank you, so the problem is that MySQL 8.0 uses a different authentication plugin, not supported by MariaDB client used in the Valentina Studio.

Here's the discussion
https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded

While it is not supported and we're working on fixing it, you can create a new user which uses an older plugin
CREATE USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'user_password';

Or alter an existing
ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'user_password';
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.