登录时发生mysql服务器8.0密钥环迁移错误 [英] mysql server 8.0 keyring migration error at login

问题描述

我正在Windows 10上使用MySQL Server 8.0.我遵循了本教程进行初始化. C:\Program Files\MySQL\MySQL Server 8.0\bin λ mysqld --initialize

I am using MySQL Server 8.0 on Windows 10. I followed this tutorial to initialize. C:\Program Files\MySQL\MySQL Server 8.0\bin λ mysqld --initialize

但是，当我尝试使用临时密码登录时，出现如下所示的密钥环迁移错误: 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. 2018-07-20T18:49:20.794197Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 21312 2018-07-20T18:49:20.801815Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed. 2018-07-20T18:49:20.824651Z 0 [ERROR] [MY-010119] [Server] Aborting 2018-07-20T18:49:20.829415Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.

However, when I try to login with the temporary password, a keyring migration error shows up as below: 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. 2018-07-20T18:49:20.794197Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 21312 2018-07-20T18:49:20.801815Z 0 [ERROR] [MY-011084] [Server] Keyring migration failed. 2018-07-20T18:49:20.824651Z 0 [ERROR] [MY-010119] [Server] Aborting 2018-07-20T18:49:20.829415Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.

我自己没有安装任何与钥匙圈相关的插件.有没有办法跳过或通过此密匙环迁移?提前致谢.

I did not install any plugins relating to keyring by myself. Is there a way to skip or pass this keyring migration? Thanks in advance.

推荐答案

1. 在Windows上安装后--->检查要安装的文件夹的路径.例如，C:\ Program Files \ MySQL \ MySQL Server 8.0 \ bin
2. 打开cmd-> cd转到路径上方
3. 键入 mysqld --initialize-insecure --console (它将手动初始化数据文件夹，而无需输入root密码).对于初学者，我建议使用此选项 mysqld --initialize --console (它将使用随机密码手动初始化数据文件夹为root)

1. After Installation on windows---> check path-to-installed folder..eg.,C:\Program Files\MySQL\MySQL Server 8.0\bin
2. open cmd-->cd go to above path
3. type mysqld --initialize-insecure --console (it will initialize the data folder manually without password to root). For beginners i would suggest this option mysqld --initialize --console(it will initialize the data folder manually with random password to root)

在此之后可能会出现错误 无法创建数据文件夹(尝试指定数据的路径，例如，..， mysqld --initialize-insecure --basedir =指定您的路径/mysql/mysql --datadir =指定您的路径/mysql/数据)

After this there could be error about unable to create data folder(try specifying the path to data like this eg..,mysqld --initialize-insecure --basedir=specify your path/mysql/mysql --datadir=specify your path/mysql/data)

或数据文件夹已存在(去那里删除数据文件夹.)

or data folder already exist(Go there and delete the data folder.)

或对于数据文件夹中的更高版本，已经存在一个名为 my.ini 的文件，将其复制并粘贴到C:\ Program Files \ MySQL \ MySQL Server 8.0(您可以执行更多操作在此处进行更改，并指定数据和基本目录的路径)

or for now later versions in data folder there is already a file exist named my.ini copy it and paste it to C:\Program Files\MySQL\MySQL Server 8.0(you could do more changes here and specify the path to data and base dir)

1. 现在，您无需任何密码即可成功初始化.启动服务器. mysqld --console

1. Now you have successfully initialized without any password. Start the server. mysqld --console

(注意:您可以定义系统环境变量的路径(搜索google的方法)，此后不必每次都使用此路径) 现在您的服务器已启动并正在运行.

(NOTE: you could define the path to system environment variable(search google how to do it), after that you do not have to go this path every time) now your server up and running.

mysqld:准备连接 版本:'8.0.15'套接字:''端口:3306

mysqld: ready for connections Version: '8.0.15' socket: '' port: 3306

1. 现在使用命令-> mysql -u root --skip-password 然后

mysql> ALTER USER'root'@'localhost'由'new_password'标识；

此命令设置root密码.

this command to set root password.

1. 下次使用 mysql -u root -p ，然后输入new_password

1. next time use mysql -u root -p and after that enter you new_password

这篇关于登录时发生mysql服务器8.0密钥环迁移错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！