MySQL Forums
Forum List  »  MySQL Workbench

[ERROR] Access denied for user 'root'@'localhost'
Posted by: Michael Boone
Date: September 27, 2018 02:46PM

I'm attempting a fresh install of mySQL and receive the above error when trying to connect to the discovered instance through Workbench. Any help would be highly appreciated since I've already spent the better part of 6 hours banging my head against a wall.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

OS: Windows Server 2016
mySQL: 8.0.12
Workbench: 8.0.12

Default options were used across the board other than setting the root password during installation. Only mySQL & Workbench were selected for install. The install completes clean.

From the command line these are the other errors I see:

--------------

c:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld.exe -u root -p
Enter password: ****************
mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
2018-09-27T20:28:31.314789Z 0 [System] [MY-010116] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.12) starting as process 4644
2018-09-27T20:28:31.327708Z 0 [Warning] [MY-010091] [Server] Can't create test file c:\Program Files\MySQL\MySQL Server 8.0\data\UMCV-REDCAP1.lower-test
2018-09-27T20:28:31.327935Z 0 [Warning] [MY-010091] [Server] Can't create test file c:\Program Files\MySQL\MySQL Server 8.0\data\UMCV-REDCAP1.lower-test
2018-09-27T20:28:31.329908Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.
2018-09-27T20:28:31.379330Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-09-27T20:28:31.386010Z 0 [System] [MY-010910] [Server] c:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.

c:\Program Files\MySQL\MySQL Server 8.0\bin>mysql.exe -u root -p
Enter password: ****************
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Options: ReplyQuote


Subject
Views
Written By
Posted
[ERROR] Access denied for user 'root'@'localhost'
192
September 27, 2018 02:46PM


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.