执行以下语句的时候
mysql> CREATE USER 'appleyuchi'@'%' IDENTIFIED with mysql_native_password BY 'appleyuchi';
出现:
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
解决方案:
先执行
mysql> flush privileges;
然后再
mysql> CREATE USER 'appleyuchi'@'%' IDENTIFIED with mysql_native_password BY 'appleyuchi';
即可