Creating a new MySQL database and user with full access to it

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;

Leave a Reply

Your email address will not be published. Required fields are marked *