Ubuntu 13.04
Well i was simply using this:
create database lollipop; grant all on lollipop.* to 'foreman' identified by '5t1ck'; flush privileges;
But sadly it did not worked so i’ve updated my code like below
create database lollipop; grant all on lollipop.* to foreman@localhost identified by '5t1ck'; flush privileges;
And it works