[转载] 卧春# Unix - 噫吁兮,危乎高哉
bz
1 楼
【 以下文字转载自 Linux 讨论区 】
【 原文由 bz 所发表 】
I installed MySQL and used root to grant priv to a normal user test1.
mysql> grant CREATE,UPDATE,SELECT,ALTER on mytest_db.* to [email protected];
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
I did not grant DROP to test1, but test1 still can delete tables in
mytest_db database. Any ideas? how to make normal user can only creat table
and can not delete table, like ftp uploading account in ftp servers?
Thanks
【 原文由 bz 所发表 】
I installed MySQL and used root to grant priv to a normal user test1.
mysql> grant CREATE,UPDATE,SELECT,ALTER on mytest_db.* to [email protected];
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
I did not grant DROP to test1, but test1 still can delete tables in
mytest_db database. Any ideas? how to make normal user can only creat table
and can not delete table, like ftp uploading account in ftp servers?
Thanks