users

Documentation

Index

• Constants
• Variables
• type Manager
  • func NewManager(addr string, user, pass string, timeout int32) (Manager, error)
  • func (u *Manager) Close() error
  • func (u *Manager) CreateOperatorUser(pass string) error
  • func (u *Manager) CreateReplicationUser(password string) error
  • func (m *Manager) DiscardOldPassword(user *SysUser) error
  • func (p *Manager) GetUser(ctx context.Context, user string) (*User, error)
  • func (m *Manager) IsOldPassDiscarded(user *SysUser) (bool, error)
  • func (u *Manager) Update1100MonitorUserPrivilege() (err error)
  • func (u *Manager) Update1150XtrabackupUser(pass string) (err error)
  • func (u *Manager) Update160MonitorUserGrant(pass string) (err error)
  • func (u *Manager) UpdatePassExpirationPolicy(user *SysUser) error
  • func (u *Manager) UpdateProxyUser(user *SysUser) error
  • func (m *Manager) UpdateUserPass(user *SysUser) error
  • func (u *Manager) UpdateUserPassWithoutDP(user *SysUser) error
  • func (u *Manager) UpsertUser(ctx context.Context, query []string, pass string) error
• type SysUser
• type User

Constants

const (
	Root         = "root"
	Operator     = "operator"
	Monitor      = "monitor"
	Xtrabackup   = "xtrabackup"
	Replication  = "replication"
	ProxyAdmin   = "proxyadmin"
	PMMServer    = "pmmserver"
	PMMServerKey = "pmmserverkey"
)

Variables

var UserNames = []string{Root, Operator, Monitor, Xtrabackup,
	Replication, ProxyAdmin, PMMServer, PMMServerKey}

Types

type Manager

type Manager struct {
	// contains filtered or unexported fields
}

func NewManager

func NewManager(addr string, user, pass string, timeout int32) (Manager, error)

func (*Manager) Close

func (u *Manager) Close() error

func (*Manager) CreateOperatorUser

func (u *Manager) CreateOperatorUser(pass string) error

func (*Manager) CreateReplicationUser

func (u *Manager) CreateReplicationUser(password string) error

func (*Manager) DiscardOldPassword

func (m *Manager) DiscardOldPassword(user *SysUser) error

DiscardOldPassword discards old passwords of given users

func (*Manager) GetUser

func (p *Manager) GetUser(ctx context.Context, user string) (*User, error)

GetUsers returns a user stored in the database

func (*Manager) IsOldPassDiscarded

func (m *Manager) IsOldPassDiscarded(user *SysUser) (bool, error)

DiscardOldPassword discards old passwords of given users

func (*Manager) Update1100MonitorUserPrivilege

func (u *Manager) Update1100MonitorUserPrivilege() (err error)

Update1100MonitorUserPrivilege grants system_user privilege for monitor

func (*Manager) Update1150XtrabackupUser

func (u *Manager) Update1150XtrabackupUser(pass string) (err error)

Update1150XtrabackupUser grants all needed rights to the xtrabackup user

func (*Manager) Update160MonitorUserGrant

func (u *Manager) Update160MonitorUserGrant(pass string) (err error)

Update160MonitorUserGrant grants SERVICE_CONNECTION_ADMIN rights to the monitor user if pxc version is 8 or more and sets the MAX_USER_CONNECTIONS parameter to 100 (empirically determined)

func (*Manager) UpdatePassExpirationPolicy

func (u *Manager) UpdatePassExpirationPolicy(user *SysUser) error

UpdatePassExpirationPolicy sets user password expiration policy to never

func (*Manager) UpdateProxyUser

func (u *Manager) UpdateProxyUser(user *SysUser) error

func (*Manager) UpdateUserPass

func (m *Manager) UpdateUserPass(user *SysUser) error

UpdateUserPass updates user passwords but retains the current password using Dual Password feature of MySQL 8.

func (*Manager) UpdateUserPassWithoutDP

func (u *Manager) UpdateUserPassWithoutDP(user *SysUser) error

UpdateUserPassWithoutDP updates user pass without Dual Password feature introduced in MsSQL 8

func (*Manager) UpsertUser

func (u *Manager) UpsertUser(ctx context.Context, query []string, pass string) error

type SysUser

type SysUser struct {
	Name  string   `yaml:"username"`
	Pass  string   `yaml:"password"`
	Hosts []string `yaml:"hosts"`
}

type User

type User struct {
	Name  string
	Hosts sets.Set[string]
	DBs   sets.Set[string]

	// Grants holds the grants for each user@host
	Grants map[string][]string
}