安装MYSQL 社区版 mysql 8.0.30

poloyzhang

已于 2022-12-19 21:13:40 修改

阅读量603

点赞数

分类专栏： java/Android python 文章标签：数据库 mysql sql

于 2022-12-19 15:08:18 首次发布

本文链接：https://blog.csdn.net/poloyzhang/article/details/128372466

版权

python 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

java/Android

3 篇文章 0 订阅

订阅专栏

本文详细记录了在Windows上安装MySQL 8.0.30社区版过程中遇到的防火墙规则问题，包括添加Windows Firewall规则和解决连接错误。重点讲述了如何解决无权限启动服务的问题，最终成功安装并登录工作台。

摘要由CSDN通过智能技术生成

https://dev.mysql.com/downloads/

上面地址下载

安装社区版，选择开发者选项

mysql社区版 8.0.30，直接都下一步，下一步的安装

安装进度一直在显示

安装完成，下一步

开发者

输入密码：

增加用户 sa

又是一番执行

启动服务失败，看 log

Beginning configuration step: Updating Windows Firewall rules

Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
确定。

Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
确定。

Attempting to start service MySQL80...
Failed to start service MySQL80.
Waiting until a connection to MySQL Server 8.0.30 can be established (with a maximum of 10 attempts)...
Retry 1: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 2: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 3: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 4: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 5: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 6: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 7: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 8: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 9: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Waiting 5 seconds before the next connection attempt...
Retry 10: Attempting to connect to Mysql@localhost:3306 with user root with no password...
Unknown error: 发生一个或多个错误。
Failed to connect to MySQL Server 8.0.30 after 10 attempts.
Ended configuration step: Starting the server