- mysql> select Host,User,Password from user where User=\'root\';
- +--------------+------+-------------------------------------------+
- | Host | User | Password |
- +--------------+------+-------------------------------------------+
- | bidevedw\\_db| root | *D013A4E3A5BB01E4239D18D7E93B59B7D2B767AD |
- | ::1 | root | *D013A4E3A5BB01E4239D18D7E93B59B7D2B767AD |
- | % | root | *D013A4E3A5BB01E4239D18D7E93B59B7D2B767AD |
- +--------------+------+-------------------------------------------+-
原因:在我的配置文件my.cnf中有这样一条语句
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
指定了严格模式,为了安全,严格模式禁止通过insert 这种形式直接修改mysql库中的user表进行添加新用户
解决办法:
将配置文件中的STRICT_TRANS_TABLES删掉,即改为:
sql_mode=NO_ENGINE_SUBSTITUTION
然后重启mysql即可