思考题
–如何给数据库testdata设置如下权限
•用途:查询数据
•用户名:viewer
•密码:T3nc3t!965.A
•Web CGI程序主机IP : 172.16.1.1
答案:
mysql> grant select,insert,update,delete,create,drop privileges on testdata.* to viewer@’172.16.1.1/255.255.255.0′ identified by ‘ T3nc3t!965.A ‘; (责任编辑:IT) |