mysql刪除用戶(hù)后再次創(chuàng)建用戶(hù)報(bào)錯(cuò)

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

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