C# mysql 链接 遇到 异常 Authentication with old password no longer supported, use 4.1 style passwords.
来源:互联网 发布:word2003软件 编辑:程序博客网 时间:2024/06/07 04:05
C# mysql 链接 遇到 异常 Authentication with old password no longer supported, use 4.1 style passwords.
用最新版的 mysql connector 去链接 远程的mysql服务器.
遇到 异常 Authentication with old password no longer supported, use 4.1 style passwords.
上网搜, 官方说是服务器的密码版本新, 客户端的版本太低, 连不上. 要更新我的客户端. 但是我的connector 是刚从官方下载的最新的啊. 这不科学啊.
还有人说是去服务器上服务器上的密码存储方式 改成旧版本,这样就可以了. 但是服务器不是我的, 我没有权限去改服务器的配置.
最后发现 一个帖子http://stackoverflow.com/questions/13706463/authentication-method-mysql-old-password-not-supported
里面说 MysqL Connector/NET 6.6.x (as of 6.6.2) dropped support for old password style authentication (it was deprecated due to being insecure and there were documented ways to attack it).
其实就是说 .net的connector 已经抛弃了旧的密码方式, 只支持新的密码方式. 突然明白了. 应该是客户端的密码认证方式太新, 而服务器的密码是旧的方式存储的.
所以就要去把服务器的密码存储方式改成新的. 怎么改呢. 找到这个地址 http://writecodepeople.blogspot.com/2013/03/mysql-41-style-password.html
在服务器端只提供了phpmyadmin, 没有console啊. 我记得有个地方可以执行sql语句
于是去服务器上打开phpmyadmin. 打开数据库. 打开Sql tab, 这里可以执行 sql语句.哈哈
执行这两句:
SET old_passwords=FALSE;
SET PASSWORD = PASSWORD(‘重设密码’);
之后, 在用c# connector 去连. 成功.
reffer: http://byNeil.com
- C# mysql 链接 遇到 异常 Authentication with old password no longer supported, use 4.1 style passwords.
- C# mysql 链接 遇到 异常 Authentication with old password no longer supported, use 4.1 style passwords.
- Mysql: Authentication with old password no longer supported, use 4.1 style password
- Python连接mysql提示old (insecure) passwords is not supported
- Python连接mysql提示old (insecure) passwords is not supported
- MySQL 4.1+ using old authentication
- Restrict Users to Use Old Passwords
- 关于ERROR: 'rake/rdoctask' is obsolete and no longer supported. Use 'rdoc/task' (available in RDoc
- Non-convex MeshCollider with non-kinematic Rigidbody is no longer supported in Unity 5.
- TortoiseGit disconnected no supported authentication
- TortoiseGit disconnected no supported authentication
- xvim garbage collection is no longer supported
- garbage collection is no longer supported
- How to use passwords securely with wget
- 关于javamail-with-ms-exchange-no-authentication-mechansims-supported-by-both-server错误的解决办法
- mysqlnd cannot connect to MySQL 4.1+ using old authentication
- PuTTY error: "No supported authentication methods available"
- TortoiseGit Disconnected: No supported authentication methods available
- 线程和fork
- C++模板实现的单向链表
- MySQL导入乱码解决
- Linux下重置MySQL的Root帐号密码
- ZendStudio9之SVN项目代码提示丢失解决
- C# mysql 链接 遇到 异常 Authentication with old password no longer supported, use 4.1 style passwords.
- 阿里云Linux服务器挂载硬盘分区
- 工作计划
- tar命令结合find搜索将指定条件的文件进行打包压缩
- sql
- Linux下常用的压缩与解压命令
- JVM系列文章(2):MethodHandler的特殊性
- PHP设置session多级路径并定期自动清理
- poj 3067 Japan(树状数组,注意题目向树状数组的转换)