我正在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.
推荐答案
在此之后可能会出现错误 无法创建数据文件夹(尝试指定数据的路径,例如,.., 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)
(注意:您可以定义系统环境变量的路径(搜索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
现在使用命令-> mysql -u root --skip-password 然后
mysql> ALTER USER'root'@'localhost'由'new_password'标识;
此命令设置root密码.
this command to set root password.
更多推荐
登录时发生mysql服务器8.0密钥环迁移错误
发布评论