ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables

在mysql授权远程主机192.168.100.20通过bob用户查询auth库的所有表或者在集群中创建用户时，出现如下错误！

mysql> grant select on auth.* to 'bob'@'192.168.100.20' identified by 'pwd@123';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

解决办法：

在命令行输入：mysql> flush privileges;