necmfk.exe 引起的C8051 USB Debug adapter 连接失败的解决过程.

通过使用Microsoft的ProcessExplorer程序定位冲突程序necmfk.exe,并终止其进程,成功解决了USBDebugadapter烧录连接失败的问题。该程序帮助用户在机器中查找所有打开设备的进程,并显示每个进程已打开的目录、文件、注册表键等。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

现象: 

     USB Debug adapter  用flash utility 烧录连接失败,返回Cannot Connect to the Selected USB Debug Adapter / ToolStick Base Adapter Error的错误.使用USB Debug Adapter Firmware Reset 也无法update.而在另一台电脑上完全正常.

    官方解决办法:  http://community.silabs.com/t5/Silicon-Labs-Knowledge-Base/Troubleshooting-Cannot-Connect-to-the-Selected-USB-Debug-Adapter/ta-p/114057


    我按以下办法成功找到冲突程序 necmfk.exe,并终止其进程,成功解决连不上的问题

Run Microsoft’s Process Explorer program to locate processes with open handles to devices


1.      Download and extract Process Explorer from:
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx


2.      Run Process Explorer.  Process Explorer lists all processes running on your machine and lists what handles each process has opened, including directories, files, registry keys, etc.


3.      Open the Lower Pane by pressing Ctrl+L to dispaly active handles for the selected process.


4.      Open the Process Explorer Search dialog by pressing Ctrl+F


5.      Search for “\Device\0” to list all processes with open handles to a device.  The search results will include applications connected to many types of devices including sound cards as well as Human Interface Devices, such as the debug adapter.
processexplorer.png


6.      Many programs connect to devices through standard Windows processes such as svchost.exe and csrss.exe.  Clicking on each search result will highlight the process in the process tree in the main application.  This will tell you which program has spawned the instance of the standard Windows process.

 



8.      Use the search results to get a list of all programs that have open handles to devices and check to see if any of the programs is connected to the debug adapter.
Tip: This program can also be used to determine which program has locked a file and is preventing it from being deleted.  Just search for the file or folder name.


    

mysql忘记密码如何重置Microsoft Windows [版本 10.0.26100.3476] (c) Microsoft Corporation。保留所有权利。 C:\Windows\System32>mysql -u root ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) C:\Windows\System32> mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.36 MySQL Community Server - GPL Copyright (c) 2000, 2024, Oracle and/or its affiliates. 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> set password=password('12345') -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password('12345')' at line 1 mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PASSWORD('123456')' at line 1 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement mysql> select user,password,host from user; ERROR 1046 (3D000): No database selected mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '12345'; ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement mysql>
最新发布
03-25
<think>好的,我现在需要帮助用户解决在Windows 10上重置MySQL 8.0.36的root密码时遇到的问题。用户提到了使用--skip-grant-tables选项后出现的错误以及SQL语法的问题。让我先整理一下已有的信息和引用内容。 首先,引用[2]提到用户第一次修改密码时遇到错误,提示服务器运行在--skip-grant-tables模式下,无法执行语句。这说明用户可能是在该模式下尝试修改密码,但没有正确执行后续步骤。引用[4]指出,使用--skip-grant-tables启动MySQL后,服务器不读取权限表,所有用户都可以登录并修改数据,包括密码。但需要注意,修改密码后必须重新加载权限或重启服务器,否则更改不会生效。 接下来,用户提到SQL语法错误,引用[5]中的例子显示用户可能使用了旧版本的密码字段,比如password,而MySQL 5.7之后已经改为authentication_string,这在引用[3]中有说明。因此,正确的SQL语句应该是更新authentication_string字段,并且可能需要使用ALTER USER语句,特别是在MySQL 8.0中。 现在,我需要将这些信息整合成一个正确的步骤流程。首先,用户需要以--skip-grant-tables启动MySQL,这样可以绕过权限检查。然后连接到服务器,执行正确的SQL语句来更新密码。这里需要注意,MySQL 8.0可能要求先清空authentication_string,然后退出skip模式,再正常启动并使用ALTER USER设置密码。此外,修改密码后要刷新权限或重启服务以确保更改生效。 可能的步骤包括: 1. 停止MySQL服务。 2. 使用--skip-grant-tables和--shared-memory(因为Windows可能需要这个选项)启动MySQL。 3. 连接到MySQL,清空root的authentication_string。 4. 停止并正常启动MySQL服务。 5. 使用ALTER USER重置密码。 6. 处理过程中可能出现的语法错误,比如确保使用正确的字段名和语句结构。 需要确认用户是否正确地使用了这些步骤,并检查是否有步骤遗漏,比如在修改密码后没有刷新权限或重启服务。此外,还要注意在MySQL 8.0中,密码管理可能更严格,可能需要先设置空密码,然后再设置新密码。 最后,用户可能在执行UPDATE语句时使用了错误的语法,比如忘记添加WHERE条件,或者没有正确引用用户名。需要指导用户正确编写SQL语句,并确保在修改后执行FLUSH PRIVILEGES,或者在重启服务后使用ALTER USER,这样更符合MySQL 8.0的最佳实践。</think>### 分步重置MySQL 8.0.36密码指南(Windows 10) 1. **停止MySQL服务** ```bash net stop mysql ``` 如果服务名称不同,需替换`mysql`为实际服务名(如`mysql80`) 2. **以无权限验证模式启动** ```bash mysqld --console --skip-grant-tables --shared-memory ``` 保持此窗口运行,新开管理员CMD窗口继续操作[^4] 3. **清空root密码(临时)** ```sql UPDATE mysql.user SET authentication_string = '' WHERE user = 'root'; FLUSH PRIVILEGES; ``` *注意:MySQL 8.0必须使用`authentication_string`字段[^3]* 4. **重启MySQL服务** ```bash net stop mysql net start mysql ``` 5. **设置新密码** ```sql ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword123!'; ``` ### 常见错误处理 1. **语法错误示例** ```sql UPDATE user SET password=password('123') WHERE user='root'; -- 错误写法 ``` *正确写法* ```sql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_pass'; ``` 2. **--skip-grant-tables模式下无法修改密码** - 必须先清空密码字段 - 退出该模式后才能正常设置密码[^2][^4] 3. **密码策略问题** ```sql SHOW VARIABLES LIKE 'validate_password%'; -- 查看密码策略 SET GLOBAL validate_password.policy = 0; -- 临时降低策略强度 ``` ### 验证流程图 ```mermaid graph TD A[停止服务] --> B[跳过权限启动] B --> C[清空密码字段] C --> D[重启服务] D --> E[设置新密码] E --> F[验证登录] ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值