MySQL Bugs: #95951: Not accepting valid password

Bug #95951	Not accepting valid password
Submitted:	24 Jun 2019 13:47	Modified:	1 Aug 2019 23:59
Reporter:	Anand G	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.16	OS:	Windows (Microsoft Windows 10 Home)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Anand\AppData\Roaming\MySQL\Workbench\log\wb.log]

I am a beginner and I have installed both SQL workbench and when I tried to create a new connection, I am not allowed. with errors 1. First with right password, I am sure and 2. wrong pass word. 

I see in the logs file " Resource file not found: folder" please can you help me

Note: Please see the attached logs

How to repeat:
1. Run the SQL workbench 
2. Try to open a new connection 
3. feed the password when prompted 
Note: Did not change any port numbers.

Error when provided with right password:
Failed to Connect to MySQL at 127.0.0.1:3306 with user root 
SELECT command denied to user 
'mysql.infoschema@localhost for column 'default_collation_id' in table 'character_sets'

When provided with wrong password, on prompt 
Failed to Connect to MySQL at 127.0.0.1:3306 with user root 
Access denied for user 'root@localhost' (using password: YES)

Suggested fix:
I see in the logs saying Resource file not found: folder, may be helpful message and guided resolution steps will help.

Error Log File

Attachment: wb.log (application/octet-stream, text), 8.26 KiB.

Error Log file 2

Attachment: wb.1.log (application/octet-stream, text), 13.18 KiB.

Screenshots from the SQL workbench

Attachment: screenshots.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 30.35 KiB.

Thank you for the bug report. Which server version are you trying to connect? Are you able to connect using the command client mysql.exe?. Thanks.

@Miguel Solorzano Thank you for the response.

I am very new and I think the version Server version is 8.0.16 and I tried configure server management tab, my password entered which was being accepted suddenly comes with following error

" Connecting to MySQL server ...
Access denied for user 'root'@'localhost' (using password: YES)
Connecting to MySQL server ...
SELECT command denied to user 'mysql.infoschema'@'localhost' for column 'default_collation_id' in table 'character_sets'"

2.Are you able to connect using the command client mysql.exe ? Please can you help me how to test this. 

Thank you in advance

Yes I am able to connect via MYSQL Shell 
 \connect root@localhost
Creating a session to 'root@localhost'
Please provide the password for 'root@localhost': *********
Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): Y
Fetching schema names for autocompletion... Press ^C to stop.
Error during auto-completion cache update: View 'information_schema.SCHEMATA' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Your MySQL connection id is 21 (X protocol)
Server version: 8.0.16 MySQL Community Server - GPL
No default schema selected; type \use <schema> to set one.

Please advise. The password, I have provided in root is accepted in shell.

Open a command prompt, go to install bin directory and perform the below command like I show with my install stuff?

c:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe -uroot -p
Enter password: **********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.16 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

@ Miguel Thank you for the response.

As advised, I have successfully run the command you have advised and result is same as suggested. 
Then I opened the SQL workbench, gave a name and tried to connect but I get same dialog box as previously "Failed to connect to MySQL at 127.0.0.1:3306 with user root. 

Please can you help
Thanks in Advance

That sounds as a server install issue, what kind of server install was done? an upgrade?.

No it was a fresh install first time on my system and it actually worked the same password of command prompt was accepted earlier for the workbench.

Please attach here (private if you wish) the log err file which generally is placed in the data directory it`s the file compound of machine_host_name.err i.e.? on my machine?

c:\ProgramData\MySQL\MySQL Server 8.0\Data>dir *.err
 Volume in drive C has no label.
 Volume Serial Number is 6005-E7EC

 Directory of c:\ProgramData\MySQL\MySQL Server 8.0\Data

07/01/2019  12:42 PM            12,858 URAL.err
               1 File(s)         12,858 bytes
               0 Dir(s)  84,316,876,800 bytes free

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".