Access denied for user 'nobody'@'localhost' (using password: NO) <--How to fix this?

Discussion in 'MySQL' started by eaOn, Jun 3, 2009.

0
  1. #1
    Hi I'm new and got a problem that I can't seem to fix. I'm still to new databases and was planning to create a dynamic site. I made a Google search and found this entry 
    http://forums.digitalpoint.com/showthread.php?t=929836
    Code (markup):
    but sad to say, It didn't help me much.

    I always get this PHP error:
    Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/a9497623/public_html/Connections/eaon.php on line 9

Fatal error: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/a9497623/public_html/Connections/eaon.php on line 9
    Code (markup):
    It runs fine in my WAMP. I can view page with no error. The problem start when I upload my html directory and my databases. I also followed their instruction like changing the MySQL server, user, and pass. I use their file manager to upload my php, images folder, inlcudes folder, and Connections folder. I also imported my table on a database named, "a9497623_eaOn".

    My hosting site www.000webhost.com and my domain name is http://www.eaon-webworks.co.cc/
    I design in dreamweaver CS4 and relies on their PHP scripts because building a site their is fast. I'm still poor at debugging but I can tell it can be easily fix I just don't know. I hope someone could help me.
     
    eaOn, Jun 3, 2009 IP
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    It appears the application is trying to login without a password, "... (using password: NO) ..." Check eaon.php again, make sure the password is set and correct.
     
    Social.Network, Jun 3, 2009 IP
  3. eaOn

    eaOn Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I think finally got it to work.

    I just added a new PHP script and added this: 
    define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'XXXX');
define('DB_SERVER_PASSWORD', 'XXXX');
define('DB_DATABASE', 'XXXX');
    Code (markup):
    Then I let it include on my index.php.

    From what I understand, he wants me to set a user and pass for my database because it has none. I also corrected my entries in the eaon.php.

    My site can now be viewed (http://www.eaon-webworks.co.cc/). My data entry for my "News and Update" seems to work now. There is still too much work to do though. I just hope I don't expect errors anymore because this had me thinking for the whole day.
     
    eaOn, Jun 3, 2009 IP