PHP MySQLi query - “Permission denied”

问题:

Im using PHP MySQLi to connect to MySQL and sometimes doing query i get error:

"Permission denied" error code: 2002.

The strange thing is that it happens for different query's and totally unpredictable. For example it might happen on third query after first two executed correctly.

I know it is not problem with MySQL because i moved it from one server to another and problem still persists. Most likely problem with PHP or interconnection between PHP and MySQL servers (they're on different machines)

Anyone got ideas?

EDIT:
query what gets "Permission denied" works if i restart script - its not permissions problem

ERROR:

[23-Apr-2011 19:00:02] PHP Warning: mysqli::mysqli() [mysqli.mysqli]: [2002] Permission denied (trying to connect via tcp://xxx.xxx.xxx.xxx:3306) in /home/.../DB.php on line 19
[23-Apr-2011 19:00:02] PHP Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Permission denied in /home/.../DB.php on line 19

回答1:

Same things happened on my environment. And the cause was SELinux.

You might be able to connect the database by executing php from command line while you might not by executing on the web server.

In my case, I turned off SELinux.

# setenforce 0

Or you have to set up SELinux correctly.

回答2:

I think the database user do not have sufficient permission to make particular operation on particular mysql table.

回答3:

This isn't a permissions error. The client isn't able to get as far as connecting to the database, let alone trying to authenticate the user.

I suspect these problems will be being caused by either network problems (preventing the client/server machines from talking to each other) or the MySQL server process not running on the remote host.

The error code is documented here: http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html

回答4:

Check The Permissions for the user that you are connected through