显示用户权限那里有错误 应该为: show grants for 'test'@'%';
在mysql8.x中修改子账号的密码不需要加password()了。用下面的命令就可以了: set password for test ='1122';
grant all privileges on testdb.* to 'test'@'%' identified by '1234';
db名称不能加‘’