合作机构:阿里云 / 腾讯云 / 亚马逊云 / DreamHost / NameSilo / INWX / GODADDY / 百度统计
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'
TOP