Hi I m trying to use the API here

Question

Hi I m trying to use the API here <https www pulumi com docs reference pkg mysql grant > to create a user and grant them some permissions for a MySQL db in an RDS instance with no luck Any help appreciated

billowy-army-68599 · Answer

can you share the code you have any the problem you re facing

tall-winter-40504 · Answer

I m doing ```db user = mysql User resource name= db user user= actualuser plaintext password=secret from config host=rds instance address opts=mysql opts ``` where `mysql opts` is ```mysql provider = mysql Provider resource name= db provider endpoint=rds instance endpoint username=rds instance username password=config secret mysql opts = pulumi ResourceOptions provider=mysql provider ```

tall-winter-40504 · Answer

In my RDS instance pulumi statement I m creating an `admin` account and I can successfully use it to connect to the db and run sql commands using the `mysql` CLI Doing sth like this to connect ```mysql h <http somelongstring us west 2 rds amazonaws com|somelongstring us west 2 rds amazonaws com> u admin p ```

tall-winter-40504 · Answer

So I think the RDS is getting correctly set up it s just these other `mysql` library additional statements that I m having trouble with

tall-winter-40504 · Answer

If I run `select user from mysql user ` I even see the username `actualuser` in the results printed however when I try to log in with that same `mysql` CLI I typed above I get Access Denied

tall-winter-40504 · Answer

Also if I connect to the db using the `admin` user and the CLI as I mentioned above and manually create a new user I have no problem granting them permissions or then using that new user with the CLI to connect back to the db Just the user created through Pulumi mysql provider that is having issues

billowy-army-68599 · Answer

I suspect the issue might be related to `plaintext password` that takes a string and your `secret from config` will actually be an output so you may need to wrap it in an apply Can you verify it s that by setting `plaintext password` manually

tall-winter-40504 · Answer

tried with a simple string still can t use the `mysql` CLI to access the db with that user due to Access Denied

billowy-army-68599 · Answer

you should be able to see the logs and verify the password is being set in mysql i d go there next

billowy-army-68599 · Answer

ohhh I just realized this is why <https www pulumi com docs reference pkg mysql user host nodejs> the host you ve set for the user is the rds instance address try this ```db user = mysql User resource name= db user user= actualuser plaintext password=secret from config host=0 0 0 0 opts=mysql opts ```

billowy-army-68599 · Answer

< tall winter 40504>

tall-winter-40504 · Answer

Wow I just noticed the same stuck out tongue

tall-winter-40504 · Answer

Literally seconds before you sent me that message It s good to get confirmation from someone else though I haven t tried it yet

tall-winter-40504 · Answer

I also only noticed maybe I m using the wrong host value but wasn t sure what to put there so thanks for the `0 0 0 0` suggestion stuck out tongue

tall-winter-40504 · Answer

Hmm still Access Denied disappointed

tall-winter-40504 · Answer

`grant` was the other smoking gun I found in the logs

tall-winter-40504 · Answer

Nvm based on documentation doesn t seem related

tall-winter-40504 · Answer

Trying host ` ` next

tall-winter-40504 · Answer

THAT DID IT

tall-winter-40504 · Answer

ok so it appears I do need `grant=True` after all

tall-winter-40504 · Answer

Earlier when I said I successfully got it to work that line was left in my code from an earlier experiment I removed it assuming it was a failed experiment now that I had finally gotten things to work but that just broke things again

tall-winter-40504 · Answer

Based on the documentation for what that parameter should be doing this behavior seems incorrect

tall-winter-40504 · Answer

Should I file a bug somewhere

tall-winter-40504 · Answer