1、解压将文件放在自己指定的目录(我放在了D:\code\environment\mysql\),之后右键左下角窗口图标启动管理员模式的powershell,进入你放mysql文件的目录,或者直接将msyql的bin文件夹配置到环境变量里去。主要用到bin里的文件。
2、在根目录下配置my.ini文件,我是在网上抄的
3、mysql服务安装,成功会有Service successfully installed提示,
Windows PowerShell
PS D:\code\environment\mysql\mysql-8.0.15-winx64>mysqld install
Service successfully installed.
4、初始化,第二行最后(root@localhost:之后)的乱码是临时密码,之后要用
PS D:\code\environment\mysql\mysql-8.0.15-winx64>mysqld --initialize
2020-02-20T08:57:41.938171Z 0 [System] [MY-013169] [Server] D:\code\environment\mysql\mysql-8.0.15-winx64\bin\mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 4060
2020-02-20T08:57:45.318546Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: #l:mATuai2ie
2020-02-20T08:57:46.594624Z 0 [System] [MY-013170] [Server] D:\code\environment\mysql\mysql-8.0.15-winx64\bin\mysqld.exe (mysqld 8.0.15) initializing of server has completed
5、启动服务
PS D:\code\environment\mysql\mysql-8.0.15-winx64>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
6、登录,ctrl+c拷贝上面说那串乱码,输密码时右键粘贴即可
PS D:\code\environment\mysql\mysql-8.0.15-winx64>mysql -uroot -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.15
Copyright (c) 2000, 2019, 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>
7、改密码
mysql>alter user 'root'@'localhost' identified with mysql_native_password by '12345'
8、可能出现的问题
第4步初始化时出错:
PS D:\code\environment\mysql\mysql-8.0.15-winx64>mysqld --initialize --console
2020-02-20T08:57:07.671252Z 0 [System] [MY-013169] [Server] D:\code\environment\mysql\mysql-8.0.15-winx64\bin\mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 1484
2020-02-20T08:57:07.675506Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2020-02-20T08:57:07.675529Z 0 [ERROR] [MY-013236] [Server] Newly created data directory D:\code\environment\mysql\mysql-8.0.15-winx64\data\ is unusable. You can safely remove it.
2020-02-20T08:57:07.688504Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-02-20T08:57:07.688598Z 0 [System] [MY-010910] [Server] D:\code\environment\mysql\mysql-8.0.15-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
把根目录下的data文件删了再来一次,也可能是my.ini文件里有错误,路径要配置正确。
个人总结