XAMPP-表'users'的用户'@'localhost'的SELECT命令被拒绝 [英] XAMPP - SELECT command denied to user ''@'localhost' for table 'users'

问题描述

不久前，我删除了XAMPP中的某些功能，并弄乱了.

Awhile back I deleted and messed around with some functions in XAMPP.

我重新安装了它，并用其他所有文件移动/重命名了我的文件夹，所以现在我有了一个新的xampp目录，它是空的和新鲜的.

I reinstalled it and moved/renamed my folder with all my other files so I now have a new xampp directory that's empty and fresh.

但是，当我尝试使用任何数据库功能时，会出现以下错误:

But when I try to use any database functionality it gives me error(s) like the one below:

SELECT command denied to user ''@'localhost' for table 'users'

怎么了?

谢谢.

推荐答案

未授予用户读取表的权限.

The user has not been given privileges to read the tables.

通过主机的面板为数据库创建用户时，可以授予该用户特权.

When creating an user for the database through the cpanel of your host, you can give the user the privileges.

或阅读本文档以通过MySql命令进行操作，

Or read this documentation to do it through MySql command,

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

这篇关于XAMPP-表'users'的用户'@'localhost'的SELECT命令被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！