- 论坛徽章:
- 14
|
回复 6# RogerZhuo
mysql> INSERT INTO USER(HOST,USER,PASSWORD,select_priv,Super_priv,Grant_priv,Create_user_priv) VALUES ('localhost','roy',PASSWORD('123456'),'Y','Y','Y','Y');
ERROR 1146 (42S02): Table 'mysql.USER' doesn't exist
mysql> INSERT INTO user(HOST,USER,PASSWORD,select_priv,Super_priv,Grant_priv,Create_user_priv) VALUES ('localhost','roy',PASSWORD('123456'),'Y','Y','Y','Y');
Query OK, 1 row affected, 3 warnings (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
有够奇怪,mysql还区分大小写???? |
|