MySQL Forums
Forum List  »  Security

Re: Invalid --keyring-migration-source option.
Posted by: Harin Vadodaria
Date: March 04, 2019 10:57PM

Hi,

The last 3 commands executed by you try to invoke MySQL server(mysqld) and not MySQL client tool - mysql.

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysqld flush privileges

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysqld ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWpassword';

C:\Program Files\MySQL\MySQL Server 8.0.15\bin>mysqld -u root -p

The last statement kicks in keyring migration mode of MySQL server.
See: https://dev.mysql.com/doc/mysql-security-excerpt/8.0/en/keyring-key-migration.html

If you intend to reset password, i would suggest you to follow
https://dev.mysql.com/doc/mysql-windows-excerpt/8.0/en/resetting-permissions-windows.html
OR
Execute above mentioned statement using MySQL client tool - mysql rather than mysqld which is server binary.

HTH.

Best Regards,
- Harin

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Invalid --keyring-migration-source option.
4301
March 04, 2019 10:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.