sonarcube

为sonar 创建一个数据库和使用这个数据库的用户，并进行授权：

 

mysql> create user 'sonar'@'%'identified by 'sonar123';

Query OK, 0 rows affected (0.16 sec)

 

mysql> create database sonar character set utf8;

Query OK, 1 row affected (0.12 sec)

 

mysql> grant all privieges on sonar.* to 'sonar'@'%';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near 'privi

eges on sonar.* to 'sonar'@'%'' at line 1

mysql> grant all privileges on sonar.* to 'sonar'@'%';

Query OK, 0 rows affected (0.00 sec)