Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class core {
- class { '::mysql::server':
- root_password => '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257',
- remove_default_accounts => true,
- override_options => {
- 'mysqld' => {
- 'bind-address' => '0.0.0.0',
- 'server-id' => '1',
- 'binlog-format' => 'mixed',
- 'log-bin' => 'mysql-bin',
- 'datadir' => '/var/lib/mysql',
- 'innodb_flush_log_at_trx_commit' => '1',
- 'sync_binlog' => '1',
- 'binlog-do-db' => ['app_db'],
- }
- }
- }
- mysql_user { 'slave_user@%':
- ensure => 'present',
- password_hash => mysql_password('123'),
- }
- mysql_grant { 'slave_user@%/*.*':
- ensure => 'present',
- privileges => ['REPLICATION SLAVE'],
- table => '*.*',
- user => 'slave_user@%',
- }
- mysql::db { 'app_db':
- user => 'dbuser',
- password => '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257',
- host => '%',
- }
- }
- Notice: /Stage[main]/Mysql::Server::Root_password/File[/root/.my.cnf]/content: content changed '{md5}b52301963c1bc0d06bd0de29e43c22d1' to '{md5}ca645da4ee27089926b4c47fb2ca81a3'
- Error: Failed to apply catalog: Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe show databases' returned 1: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Add Comment
Please, Sign In to add comment