Question

grant all privileges on  bbs  to  userone @ localhost   IDENTIFIED BY PASSWORD  user2012 ;

它显示 ERROR 1064 (42000): 您的 SQL 语法有错误; 请检查手动



I want to add a user userone and  grant all privileges to the database bbs.
How to correct it?

Answer 1

您需要在数据库中包含一个要给予此特权的表格的显示。更改查询 :

在 bbs. * 上授予所有权限到 userone @ localhost IDIF 用户 PASSWORD 用户 2012;

用于数据库中的所有表格。

Answer 2

将留在表格名称上:

grant all privileges on bbs to  userone @ localhost   IDENTIFIED BY PASSWORD  user2012 ;

Answer 3

grant all privileges on  bbs.*  to  userone @ localhost  identified by ‘user2012’;