Namespace Pulumi.MySql

Classes

Config

Database

The mysql..Database resource creates and manages a database on a MySQL server.

Caution: The mysql..Database resource can completely delete your database just as easily as it can create it. To avoid costly accidents, consider setting prevent_destroy on your database resources as an extra safety measure.

Example Usage

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var app = new MySql.Database("app", new MySql.DatabaseArgs
    {
    });
}

}

DatabaseArgs

DatabaseState

Grant

The mysql..Grant resource creates and manages privileges given to a user on a MySQL server.

Granting Privileges to a User

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var jdoeUser = new MySql.User("jdoeUser", new MySql.UserArgs
    {
        Host = "example.com",
        PlaintextPassword = "password",
        User = "jdoe",
    });
    var jdoeGrant = new MySql.Grant("jdoeGrant", new MySql.GrantArgs
    {
        Database = "app",
        Host = jdoeUser.Host,
        Privileges = 
        {
            "SELECT",
            "UPDATE",
        },
        User = jdoeUser.UserName,
    });
}

}

Granting Privileges to a Role

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var developerRole = new MySql.Role("developerRole", new MySql.RoleArgs
    {
    });
    var developerGrant = new MySql.Grant("developerGrant", new MySql.GrantArgs
    {
        Database = "app",
        Privileges = 
        {
            "SELECT",
            "UPDATE",
        },
        Role = developerRole.Name,
    });
}

}

Adding a Role to a User

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var jdoe = new MySql.User("jdoe", new MySql.UserArgs
    {
        Host = "example.com",
        PlaintextPassword = "password",
        User = "jdoe",
    });
    var developerRole = new MySql.Role("developerRole", new MySql.RoleArgs
    {
    });
    var developerGrant = new MySql.Grant("developerGrant", new MySql.GrantArgs
    {
        Database = "app",
        Host = jdoe.Host,
        Roles = 
        {
            developerRole.Name,
        },
        User = jdoe.UserName,
    });
}

}

GrantArgs

GrantState

Provider

The provider type for the mysql package. By default, resources use package-wide configuration settings, however an explicit Provider instance may be created and passed during resource construction to achieve fine-grained programmatic control over provider settings. See the documentation for more information.

ProviderArgs

Role

The mysql..Role resource creates and manages a user on a MySQL server.

Note: MySQL introduced roles in version 8. They do not work on MySQL 5 and lower.

Example Usage

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var developer = new MySql.Role("developer", new MySql.RoleArgs
    {
    });
}

}

RoleArgs

RoleState

User

The mysql..User resource creates and manages a user on a MySQL server.

Note: The password for the user is provided in plain text, and is obscured by an unsalted hash in the state Read more about sensitive data in state. Care is required when using this resource, to avoid disclosing the password.

Example Usage

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var jdoe = new MySql.User("jdoe", new MySql.UserArgs
    {
        Host = "example.com",
        PlaintextPassword = "password",
        User = "jdoe",
    });
}

}

Example Usage with an Authentication Plugin

using Pulumi;
using MySql = Pulumi.MySql;

class MyStack : Stack
{
public MyStack()
{
    var nologin = new MySql.User("nologin", new MySql.UserArgs
    {
        AuthPlugin = "mysql_no_login",
        Host = "example.com",
        User = "nologin",
    });
}

}

UserArgs

UserPassword

UserPasswordArgs

UserPasswordState

UserState