mysqlherokuyii2credentialsmysql-error-1044

Heroku. MariaDB. Access denied for user


I'm creating new app on Heroku. Installed add-on "JawsDB Maria" successfully - I can open it's dashboard

In PHP on connection to DB I receive error:

SQLSTATE[HY000] [1044] Access denied for user 'vcgu1h273742rn5l'@'%' to database 'jeyx2j66ipgtqe11'

I'm sure that problem is not in PHP, because the same error I receive even on MariaDB dashboard trying to Create New Databite - https://prnt.sc/rj4dr4 .

Looks like solution is to GRANT ALL PRIVILEGES to user. But using dashboard I can't execute even SHOW GRANTS.

Questions:

  1. Can somebody help how to solve this problem?
  2. Or, at least, which way I can GRANT ALL PRIVILEGES?

I've tried:

Additional info - I'm sure it is not important, but just in case it is:


Solution

  • I've waited for 8 hours, hoping there is some trigger, that will complete all necessary settings. But it didn't helped.

    Then I reinstalled this add-on. And now all works fine! So, that was some kind of "JawsDB Maria" bug.