why can't create a new user in mysql? -

why can't create a new user in mysql? -

mysql> select user,host mysql.user; +------------------+-----------+ | user | host | +------------------+-----------+ | root | 127.0.0.1 | | root | ::1 | | debian-sys-maint | localhost | | developer | localhost | | jack | localhost | | root | localhost | | root | rebuild | +------------------+-----------+ 7 rows in set (0.00 sec) mysql> show databases; +--------------------+ | database | +--------------------+ | information_schema | | mysql | | performance_schema | | wpdatabase | +--------------------+ 4 rows in set (0.00 sec) mysql> create user wpuser@localhost; error 1396 (hy000): operation create user failed 'wpuser'@'localhost'

why can't create new user in mysql? user wpuser not in table user. neved used databases, can help me on how create new user ?

no,it not problem of password(123456 key of mysql database).

mysql> create user 'wpuser'@'localhost' identified '123456'; error 1396 (hy000): operation create user failed 'wpuser'@'localhost'

it unusual ,please go on .

why create user wpuser@localhost; can't ; create user wpusers@localhost; can?

i had same problem believe. accidentally created 'myuser', deleted using the command below, , cannot create user, although not showing on mysql.user table

i tried these commands deleting no avail.

delete user mysql.user user='myuser' delete user mysql.user user='myuser' , host='localhost' delete user mysql.user user='myuser' , host='%'

it worked me when utilize command remove user.

drop user 'myuser'@'localhost';

in between trying out these commands flush privileges though i'm on diarrhoea. in case still not work, begueradj suggested.

mysql