Sails: Certain special characters in MySQL database password causing problem (sails-mysql adapter)

[alexschwarz89]

Sails version: 1.0.0
Node version: 8.11.0
NPM version: 5.6.0
DB adapter name: sails-mysql
DB adapter version: 1.0.0.-17
Operating system: Debian 9

---

Passwords starting with an exclamation mark cause the database connection to fail. This was already mentioned in Issue #4204 but the issue is closed without a resolution. In my opinion special characters should work in passwords, no matter if there at the beginning or not.

Steps to reproduce:

Use sails-mysql and set up a datastore with a password something like "!!xyz123". Try to lift the app with sails lift

[sailsbot]

Hi @alexschwarz89! It looks like you may have removed some required elements from the initial comment template, without which I can't verify that this post meets our contribution guidelines. To re-open this issue, please copy the template from here, paste it at the beginning of your initial comment, and follow the instructions in the text. Then post a new comment (e.g. "ok, fixed!") so that I know to go back and check.

Sorry to be a hassle, but following these instructions ensures that we can help you in the best way possible and keep the Sails project running smoothly.

*If you feel this message is in error, or you want to debate the merits of my existence (sniffle), please contact [email protected]

[sailsbot]

@alexschwarz89 Thanks for posting, we'll take a look as soon as possible.

---

For help with questions about Sails, click here. If you’re interested in hiring @sailsbot and her minions in Austin, click here.

[mikermcneil]

https://trello.com/c/87tB7k4d

[maido155]

Would be awesome if this bug is fixed, it is very common to use a password with special characters.

[johnabrams7]

@alexschwarz89 @maido155 - A new sails-sql adapter is currently in development and includes support for exclamation marks in the password. I've verified sails connects to MySQL databases with exclamation marks in the password (which also included CAPS, lowercase, and numbers).

[maheshwarishivam]

Please add support for @ charracter in database password as well

[johnabrams7]

@maheshwarishivam I can confirm both the latest sails-sql & sails-mysql adapters support the @ character in database passwords (along with !).

--
Tip: For MySQL 8.x, using Legacy Password Encryption (MySQL 5.x authentication support) for database initialization can get past authentication plugin cannot be loaded errors for both adapters as well as Sequel Pro.