I just tried to add a new user to MySQL using
CREATE USER 'name'@'%' IDENTIFIED BY '...'
However, it fails with the following error:
ERROR 1396 (HY000): Operation CREATE USER failed for 'name'@'%'
Adding the user just for localhost works fine:
CREATE USER 'name'@'localhost' IDENTIFIED BY '...'
I have no clue what could be the problem. I'd be grateful for any ideas.
mysql Ver 14.14 Distrib 5.1.66.)