I'm looking for someone to help with the following issue.. you must supply instructions on how to resolve the issue step by step.
I have the following issue when loading data onto a VM MS Server 2016:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
So I then try to edit the --secure-file-priv but cant access [mysqld]
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqld -u root -p
Enter password: ***********
mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
2021-05-18T03:17:01.485833Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\[login to view URL] (mysqld 8.0.25) starting as process 5800
2021-05-18T03:17:01.493527Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.
i'm very good with the mysql related jobs and think can finish this within a day or two easily. as you mention this should be little debug but can found it easy