MySQL Remote Connection Failed
仅提供English版本
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2022-05-10
git 推送发现远程仓库地址错误
问题:项目上传时总是首先上传一个错误的仓库地址然后才是当前仓库地址问题原因: 由于不懂git导致设置了git的globalconfig在全局设置中添加了默认路径，导致每次上传都会上传一次全局路径导致出现错误。 解决办法使用命令git remote -v 可以看到一直有一个origin存在，使用git remote rm origin 删除发现始终删除不掉这个路径调用命令git config --global --list，可以发现global的配置与local的配置中出现了两个origin的地址看来是我们在全局变量中设置了一个仓库地址，导致每次上传都会首先上传这个地址，所以需要将这个地址删除输入命令~/.gitconfig，在弹出的编辑器中将[remote 'origin']删除即可删除全部路径，再次上传即可按照本地当前remote地址上传
2020-11-04
WCF IIS配置并引用 并初步使用Mysql数据库
学习网址：https://docs.microsoft.com/zh-cn/dotnet/framework/wcf/how-to-create-a-wcf-client本地资源配置与IIS资源配置我是根据微软官网学习的，有兴趣的可以跟着敲一下，我这里只说一下我遇到的问题 IIS 再IIS中配置服务时，根据教程上创建虚拟目录，发现如果我如果再默认站点创建服务将会提示InvalidOperationException: 找不到类型“Microsoft.ServiceModel.Samples.CalculatorService,发现我再默认站点已经托管了一个服务导致的问题。应该是今天感冒有点迟钝新建站点：1.1. 将我们的路径端口及名称输入即可，和创建Web站点一个步骤。 创建文件APP_Code、service.svc、Web.config,其中Web.config文件按照官方给的案例后面将会出现无法打开安全通道，因为与远程终结点的安全协商已失败。这可能是由于用于创建通道的 EndpointAddress 中不存在 EndpointIdentity 或错误指定了 Endpoint...
2020-06-12
vs2019 Connect MySQL You have a usable connection already.
Found big shot solving vs2017 problem, found this is bug of mysql itself, need to install specific version of mysql-connect-net and mysql-connect-netSolution
2020-04-17
MySQL String Error in insert into Statement
When passing values, looking at C# code directly passing string value, error reported showing matching column not found 1command += "INSERT INTO " + TableName + "(data_id,data_desc,data_price) VALUES(" + ids[i] + ", " + description[i] + "," + price[i] + ");"+"\r\n"; After the running error, I found that I didn’t consider that the command is passed completely in string form. At this time, the string passed by description does not have...
2021-01-22
MySQL Lock Granularity and ACID
Table Lock: It locks the entire table. Before a user performs a write operation (insert, delete, update, etc.) on the table, they need to acquire a write lock first, which will block all read and write operations on the table by other users. When there is no write lock, other users can obtain read locks, and read locks between multiple users do not block each other.Row Lock: Row-level locks can support concurrent processing to the greatest extent (and also bring the largest lock overhead). AC...
2021-01-06
Mysql Function to Query All Child Nodes Based on Parent Node
The data volume is 5k+. Referring to the function given in the blog, it takes 15s to run once, which is too long. So finally I didn’t choose to traverse data in Mysql, but traversed in the class when the user selects the parent node. The overall time consumption will be much smaller, and it will not bring lag feeling to the user. I don’t use Mysql functions much usually, so I record it for future learning use. After the function is created in Mysql, it will prompt the error message This func...
