84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
在网上找到授予用户某数据库操作权限的SQL语句,看到两种答案,一种是:
GRANT privileges ON databasename.tablename TO 'username'@'host'
另一种是
GRANT ON databasename.tablename TO 'username'@'host'
而且好多答案是第一种,但是第一种我执行时语法错误,请问是什么原因造成网上博客等有这么多第一种答案
好好学习,天天向上!!!
MySQL operation permission statement, what is the privileges keyword? -PHP Chinese website Q&A-What is the privilege keyword in the MySQL operation permission statement? -PHP Chinese website Q&A
Let’s take a look and learn.
第一种:GRANT all privileges ON databasena .....试试,少个 all。意思是赋予这个用户操作这个数据库表的所有权限
第二种;grant 后面加一个 insert或者update 试试,grant 后需要加你要给这个用户授予数据库表的何种操作(inset,update,select,delete等)权限
MySQL operation permission statement, what is the privileges keyword? -PHP Chinese website Q&A-What is the privilege keyword in the MySQL operation permission statement? -PHP Chinese website Q&A
Let’s take a look and learn.
第一种:GRANT all privileges ON databasena .....试试,少个 all。意思是赋予这个用户操作这个数据库表的所有权限
第二种;grant 后面加一个 insert或者update 试试,grant 后需要加你要给这个用户授予数据库表的何种操作(inset,update,select,delete等)权限