Can't log in MYSQL server from CMD, Windows 10 - keyring-migration-source, Windows 10 - keyring-migration-source error message (2 Replies, Read 703686 times)
Recently i needed to log into MYSQL from the command line to perform some database maintenance however when trying to login I received the following message below.
Note that I have created a new dev machine and experience the same issue. I have not changed the default password on the new machine but had on the first dev machine.
On the second dev machine I tried removing the data directory and recreating it with an initialize however nothing works. Please let me know what I'm doing wrong or how to fix this.
C:\Program Files\Ampps\mysql\bin>mysqld -u root -p
Enter password: ************
mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
2021-09-20T22:49:37.382014Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 3956
2021-09-20T22:49:37.386383Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.
2021-09-20T22:49:37.387421Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-09-20T22:49:37.387576Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
IP: --
Can't log in MYSQL server from CMD, Windows 10 - keyring-migration-source
I forgot to mention that MYSQL is working and running just fine. I can access it through PHPMYADMIN but no access through the command line with the error shown in initial posting.
IP: --
Can't log in MYSQL server from CMD, Windows 10 - keyring-migration-source