mysql刪除用戶后再次創建用戶報錯

mysql中刪除又想重建123用戶，但是執行創建命令報錯。

可以看到mysql用戶中并沒有123，可是卻無法創建，經查閱這是一個mysql官方bug：

This bug has been sitting on bugs.mysql.com since 2007 and this thread is mainly just a parroting of all those wrong answers even up to a year ago.

解決方法：

drop user 123@localhost;

flush privileges;

create user 123@localhost identified by 'password'