How do I set standard authentication for a user
I use MySQL 8.0.12 on a macOS 10.13.6 Apple laptop. My Workbench version is 8.0.
I have MySQL databases that must be accessed by R scripts and the RMySQL package apparently doesn't like SHA2 authentication. I logged into Workbench as root, went to Management/Users and Privileges and tried to change the Authentication Type for the proper user. The screen suggests using the "Standard" authentication type here, but Workbench only allows "caching SHA256 Password" as an option (it's greyed out and I can't scroll to any other method). How can I use "Standard"???
Subject
Views
Written By
Posted
How do I set standard authentication for a user
6201
September 28, 2018 02:39PM
2635
October 03, 2018 07:23PM
1844
April 09, 2019 03:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.