Can not perform keyring migration error in MySQL causing trouble? We have a solution. 

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped out a customer who can not perform keyring migration error in MySQL.

How to resolve can not perform keyring migration error in MySQL

Some of our customers have recently been experiencing the following error after changing the InnoDB size.

mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
2021-12-23T17:04:56.896373Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2021-12-23T17:04:56.899407Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.23) starting as process 940

2021-12-23T17:04:56.906739Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.

2021-12-23T17:04:56.929282Z 0 [ERROR] [MY-010119] [Server] Aborting

2021-12-23T17:04:56.929477Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.

According to our Support Team, this error is visible when we attempt to start the MySQL server with the following command:

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld -uroot -p

Fortunately, our Support Techs have come up with an easy way to resolve this issue. All we need to do is follow these steps and we can stay clear of the error message:

1. First, we have to uninstall MySQL 8.0 Server via the installer tool.
2. Next, we will ensure all the data has been moved or deleted.
3. Then we have to reinstall MySQL 8.0 with the same settings as before.
4. After that, we have to stop the server and edit the my.ini file.
5. Next, we will restart the server and ensure the my.ini file is not in any other format other than ANSI/ASCII.
6. Finally, the MySQL server will successfully start and allow the end-user to successfully connect and replicate.

[Looking for a solution to another query? We are just a click away.]

Conclusion

To conclude, the skilled Support Engineers at Bobcares demonstrated how to deal with the error in MySQL.