Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Remote  |  Calendar  |  Quick Links  |  
   


You are here: Index > AMPPS > Bugs > Topic : Can't log in MYSQL server from CMD, Windows 10 - keyring-migration-source



Threaded Mode | Print  

 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)
dashboardcreator
Posted on # September 20, 2021, 10:56 pm
Group: Member
Post Group: Newbie
Posts: 3
Status:
Hello,

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
dashboardcreator
Posted on # September 20, 2021, 10:58 pm | Post: 1
Group: Member
Post Group: Newbie
Posts: 3
Status:
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
dashboardcreator
Posted on # September 21, 2021, 12:58 am | Post: 2
Group: Member
Post Group: Newbie
Posts: 3
Status:
Ignore this, I figured it out, didn't notice I was using mysqld instead of the mysql.exe.

Thanks
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
2 guests, 0 users.


All times are GMT. The time now is June 3, 2023, 2:51 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.017