Jump to content

Archived

This topic is now archived and is closed to further replies.

kilx

access denied for user 'apache@localhost'

Recommended Posts

i got below message on my server..

 

i don\'t use user \'apache\' to connect to mysql but this error mention that acces denied for user \'apache@localhost\'. what exactly happen to my server...

 

i have a config file store my database parameter like username, password define like below syntax

...
define(\"DB_USERNAME\", \"username\");
define(\"DB_PASSWORD\", \"<password>\");
define(\"DB_HOST\", \"localhost\");
...
[code]
then i make mysql connection using the defined value..
[code]
...
mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD)
...

 

The error code!

Warning:  mysql_query(): Access denied for user: \'apache@localhost\' (Using password: NO) in /home/httpd/vhosts/minddivine.com/httpdocs/cssPortal/includes/functions/sessions.php on line 37
 
Warning:  mysql_query(): A link to the server could not be established in /home/httpd/vhosts/minddivine.com/httpdocs/cssPortal/includes/functions/sessions.php on line 37
 
Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/minddivine.com/httpdocs/cssPortal/includes/functions/sessions.php on line 38
 
Warning:  mysql_query(): Access denied for user: \'apache@localhost\' (Using password: NO) in /home/httpd/vhosts/minddivine.com/httpdocs/cssPortal/includes/functions/sessions.php on line 43
 
Warning:  mysql_query(): A link to the server could not be established in /home/httpd/vhosts/minddivine.com/httpdocs/cssPortal/includes/functions/sessions.php on line 43

Share this post


Link to post
Share on other sites

Check the table \"user\" under MYSQL database . See if you have a user names \'apache\' and check if you had set any password for it. Generally passwords are encrypted and if you cant make out them you can flush them out or create new user. Check the manual for more details

http://www.phpfreaks.com/mysqlmanual.php

Share this post


Link to post
Share on other sites

what to do if i have a \'apache\' user..? do i need to delete or what..?

thx!

Share this post


Link to post
Share on other sites

you have

 

mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD)

 

 

should it not say

 

mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD);

 

 

or did you just omit that in the forum

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.