Ask Your Question

Is it possible to create a new new database using puppet???

asked 2018-03-09 22:47:44 -0600

Ansi gravatar image

I have installed mysql using puppet and have just deployed them in my agent. Now I want to create a new database in mysql so that it would be applied in my agents too. I looked up some tutorials but i couldnt understand and i don't know where to start and how to start. So pls somebody guide me.

My Master is Ubuntu 16.04 My Agent is Windows 8.1 My Puppet version is 3.8.5 MySql version is 5.7

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-03-12 07:31:14 -0600

b4ldr gravatar image

  mysql::db { 'mydb':
      user     => 'myuser',
      password => 'mypass',
      host     => 'localhost',
      sql      => '/path/to/sqlfile.gz',
      grant    => ['SELECT', 'UPDATE'],
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2018-03-09 22:47:44 -0600

Seen: 24 times

Last updated: Mar 12