blocks|key|1421288|text|我也有同样的问题，我已经在安装程序中安装了MySQL的默认版本。我最近更新了我的硬件并重新安装了Windows+10，也许它是Windows+20H2或Workbench本身的一个bug？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1421289|我找到了一个解决办法:使用CMD或Powershell启动或停止服务器的MySQL。在我的例子中，它的名字是MySQL80。当下面的命令不起作用时，请查看您的windows服务。|1421290|使用net+start+MySQL80启动服务器。使用net+stop+MySQL80来停止服务器。|offset|length|style|BOLD|1421291|记得以管理员的身份打开CMD或Powershell。我认为这个问题是工作台本身的一个缺陷，因为使用命令行服务是可以启动和停止的。|1421292|entityMap^0|0|0|2|H|R|G|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]|$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

I have the same issue and I've installed the developers default version of the MySQL-Workbench with the installer. I recently updated my hardware and reinstalled Windows 10, maybe it's a bug of Windows 20H2 or of the Workbench itself?
I found a workaround: Use the CMD or the Powershell to start or stop the MySQL-Service of the server. In my case, it has the name MySQL80. Take a look in your services of windows when the commands below are not working.
Use net start MySQL80 to start the server.
Use net stop MySQL80 to stop the server.
Remember to open the CMD or the Powershell as Administrator. I think this issue is a bug of the workbench itself because the service is start and stopable with the command line.

blocks|key|1971024|text|我解决了这个问题如下。目前，my.ini文件编码是UTF-8.你必须换乘ANSI。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1971025|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I solved this problem as follows. currently my.ini file encoding is UTF-8. you must change to ANSI.

blocks|key|1971037|text|首先要尝试的是从mysqld+--console服务器bin文件夹中运行MySQL。这将为您提供更具体的错误消息。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1971038|在我的例子中，数据文件夹丢失了。我需要运行一个mysqld+--initialize...命令；参见https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html。在Windows上，运行mysqld+--initialize...+--console有助于查看服务器正在做什么。|1971039|一旦完成，您可以再次运行mysqld+--console，以查看它是否成功启动。|1971040|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html^0|8|G|0|N|M|3T|W|1E|22|0|0|C|G|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|H|3|I|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

The first thing to try is to run <code>mysqld --console</code> from the MySQL server bin folder. That should give you more specific error messages.
In my case, the data folder was missing. I needed to run one of the <code>mysqld --initialize...</code> commands; see <a href="https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html</a>. On Windows, running <code>mysqld --initialize... --console</code> helps to see what server is doing.
Once that's done, you can run <code>mysqld --console</code> again to see if it starts successfully.

blocks|key|2810243|text|在我的例子中，我用这种方法解决了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2810244|转到RUN|2810245|希望这样的问题能解决。|2810246|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

in my case I had solve this way
Go to RUN-----&gt;Services.msc-----&gt;MYSQL80----&gt;start server
hope this way problem will solved.

blocks|key|2810255|text|在我的Windows安装中，服务运行的帐户对不存在的数据目录没有(安全)权限。在创建了数据目录"Program+\MySQL\mySQLServer8.0\+data“并设置权限之后，所有操作都与"net+mysql80”一起工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2810256|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

On my Windows installation the account the service runs under did not have (security) permissions to the non-existing data directory. After creating the data directory which was &quot;Program Files\MySQL\MySQL Server 8.0\data&quot; and setting permissions everything worked with a &quot;net start mysql80&quot;.

blocks|key|2810382|text|下面是我为解决MySQL工作台8.0.23问题而采取的步骤，这些步骤导致无法从MySQL工作台启动和停止MySQL服务器进程(mysqld)+(O/S=).|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2810383|C:\Users\AppData\Roaming\MySQL\Workbench\serverinstances.xml:|2810384|Replaced：|unordered-list-item|2810385|Close+MySQL+Workbench|2810386|In+|2810387|sc+start+MySQL80|2810388|sc+stop+MySQL80|2810389|2810390|2810391|MySQL80+|2810392|With：|2810393|net+start+MySQL80|2810394|net+stop|2810395|2810396|2810397|commands注释：|2810398|备注：|2810399|+mysqld服务已安装w/名称=‘mysqld+80’，将此值替换/匹配为您的实际服务名称。|2810400|--使用‘网络服务’帐户安装了mysqld服务，在使用'net‘之前，验证您的服务也作为网络服务运行。|2810401|2810402|2810403|启动和停止服务运行为administrator:|2810404|In文件资源管理器的命令，以便找到MySQLWorkbench.exe可执行文件:例如:+C:\Program+\MySQL\MySQL工作台8.0\MySQLWorkbench.exe|2810405|In文件资源管理器，选择exe，右键单击exe，选择'Properties'，选择“兼容性”选项卡:指定“将此程序运行为Administrator'|2810406|Start+MySQL+Workbench|ordered-list-item|2810407|Attempt以启动或停止MySql服务器进程(mysqld)|2810408|”|2810409|2810410|specific|2810411|MySQL和MySQL工作台通过MySQL+CE+8.0.23+installer|2810412|
|2810413|Installed+MySQL+8.0.23安装，从5.7升级到8.0.23|2810414|
。|2810415|entityMap^0|0|0|0|0|2|2|2|0|0|0|1|1|1|0|0|0|1|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|20|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|21|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|22|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|23|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|24|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|25|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|26|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|28|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|29|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|2A|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|2B|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|2C|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|2F|8|@]|9|@]|A|$]]|$1|12|3|13|5|F|7|2G|8|@]|9|@]|A|$]]|$1|14|3|15|5|F|7|2H|8|@]|9|@]|A|$]]|$1|16|3|17|5|F|7|2I|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|2J|8|@]|9|@]|A|$]]|$1|19|3|-4|5|6|7|2K|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2L|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|F|7|2M|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|F|7|2N|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|1I|7|2O|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|F|7|2P|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|1N|3|13|5|6|7|2R|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|6|7|2S|8|@]|9|@]|A|$]]|$1|1Q|3|1R|5|F|7|2T|8|@]|9|@]|A|$]]|$1|1S|3|1T|5|6|7|2U|8|@]|9|@]|A|$]]|$1|1U|3|1V|5|F|7|2V|8|@]|9|@]|A|$]]|$1|1W|3|1X|5|6|7|2W|8|@]|9|@]|A|$]]|$1|1Y|3|-4|5|6|7|2X|8|@]|9|@]|A|$]]]|1Z|$]]

Here are the steps I took to resolve my MySQL Workbench 8.0.23 issue
that resulted in an inability to start &amp; stop the MySQL server process (mysqld)
from MySQL Workbench (O/S=Windows only answer)...
<ol>
<li>Close MySQL Workbench</li>
<li>In C:\Users&lt;Your account&gt;\AppData\Roaming\MySQL\Workbench\serverinstances.xml:</li>
</ol>
<ul>
<li>Replaced:
<ul>
<li>sc start MySQL80</li>
<li>sc stop MySQL80</li>
</ul>
</li>
<li>With:
<ul>
<li>net start MySQL80</li>
<li>net stop MySQL80</li>
</ul>
</li>
<li>Notes:
<ul>
<li>My mysqld service was installed w/ the name='MySQL80', replace/match this value to your actual service name.</li>
<li>My mysqld service was installed using a 'Network Service' account, verify that your service is also running as a network service before using the 'net' commands</li>
</ul>
</li>
</ul>
<ol start="3">
<li>Setup MySQLWorkbench CE 8.0 executable to 'Run As Administrator' so that the commands to start and stop the service run as an administrator:</li>
</ol>
<ul>
<li>In File Explorer find the MySQLWorkbench.exe executable:
E.g: C:\Program Files\MySQL\MySQL Workbench 8.0\MySQLWorkbench.exe</li>
<li>In File Explorer, Select the exe, Right click on the exe, select 'Properties', select
'Compatibility' tab: specify 'Run This Program As An Administrator'</li>
</ul>
<ol start="4">
<li>Start MySQL Workbench</li>
</ol>
<ul>
<li>Attempt to start or stop the MySql server process (mysqld)</li>
</ul>
Notes:
<ul>
<li>O/S = Windows 10 specific</li>
<li>MySQL &amp; MySQL Workbench were installed via the MySQL CE 8.0.23 installer</li>
<li>Installed MySQL 8.0.23 as an upgrade from 5.7 to 8.0.23</li>
</ul>

blocks|key|2810457|text|我做了很多建议，但都没有用。除了这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2810458|2810459|下载并运行最新的MySQL安装程序。将出现一个窗口，显示已安装的服务：|ordered-list-item|2810460|2810461|-+MySQL+Server
-+MySQL+Workbench
-+MySQL+Shell
-+etc.|code-block|syntax|javascript|2810462|2810463|在MySQL服务器上单击“重新配置”并像以前一样设置服务器。|2810464|2810465|我的具体服务器设置是：|2810466|2810467|类型和网络:保留为默认的|2810468|2810469|2810470|Authentication方法：(RECCOMENDED)|2810471|2810472|2810473|帐户和角色:输入并检查mysql密码|2810474|2810475|2810476|Windows服务:取消“配置为服务”|2810477|2810478|2810479|应用配置:执行|2810480|2810481|服务器应该已经启动并运行。|2810482|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1H|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|1J|8|@]|9|@]|A|$J|K]]|$1|L|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|M|3|N|5|E|7|1L|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1N|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|S|3|T|5|E|7|1P|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|W|3|X|5|E|7|1S|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|10|3|11|5|E|7|1V|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|14|3|15|5|E|7|1Y|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|18|3|19|5|E|7|21|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|1B|3|1C|5|6|7|23|8|@]|9|@]|A|$]]|$1|1D|3|-4|5|6|7|24|8|@]|9|@]|A|$]]]|1E|$]]

I've done numerous suggestions and none work. Except this one:
<ol>
<li>Download and run the latest MySQL Installer.
A window will appear showing your installed services:
<ul>
<li>MySQL Server</li>
<li>MySQL Workbench</li>
<li>MySQL Shell</li>
<li>etc.</li>
</ul>
</li>
<li>Click &quot;reconfigure&quot; on the MySQL Server and set up the server as you did previously.
</li>
</ol>
My specific server setup was:
<ol>
<li>Type and Networking: leave as default
</li>
<li>Authentication Method: (RECCOMENDED)
</li>
<li>Accounts and Roles: Enter and check mysql password
</li>
<li>Windows Service: Uncheck 'configure as a service'
</li>
<li>Apply configuration: Execute
</li>
</ol>
Server should be up and running.

blocks|key|1421617|text|如果在从Workbench启动/连接服务器时出现此错误，则需要启动->MYsql工作台安装单击。使用端口号打开并重新配置MySQL服务器，并创建根用户密码。完成重新配置，然后打开工作台。提供端口号和凭据并连接到DB。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1421618|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If this error while starting/connecting the server from Workbench then you need to Go Start-&gt;MYsql workbench Installation Click.
Open and reconfigure the MySQL server with port number and Create Root user Password.
Finish this Re-configuration then open workbench. Provide the Port number and Credentials and connect to DB.

blocks|key|1971365|text|在窗口中，可以使用任务管理器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1971366|1971367|只需通过搜索窗口中的“任务管理器”打开任务管理器，|ordered-list-item|1971368|转到服务并查找Mysql+(根据首次初始化mysql服务器时保存的名称)|1971369|右键单击它并单击开始启动服务器或停止停止服务器|1971370|。|1971371|📷|atomic|offset|length|1971372|​|1971373|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/e1b802c73178d171548519346ebcc2cf.png|imageAlt^0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|13|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|17|8|@]|9|@$O|18|P|19|1|1A]]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]]]

In window you may use task manager
<ol>
<li>just open task manager by search &quot;task manager&quot; in window search</li>
<li>Go to service and find Mysql (name depending on the name saved when initializing mysql server at first time)</li>
<li>Right click it and click start to start server or stop to stop server
<a href="https://i.stack.imgur.com/9uIP5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9uIP5.png" alt="Window task manager" /></a></li>
</ol>

I just installed MySQL using the community installer in hopes of running a server and creating a database for use in my C++ program. I installed the Server, Workbench, Shell, Router, and Connector/C++ before running the Workbench. Everything appeared to be working properly. The server was running and I was able to connect to it in my C++ program, so I started to create my database, when the power suddenly went out before I could finish.
Once the power came back on and my PC rebooted, I reopened the MySQL Workbench to find that I was unable to start the server. I clicked the 'Start Server' button several times, but was met with the error &quot;Could not start server: argument 2: &lt;class 'TypeError'&gt;: wrong type&quot;.
I tried uninstalling and reinstalling everything, but when I reopened the MySQL Workbench after the installation was finished, I was met with the same error. Does anyone know what could have possibly happened?
EDIT: After uninstalling everything and deleting every trace of MySQL from my computer, I was able to reinstall everything and get the server running again. However now I'm getting the same error when I try to STOP the server: &quot;Could not stop server: argument 2: &lt;class 'TypeError'&gt;: wrong type&quot;. What is going on????

Trying to Start MySQL Server and Getting "Could not start server: argument 2: <class 'TypeError'>: wrong type"

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我只是使用社区安装程序安装了MySQL，希望能够运行服务器，并创建一个数据库供我的C++程序使用。在运行工作台之前，我安装了Server、Workbench、Shell、路由器和Connector/C++。一切似乎都很正常。服务器正在运行，我能够在我的C++程序中连接到它，所以我开始创建我的数据库，当我还没完成电源就突...

问尝试启动MySQL服务器并获得“无法启动服务器:参数2：<class 'TypeError'>：错误类型”
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问尝试启动MySQL服务器并获得“无法启动服务器:参数2：<class 'TypeError'>：错误类型”EN