Hi;

I can create the following just fine:

grant all on data1.* to myuser IDENTIFIED BY 'pass';

grant all on data2.* to myuser IDENTIFIED BY 'pass';

...but when I try this:

CREATE USER myuser IDENTIFIED BY 'pass';

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

...and this:

1044, "Access denied for user 'myuser'@'%' to database 'data1'"

Why?

TIA,

Victor

Reply via email to