mysql新增用户，提示1290错误, skip-grant-tables

在做mysql创建新用户的时候， 报1290错误

【ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement】

mysql> GRANT ALL PRIVILEGES ON . TO IDENTIFIED BY ‘123’ WITH GRANT OPTION;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
尝试其他方法不行，这个时候我们只需要flush privileges 一下，在添加用户就OK了，

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

然后添加就ok了，