Hey @juliettet @rahul456
I have assigned a task to setup mariadb using puppet.
I am able to install and start the service of mariadb using below puppet file:
class mysql_database {
package { ‘mariadb-server’:
ensure => ‘installed’,
}
service { ‘mariadb’:
ensure => ‘running’,
enable => ‘true’,
}
}
node ‘stdb01.stratos.xfusioncorp.com’ {
include mysql_database
}
node default {}
Now the question says,
- Create a database
kodekloud_db8
, a database userkodekloud_gem
and set passwordksH85UJjhb
for this new user also remember host should belocalhost
. Finally grant some usual permissions like select, update (or full) ect to this newly created user on newly created database.
Do I need to do this using Puppet only? Or do I need to do this configuration manually over database server?