php - xampp mysql : select command denied

Question

我正在使用 xampp om windows 7。我使用我设置的密码以 root 用户身份登录。我创建了一个新数据库(我是第一次使用 xampp)。而且我没有任何选项可以在其中创建任何表格。它显示以下错误:

Error
SQL query: DocumentationEdit

SELECT `tables` 
FROM `phpmyadmin`.`pma_recent`
WHERE `username` =  'root'

MySQL said: Documentation

#1142 - SELECT command denied to user ''@'localhost' for table 'pma_recent'

我该如何摆脱它？

我在页面底部的某处也看到了这一行以及错误消息:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.

Answer 1

http://dev.mysql.com/doc/refman/5.1/en/grant.html

GRANT SELECT ON db.table TO 'user'@'localhost';

GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; ------------ i think this is much better.