Please Help!

Discussion in 'MySQL' started by bubba, Jun 15, 2007.

  1. #1
    My problem is I go to mySQL and create a database (wall) and create a

    user (bubba) and password I then assign all privileges.

    I goto install.php fill in the info and hit enter.

    I get the following:

    ---------------------------------------------------------------------------
    Comments script installation process
    Connecting to mysql ...
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dtdtampa_bubba'@'localhost' (using password: YES) in /home/dtdtampa/public_html/comments/install.php on line 174

    Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/dtdtampa/public_html/comments/install.php on line 175

    The following errors occured:
    Access denied for user 'dtdtampa_bubba'@'localhost' (using password: YES)
    ------------------------------------------------------------------------
    I go back to mySQL and copy the php code under the database I created:

    --------------------------------------------------------------------------
    $dbh=mysql_connect ("localhost", "dtdtampa_bubba", "<dtdtampa_PASS>") or die ('I cannot connect to the database because: ' . mysql_error());
    mysql_select_db ("dtdtampa_wall");
    ------------------------------------------------------------------------

    I then ad the php tags and save it as test.php and then run it, I get this

    message:
    ------------------------------------------------------------------------

    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dtdtampa_bubba'@'localhost' (using password: YES) in /home/dtdtampa/public_html/test.php on line 2
    I cannot connect to the database because: Access denied for user 'dtdtampa_bubba'@'localhost' (using password: YES)
    ----------------------------------------------------------------------

    since I use the generated code for the mySQL I am think server my not have the correct permissions set.

    Please any input?

    Thanks,
     
    bubba, Jun 15, 2007 IP
  2. rthurul

    rthurul Peon

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I do not think this will help but make sure that you enter the password you selected :)

    BTW you did not created the database wall BUT dtdtampa_bubba and same for the user.. You are probably using cpanel for this and this is how they get transformed

    If it still does not work try doing it at database level
     
    rthurul, Jun 16, 2007 IP
  3. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #3
    remember, if you are on dreamhost, you can NOT use localhost. You have to create a sub-domain, and use that as your connector.
     
    ccoonen, Jun 16, 2007 IP