本文介绍了如何转义mysql jdbc连接字符串中的特殊字符的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
im trying to connect to a remote database. im sure that the remote database provide me all the privileges. but im getting this error when trying to connect to the remote mysql database through jdbc connection. my password contains, * and & symbol, i think that is the problem cause to this error. but i dont know how to escape those characters. please help
java.sql.SQLException: Access denied for user 'myusername'@'myhost' (using password: YES)
"jdbc:mysql://myhost/mydb?user=myusername&password=my&password*"
please help
Regards
解决方案
The JDBC connection string is in url format so you must use URL encoded values for all parameters. In your case the connection string should look like:
"jdbc:mysql://myhost/mydb?user=myusername&password=my%26password%2A"
这篇关于如何转义mysql jdbc连接字符串中的特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！