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