mysql刪除用戶后再次創(chuàng)建用戶報錯

mysql中刪除又想重建123用戶，但是執(zhí)行創(chuàng)建命令報錯。

可以看到mysql用戶中并沒有123，可是卻無法創(chuàng)建，經(jīng)查閱這是一個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'