Description:
I am trying to connect to a remote DB through Standard TCP/IP over SSH. I have passwords that have special characters including ^, #, {, }, (, ), [, or ].
When I attempt to use the password as-is, I get an "Access denied for user" error. When I connect to the DB through command line, as long as I surround the password in quotes, I can connect successfully. I can SSH to the remote server successfully
I have tried saving my password in the vault surrounded in single and double quotes, but I still cannot connect to the DB. I have tried using the escape character "\" before every special character in the password, but that did not work. With the exact same parameters, I tested my connection in SQL Maestro for MySQL and it worked. I don't like that tool nearly as much as I like Workbench.
I have not found any documentation on MySQL's site for handling passwords with special characters in Workbench.
NOTE: This appears to be an issue specific to Windows (I'm using Windows 10). MAC users have no issues accessing the DB with the same password through Workbench.
Any ideas?
How to repeat:
MySQL Workbench 6.3.8 > Setup New Connection
Connection Method: Standard TCP/IP over SSH
Configure SSH parameters (I'm not using a SSH Key File)
Configure MySQL parameters (I'm using a specific IP for the hostname, not localhost)
Click Test Connection
Description: I am trying to connect to a remote DB through Standard TCP/IP over SSH. I have passwords that have special characters including ^, #, {, }, (, ), [, or ]. When I attempt to use the password as-is, I get an "Access denied for user" error. When I connect to the DB through command line, as long as I surround the password in quotes, I can connect successfully. I can SSH to the remote server successfully I have tried saving my password in the vault surrounded in single and double quotes, but I still cannot connect to the DB. I have tried using the escape character "\" before every special character in the password, but that did not work. With the exact same parameters, I tested my connection in SQL Maestro for MySQL and it worked. I don't like that tool nearly as much as I like Workbench. I have not found any documentation on MySQL's site for handling passwords with special characters in Workbench. NOTE: This appears to be an issue specific to Windows (I'm using Windows 10). MAC users have no issues accessing the DB with the same password through Workbench. Any ideas? How to repeat: MySQL Workbench 6.3.8 > Setup New Connection Connection Method: Standard TCP/IP over SSH Configure SSH parameters (I'm not using a SSH Key File) Configure MySQL parameters (I'm using a specific IP for the hostname, not localhost) Click Test Connection