MYSQL(解決方法):Client does not support authentication(轉)
MYSQL(解決方法):Client does not support authentication(轉)[@more@]mysql4.1以上版本連線時出現Client does not support authentication protocol問題解決辦法shell> mysqlClient does not support authentication protocol requestedby server; consider upgrading MySQL client官方的說法是MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. .....如果你升級mysql到4.1以上版本後遇到以上問題,請先確定你的mysql client 是4.1或者更高版本.(WINDOWS下有問題你就直接跳到下面看解決方法了,因為MYSQL 在WINDOWS是client和server一起裝上了的)請使用以下兩種方法之一其一:mysql> SET PASSWORD FOR-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');其二:mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')-> WHERE Host = 'some_host' AND User = 'some_user';mysql> FLUSH PRIVILEGES;上面的部分請按自己實際情況修改....這樣做後,連線就會正常了@
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8225414/viewspace-942510/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Client does not support authentication protocol requested by server; consider upgrading MySQL clientclientProtocolServerIDEMySql
- navicat本地連線mysql出現1251--Client does not support authentication protocol requested by server的解決方法MySqlclientProtocolServer
- Navicat 遠端連線docker容器中的mysql 報錯1251 - Client does not support authentication protocol 解決辦法DockerMySqlclientProtocol
- mysql-proxy does not work with server/client authentication pluginsMySqlServerclientPlugin
- 關於Support for password authentication 報錯的解決方案
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解決方法MySql
- onnx模型轉openvino報錯nGraph does not support the following ONNX operations: If模型
- jstl c標籤 ”test does not support runtime expressions“JSExpress
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法
- The file '/MasterPage.master' does not exist. 類錯誤解決方法AST
- IBM x-346 "planar PCI does not respond or is disabled by user" 解決方法IBM
- The server does not support version 3.0 of the J2EE Web module specificationServerWeb
- Error: --recode does not support multipass recoding of very large files.Error
- 解決 Lumen 中 client charset is not supportedclient
- Variable 'character_set_client' can't be set to the value of Null的解決方法clientNull
- signer information does not match問題解決ORM
- mysql 5.1.28 無法載入innodb解決方法(轉自網路)MySql
- 關於Mysql 4.1語言問題的完美解決方法(轉)MySql
- cobbler出現httpd does not appear to be running and proxying cobbler的解決方法httpdAPP
- WCF The service cannot be activated because it does not support ASP.NET compatibilityASP.NET
- MYSQL亂碼問題解決方法MySql
- Linux 出現 su: Authentication failure 解決辦法LinuxAI
- ORA-24756: transaction does not exist問題解決
- `QtValidLicenseForCoreModule' does not name a type 錯誤的解決QTREM
- Your CPU does not support long mode.Use a 32bit distribution.
- PHP Mysql support: 是mysql 還是mysqlnd?PHPMySql
- Mysql忘記密碼解決方法凹MySql密碼
- MySQL提示Writing to net的解決方法MySql
- mysql與jsp亂碼解決方法MySqlJS
- 解決MYSQL工具mysqldump 遇到 Out of memory 方法MySql
- DP 6.1版本在linux Client上的問題解決方法Linuxclient
- CodeMan的Linux問題解決與技巧集錦:Linux Shell下命令su出現authentication failure解決方法...LinuxAI
- Android com.android.support衝突解決Android
- if doesn't support the "condition"attribute 問題解決
- Client/Server Interoperability Support Matrix for Different Oracle Vers_207303.1clientServerOracle
- Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]clientServerOracle
- Kettle資料抽取(轉換)mysql出現亂碼問題解決方法MySql