位置:首页-常见问题-centOS中mysql一些常用操作

centOS中mysql一些常用操作

  在Mysql创建用户并为新用户授权时、出现如下错误!

  mysql> grant all privileges on newy.* to newsmay@localhost identified by '123456';

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

  解决办法:

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


收起
展开