wp core config --dbname=wordpress --dbuser=wordpress --dbpass='this is not the real password'

$ wp core config --dbname=wordpress --dbuser=wordpress --dbpass='this is not the real password'
ERROR 1045 (28000): Access denied for user 'wordpress'@'localhost' (using password: YES)

MariaDB [(none)]> SELECT Host, User FROM mysql.user;
+-----------+-----------+
| Host      | User      |
+-----------+-----------+
| %         | wordpress |
| 127.0.0.1 | root      |
| ::1       | root      |
| localhost |           |
| localhost | root      |
+-----------+-----------+