bz
1 楼
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!
I am pretty new to dba stuff.
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!
I am pretty new to dba stuff.