在mysql中授予数据库权限

Question

我有一个新的mysql安装，并试图创建一个单独的用户可以访问他们自己的数据库。

mysqladmin -u root -p create people
mysql> create user 'cgp'@'localhost' identified by 'myPass';
mysql> grant all on people to 'cgp'@'localhost' identified by 'myPass';
Query OK, 0 rows affected (0.00 sec)       <-- problem here?
mysqladmin -v  -u root -p flush-privileges

mysql -h localhost -u cgp -p people
Enter password:
ERROR 1044 (42000): Access denied for user 'cgp'@'localhost' to database 'people'

mysql -u root -p
mysql> show grants;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*xxx' WITH GRANT OPTION
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

如您所见，Grant表中没有用于cgp用户的任何内容。我做错了什么？

Answer 1

试一试

grant all on people.* to 'cgp'@'localhost' identified by 'myPass';

• 通配符意味着人员数据库中的所有表都应该被授予访问权限。