Clean install 2.4.0 setup:install database password fails because it has special characters

Trying to install a clean version of the much more “secure” version of Magento 2.4.0 CE but when  run the install:setup via the cli it throws an error:

SQLSTATE[HY000] [1045] Access denied for user ‘admin_……….’@’localhost’ (using password: YES)

The password is correct & found another thread that said it was because the password contained special characters so I removed the special characters & it worked.  It also said that if you place a before the special character it works but it didn’t for me.

Surely this has to be a bug.