1. Michael Ayres
  2. Valentina Studio
  3. 土, 8月 25 2018, 04:06 AM
  4.  メールで購読
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?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Michael,
No, should not be anything special.
But why don’t you use MySQL connection instead of ODBC?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
ODBC connection works for me, what error message do you get when you try to connect?
添付ファイル
コメント
There are no comments made yet.
Michael Ayres 承諾済みの回答
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:
添付ファイル
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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';
コメント
There are no comments made yet.
  • ページ :
  • 1


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