----------
ID: mysql
Function: cmd.run
Name: mysql <<EOF
create database omeka;
grant all privileges on omeka.* to 'ubuntu'@'localhost' identified by 'banana';
flush privileges;
EOF
mysqladmin -u root password xm98XVYUr9dSvRCBEE
Result: False
Comment: Command "mysql <<EOF
create database omeka;
grant all privileges on omeka.* to 'ubuntu'@'localhost' identified by 'banana';
flush privileges;
EOF
mysqladmin -u root password xm98XVYUr9dSvRCBEE
" run
Changes:
----------
pid:
16039
retcode:
1
stderr:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
stdout:
Thanks, I will. I was aware that it doesn't deploy on Trusty - the Apache config seems to have significantly changed. Didn't realise MySQL fails as well. :/
have you taken a look at http://docs.saltstack.com/en/latest/ref/states/all/salt.states.mysql_grants.html ?