mysqld登录账号报错mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.

一时失言乱红尘 2023-07-10 05:06 2阅读 0赞

mysql8以上使用mysqld登录root账号提示

[root@localhost init.d]# /usr/local/mysql-8.0.19/bin/mysqld -u root -p
    Enter password: 
    mysqld: Can not perform keyring migration : Invalid --keyring-migration-source option.
    2020-02-29T07:28:13.640742Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    2020-02-29T07:28:13.640881Z 0 [Warning] [MY-010143] [Server] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line
    2020-02-29T07:28:13.642506Z 0 [System] [MY-010116] [Server] /usr/local/mysql-8.0.19/bin/mysqld (mysqld 8.0.19) starting as process 3449
    2020-02-29T07:28:13.665008Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed.
    2020-02-29T07:28:13.665040Z 0 [ERROR] [MY-010119] [Server] Aborting
    2020-02-29T07:28:13.668990Z 0 [System] [MY-010910] [Server] /usr/local/mysql-8.0.19/bin/mysqld: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.

因为将加密方式设置为与mysql5一样了，所以需要使用mysql -u root -p进行登录即可  
扫一扫关注小编的公众号哦！  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200320200529969.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2V0aGFuX194dQ==,size_16,color_FFFFFF,t_70