1. Michael Ayres
  2. Valentina Studio
  3. Saturday, August 25 2018, 04:06 AM
  4.  Subscribe via 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?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Michael,
No, should not be anything special.
But why don’t you use MySQL connection instead of ODBC?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
ODBC connection works for me, what error message do you get when you try to connect?
Attachments (3)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Michael Ayres Accepted Answer
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:
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
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';
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
  • Page :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories