Hi all I am thinking of installing pulumi mysql

Question

Hi all I am thinking of installing pulumi mysql I want to manage MySQL user permissions but I don t seem to be able to execute Grant statements at the column there a better way to use Pulumi and execute column level Grant statements I would like to manage the following query using Pulumi ```GRANT SELECT col1 INSERT col1 col2 ON mydb mytbl TO someuser somehost ```

nice-lizard-13594 · Answer

You can create a that uses the `mysql` package under the hood An example with a MySQL connection + custom SQL query can be found in the Automation API Examples repository

incalculable-monkey-35668 · Answer

Thank you pray That s the information I need I will confirm it

billowy-army-68599 · Answer

< incalculable monkey 35668> does the user you re connecting to the mysql database have `GRANT` permission what error are you getting

incalculable-monkey-35668 · Answer

< billowy army 68599> Thanks for asking I am running with root privileges First run this pulumi program ```package main import func main pulumi Run getInitLocalTestingDb func getInitLocalTestingDb func ctx pulumi Context error return func ctx pulumi Context error err = mysql NewDatabase ctx pulumi testing nil if err = nil return err err = mysql NewUser ctx testUser amp mysql UserArgs Host pulumi String 127 0 0 1 PlaintextPassword pulumi String test User pulumi String test if err = nil return err return nil ``` Next execute SQL ```create table tutorials tbl tutorial id INT NOT NULL AUTO INCREMENT tutorial title VARCHAR 100 NOT NULL tutorial author VARCHAR 40 NOT NULL submission date DATE PRIMARY KEY tutorial id ``` In addition this pulumi program is executed ```package main import func main pulumi Run getInitLocalTestingDb func getInitLocalTestingDb func ctx pulumi Context error return func ctx pulumi Context error database err = mysql NewDatabase ctx pulumi testing nil if err = nil return err testUser err = mysql NewUser ctx testUser amp mysql UserArgs Host pulumi String 127 0 0 1 PlaintextPassword pulumi String test User pulumi String test if err = nil return err err = mysql NewGrant ctx testGrant amp mysql GrantArgs Database database Name Host testUser Host Privileges pulumi StringArray pulumi String SELECT User testUser User Table pulumi String tutorials tbl if err = nil return err return nil ``` It succeeded However when I run the pulumi program with the following changes it fails ```Table pulumi String tutorials tbl tutorial id ``` result ```Diagnostics mysql index Grant testGrant error Error running SQL GRANT SELECT ON `pulumi testing f0a806e` `tutorials tbl tutorial id` TO test 127 0 0 1 REQUIRE NONE Error 1146 Table pulumi testing f0a806e tutorials tbl tutorial id doesn t exist pulumi pulumi Stack app dev2 error update failed``` The reason for the failure is clear the Grant statement is incorrect If true I would like to execute the following Grant statement ```GRANT SELECT tutorial id ON `pulumi testing f0a806e` `tutorials tbl` TO test 127 0 0 1 REQUIRE NONE ```

billowy-army-68599 · Answer

the reason seems to me because the table `pulumi testing f0a806e tutorials tbl tutorial id` doesn t exist How are you running the `create table` statement