win10安装mysql-8.0.15-winx64

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文件里有错误,路径要配置正确。

个人总结

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值