# Unable to create a user who was deleted before

**URL:** <https://forums.percona.com/t/unable-to-create-a-user-who-was-deleted-before/4478>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 27, 2015, 5:13am UTC](https://forums.percona.com/t/unable-to-create-a-user-who-was-deleted-before/4478 "2015-10-27T05:13:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![PercUse](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@PercUse](https://forums.percona.com/u/PercUse)\
**Post date:** [October 27, 2015, 5:13am UTC](https://forums.percona.com/t/unable-to-create-a-user-who-was-deleted-before/4478/1 "2015-10-27T05:13:15Z")

</div>

Hi Guys,

We’re running 3 MySQL master-master and had some trouble to create a user who was existing before for some test:

Node1: [1]

> [@](#):
>
> mysql\> create user ‘web0’@‘localhost’ identified by ‘_**';  
> ERROR 1396 (HY000): Operation CREATE USER failed for ‘web0’@‘localhost’  
> mysql\> flush privileges;  
> Query OK, 0 rows affected (0.01 sec)  
> mysql\> create user ‘web0’@‘localhost’ identified by '**_’;  
> ERROR 1396 (HY000): Operation CREATE USER failed for ‘web0’@‘localhost’

-------------------- [2]

> [@](#):
>
> Node1:  
> select \* from mysql.user where user like ‘%web0%’;  
> Empty set (0.00 sec)
> 
> Node2:  
> select \* from mysql.user where user like ‘%web0%’;  
> Empty set (0.00 sec)
> 
> Node3:  
> select \* from mysql.user where user like ‘%web0%’;  
> Empty set (0.00 sec)

----------------------- [3]

Node 1:

> [@](#):
>
> mysql\> create user ‘web0’@‘localhost’ identified by ‘_**‘’;  
> ERROR 1396 (HY000): Operation CREATE USER failed for ‘web0’@‘localhost’  
> mysql\> drop user web0@localhost;  
> Query OK, 0 rows affected (0.00 sec)  
> mysql\> flush privileges;  
> Query OK, 0 rows affected (0.00 sec)  
> mysql\> create user ‘web0’@‘localhost’ identified by '**_’';  
> Query OK, 0 rows affected (0.00 sec)

* * *

After dropping a non existing user [2] we was able to create it again [3].

Are you aware about this issue?

Installed packages:

```auto
ii percona-toolkit 2.2.15-2 Advanced MySQL and system command-line tools
ii percona-xtrabackup 2.3.2-1.precise Open source backup tool for InnoDB and XtraDB
ii percona-xtradb-cluster-client-5.6 5.6.26-25.12-1.precise Percona XtraDB Cluster database client binaries
ii percona-xtradb-cluster-common-5.6 5.6.26-25.12-1.precise Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
ii percona-xtradb-cluster-galera-3.x 3.12.2-1.precise Galera components of Percona XtraDB Cluster
ii percona-xtradb-cluster-server 5.6.15-25.2-645.precise Percona Server database server
ii percona-xtradb-cluster-server-5.6 5.6.26-25.12-1.precise Percona XtraDB Cluster database server binaries

```

Thanks