用该语句设置用户时
grant all privileges on *.* to root@'172.16.150.%' identified by 'abc';
出现了

而我的user表中有

怎么解决,求大神
------解决思路----------------------
是不是你 root 权限不足呢?
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'172.16.150.%'
IDENTIFIED BY 'abc' WITH GRANT OPTION;
------解决思路----------------------
你直接在本地登录,用root站好,localhost的host,登录,然后就可以执行上面的语句了。