1. Michael Ayres
  2. Valentina Studio
  3. Суббота, Август 25 2018, 04:06 AM
  4.  Подписаться через email
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.