How to escape '@' in MySQL username when connecting

sasha-alias / sqltabs

Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift, Google Firebase (Firestore)

https://www.sqltabs.com

GNU General Public License v3.0

805 stars 65 forks source link

How to escape '@' in MySQL username when connecting #156

Closed bbkane closed 3 years ago

bbkane commented 3 years ago

Hello! I'm trying to connect to a MySQL database and my username has a @ as part of it. When I try to connect, the app prompts for the password, then says Error: Access denied for user 'username-before-at-symbol'@'1.1.1.1' (using password: YES) Is there a way to escape an @ in the username?

sasha-alias commented 3 years ago

Hi, sorry for delay with response. Have you tried the standard URL escape code for @: %40?

bbkane commented 3 years ago

I'll have to try that the next time I connect, thanks!