Can't create user in mysql for sonarqube

Asked Oct 19 '17 at 15:07

Active Oct 20 '17 at 11:30

Viewed 62 times

I'm trying to set up a remote user for sonarqube :

USE mysql
CREATE USER sonar@'%' IDENTIFIED BY 'password';

But I get this error :

ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'

Any idea ?

EDIT :

I tried to flush privileges; but same result after that.

EDIT 2 :

The duplicate proposition does not match my issue..

To be precise the users are to be created in mysql database, which is why I don't do CREATE DATABASE but only CREATE

edited Oct 20 '17 at 11:30

Raymond Nijland

asked Oct 19 '17 at 15:07

An-droid

Possible dup. https://stackoverflow.com/questions/5555328/error-1396-hy000-operation-create-user-failed-for-jacklocalhost – bassxzero Oct 19 '17 at 15:12
As I said I tried this already :) – An-droid Oct 19 '17 at 15:17
In the CREATE USER MySQL documentation they are using qoutes around the username.. So try `CREATE USER 'sonar'@'%' IDENTIFIED BY 'password';` – Raymond Nijland Oct 19 '17 at 15:21
Could you show the results for `SELECT user,host FROM user;`. – Peter M Oct 19 '17 at 15:22
Please show the results for `SELECT user, host FROM mysql.user` – Raymond Nijland Oct 20 '17 at 11:27

0 Answers0