重庆思庄Oracle、Redhat认证学习论坛

标题: MySQL创建用户报错ERROR 1396 (HY000): Operation CREATE USER failedfor 'bkuser'... [打印本页]

作者: jiawang 时间: 2022-12-5 09:03
标题: MySQL创建用户报错ERROR 1396 (HY000): Operation CREATE USER failedfor 'bkuser'...
本帖最后由 jiawang 于 2022-12-5 09:03 编辑

报错现象：
mysql> CREATE USER 'bkuser'@'localhost' IDENTIFIED BY 'bkuser';
ERROR 1396 (HY000): Operation CREATE USER failed for 'bkuser'@'localhost'

mysql> drop user 'bkuser'@'localhost';
Query OK, 0 rows affected (0.10 sec)

使用drop user语句删除用户，可能是之前删除用户lwx的时候有问题，例如从user表删除就会出现这样的问题

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER 'bkuser'@'localhost' IDENTIFIED BY 'bkuser';
Query OK, 0 rows affected (0.01 sec)

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)