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;