In order to install sonar I used the following approach to create database and user.

create database sonar;
grant all privileges on sonar.* to 'sonar'@'%' identified by "sonar";
flush privileges;