MySQL Forums
Forum List  »  MySQL Workbench

Re: fresh install problem
Posted by: Mike Lischke
Date: April 27, 2018 01:46AM

MySQL Workbench version < 8.x cannot login to a MySQL server when a cached sha2 password is used for that user. This auth method has been made the default only recently right before the 8.0.11 server was released. All new accounts will have this auth method unless you switched this off in your server config.

Download the MySQL Workbench release 8.0.11 RC to be able to use such accounts (this is a development release) or use the command line to change the auth method for that user to native, which will allow older Workbench versions to login.

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/5.7/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
78
April 26, 2018 01:46PM
41
April 26, 2018 01:48PM
Re: fresh install problem
37
April 27, 2018 01:46AM


Sorry, only registered users may post in this forum.

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.