how to escape special characters in mysql jdbc connection string

Question

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

Answer 1

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"

Answer 2

URLEncoder can be used:

String connectionString = "jdbc:mysql://myhost/mydb?" + URLEncoder.encode("user=myusername&password=my&password*", "UTF-8");