bz 发帖数: 1770 | 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 test1@localhost;
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 |
|