The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

error message

Discussion in 'Database Discussions' started by robthong, Nov 9, 2003.

  1. robthong

    robthong Registered

    Joined:
    Sep 21, 2003
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    i keep getting the following message as i try to log onto my site, as does eveyone,

    Warning: mysql_pconnect(): Access denied for user: 'root@localhost' (Using password: NO) in /home/robthong/public_html/common.php on line 24

    Access denied for user: 'root@localhost' (Using password: NO)

    now i think ive iether overwriten or edited common.php in some way?, is this a file that would be there from the start?, and is there a way to replace it with one that works,

    this is all german to me, so any help would be great

    many thanks

    rob
     
  2. n1tr0

    n1tr0 Member

    Joined:
    Apr 18, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NY
    Same Question as above

    I'm having this same prob but the error is on line 9.
    Here's trhe whole thing:

    Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'eyead'@'localhost' (using password: YES) in /home/eyead/public_html/checkthespot.com/Connections/cts_connection.php on line 9

    Fatal error: Access denied for user 'eyead'@'localhost' (using password: YES) in /home/eyead/public_html/checkthespot.com/Connections/cts_connection.php on line 9

    Any help is greatly appreciated
    Thanks
     
  3. chandro

    chandro Well-Known Member

    Joined:
    Nov 21, 2005
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    /home/chandro
    cPanel Access Level:
    Root Administrator

    same for you, check on the cPANEL domain, on MYSQL section, check if that database and user exists.

    if the database is named "thespot" then in the config must be

    database "eyead_thespot"


    USERNAME_DATABASE
     
  4. chandro

    chandro Well-Known Member

    Joined:
    Nov 21, 2005
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    /home/chandro
    cPanel Access Level:
    Root Administrator


    as you can see the error, user ROOT has access denied to mysql

    why???

    because if you setup a site like www.mihost.com.mx then user to mysql must be "mihost",or the one you specify on WHM, check user and put password. that error show USING PASSWORD "NO"
     
  5. n1tr0

    n1tr0 Member

    Joined:
    Apr 18, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NY
    Clarification

    OK, I dont think I made my question clear enough. Sorry for that.
    Here's my attempt to make it clear...

    When ANYONE tries to go to my site, they get the following error:

    Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'eyead'@'localhost' (using password: YES) in /home/eyead/public_html/checkthespot.com/Connections/cts_connection.php on line 9

    Fatal error: Access denied for user 'eyead'@'localhost' (using password: YES) in /home/eyead/public_html/checkthespot.com/Connections/cts_connection.php on line 9


    The databases I have are EYEAD_CTS and EYEAD_CTSCHAT
    When I looked at the "cts_connection.php" file, I found this:

    <?php
    # FileName="Connection_php_mysql.htm"
    # Type="MYSQL"
    # HTTP="true"
    $hostname_cts_connection = "localhost";
    $database_cts_connection = "eyead_cts";
    $username_cts_connection = "eyead";
    $password_cts_connection = "correct password here";
    $cts_connection = mysql_pconnect($hostname_cts_connection, $username_cts_connection, $password_cts_connection) or trigger_error(mysql_error(),E_USER_ERROR);
    ?>


    I constructed this site using DreamWeaver CS3
    PS...when I change the page to HTML, everything works fine.
    Could this be a .php prob???

    Thanks for your help Chandro
     
  6. chandro

    chandro Well-Known Member

    Joined:
    Nov 21, 2005
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    /home/chandro
    cPanel Access Level:
    Root Administrator
    the databases are in lowercase or upercase? also if eyead_cts dont work, try with eyead_ctschat
     
  7. n1tr0

    n1tr0 Member

    Joined:
    Apr 18, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NY
    lower case db names ofcourse...sorry...I wrote it on upper so it can stand out.
    I did find a problem in the index.php code. It was not setto "public" view so I changed it manualy to read:
    <?php /*?><?php virtual('/public_html/Connections/cts_connection.php'); ?><?php */?>


    Then I got a dif. error when I tryed to view he site...
    Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/eyead/public_html/checkthespot.com/index.php:3) in /home/eyead/public_html/checkthespot.com/index.php on line 35

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/eyead/public_html/checkthespot.com/index.php:3) in /home/eyead/public_html/checkthespot.com/index.php on line 35

    Now I'm searching for the problem there...
    <----pulls hairs out!
     
  8. chandro

    chandro Well-Known Member

    Joined:
    Nov 21, 2005
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    /home/chandro
    cPanel Access Level:
    Root Administrator
    looks like a php limits.
     
  9. n1tr0

    n1tr0 Member

    Joined:
    Apr 18, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    NY
    Yeah, the prob DEFINATELY has to do with DW's server behavior settings.
    I think I'll go back to the drawing board with this site and start from scratch. There are a few things I want to do that I have to learn on DW, or maybe I'll just say F*&# it and go to JOOMLA.
    Thanks for yor help Chandro!
     
  10. hbidad

    hbidad Well-Known Member

    Joined:
    Apr 16, 2005
    Messages:
    74
    Likes Received:
    1
    Trophy Points:
    8
    $username_cts_connection = "eyead_eyead";
     
Loading...

Share This Page