Access denied for user 'ssh-user'@'localhost' (using password: NO)

Hello All,

I need your feedbacks on the below message which I am seeing these days in my apache error_logs (/usr/local/apache/logs/error_log). I have script in place which when executed in the browser, gives me the message,

PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Access denied for user 'ssh-user'@'localhost' (using password: NO) in /home/example/public_html/test1121x11.php on line 14

I have no issues with this error and it is something which I am expecting because the mysql_connect query is getting called without any user/host/password details. So ideally it should either user apache user which is nobody or should be blank. But here, it is taken as ssh-user having wheel group (i use this user for doing su - as root with wheel group)

Any idea why this is happening. When putting this same script in another server and calling via browser, I get the expected output which is, Access denied for user 'nobody'@'localhost' (using password: NO).

I can confirm that when checking the phpinfo() of the server, mysql.default_user is set to "no value" and also, apache is run as user nobody when I am checking ps aux

Can someone suggest what is the issue here?

Thank you.

Regards,
K.

 

Hello Michael,

Thank you for the response.

I can confirm that in both the server I have the following setting.

Default PHP Version (.php files) 5
PHP 5 Handler dso
Apache suEXEC on
Apache Ruid2 off

One server gives me output Access denied to 'nobody'@'localhost' and in another it gives me the output Access denied to 'ssh-server'@'localhost'

NOTE: ssh-user is not the user of the account (domain), but a normal user which I created using `useradd` for doing su - (as direct root access is disabled)

Any clue why this is ?


Regards,
K.

 

Hello Michael,

Both are installed with Apache 2.2.x and PHP 5.3.x. However OS for the working one (which thows as nobody) is CentOS 5.11 and the other (which throws as ssh-user) is CentOS 6.6

Just a quick note. When I access the same script using browser from a CentOS 6.6 / PHP 5.5.x / Apache 2.2.x server, it gave message "Access denied to ''@'localhost'. Which also seemed fine.

Regards,
K.