Not the answer you need?
Register and ask your own question!

Unable to create a user who was deleted before

PercUsePercUse ContributorInactive User Role Beginner
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 [email protected];
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:
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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.