Bug #94353 Access Denied until root logs into Workbench
Submitted: 15 Feb 2019 18:19 Modified: 19 Mar 2019 23:10
Reporter: Tom Giblin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.15, 8.0.12 OS:Windows (Server 2019 Ver 1607 Build 14393.2724)
Assigned to: CPU Architecture:x86 (Xeon E3-1240 v3)
Tags: access denied, strong encryption authentication

[15 Feb 2019 18:19] Tom Giblin 
Description:
I configured MySQL version 8.0.12 with Strong Encryption for the authentication method and, after the server is rebooted or the MySQL service restarts, web applications that query the database are denied access.  However, once root logs in via Workbench connections are accepted and all applications query the database normally.

I updated MySQL to 8.0.15 and the issue remained.  I then reconfigured the authentication method to Legacy and now after the MySQL service restarts connections are accepted normally.

How to repeat:
I was able to reproduce this issue on an identical server.

1.  Install MySQL 8.0.12 (or 8.0.15) and select Strong Encryption Authentication
2.  Setup a simple test database to test connections via a basic php script
3.  Manually restart the MySQL service or reboot the server
4.  Attempt to connect to the test database with the php script
5.  Connection fails
6.  Login via Workbench with root
7.  Rerun php script
8.  Connection successful

After reconfiguring MySQL to use Legacy authentication and manually restarting the MySQL service connections are accepted without requiring root to login to Workbench.
[19 Feb 2019 23:10] MySQL Verification Team 
Thank you for the bug report. I couldn't repeat this issue, could you please provide the error message printed in the your_host_name.err file regarding the failed connection. Thanks.
[20 Mar 2019 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".