Topic : Can't log in MYSQL server from CMD, Windows 10 - keyring-migration-source

Posted By: dashboardcreator on September 20, 2021, 10:56 pm

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.

Posted By: dashboardcreator on September 20, 2021, 10:58 pm | Post: 1
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.

Posted By: dashboardcreator on September 21, 2021, 12:58 am | Post: 2
Ignore this, I figured it out, didn't notice I was using mysqld instead of the mysql.exe.


Powered By AEF 1.0.8 © 2007-2008 Electron Inc.