这里是我的整个过程:
红色为输入的关键命令 或者 出现的关键信息
蓝色为提示
//首先把data中的东西全部删光
Microsoft Windows [版本 10.0.17134.191]
(c) 2018 Microsoft Corporation。保留所有权利。
C:\WINDOWS\system32>e:
E:\>cd E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin // 进入安装的\bin中
E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin>mysqld --install
The service already exists!
The current server installed: E:\软件安装专用\MySQL-8.0.11\mysql-8.0.11-winx64\bin\mysqld MySQL
E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin>mysqld --remove
Service successfully removed.
E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin>mysqld --install
Service successfully installed.
E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin>mysqld --initialize --user=root --console
2018-07-29T15:32:52.296839Z 0 [System] [MY-013169] [Server] E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 5308
2018-07-29T15:33:12.692369Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: AI-F1t3lhkzv // 初始化的密码千万记住,下面改密码要用
2018-07-29T15:33:44.591347Z 0 [System] [MY-013170] [Server] E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed
E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin>net start mysql
MySQL 服务正在启动 ...
MySQL 服务已经启动成功。//恭喜你,出现这个就是算已经好了
E:\SotfwareInstall\MySQL-8.0.11\mysql-8.0.11-winx64\bin>mysql -uroot -p
Enter password: ************ // 输入初始化的密码,登陆
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.11
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
这里的root就是我改的密码,大家随意,啥都行,只要不忘,最好设置个简单的
Query OK, 0 rows affected (1.17 sec)
mysql> //问题解决完毕