PHP MYSQL Error in Hostgator

Discussion in 'PHP' started by millst2, May 21, 2006.

  1. #1
    I was browsing through here and didnt really see what I was looking for. So I will ask u professionals./

    I log into my HOSTGATOR Acct and go to domain name and then click on the DB's. I see this error that states...

    Connection Strings
    Perl $dbh = DBI->connect("DBI:mysql:limminy_snickets:localhost","limminy_lumpy","<PASSWORD HERE>");
    PHP $dbh=mysql_connect ("localhost", "limminy_lumpy", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
    mysql_select_db ("limminy_snickets");

    --------------------
    Whats not making since is that the script being used has not changed or been tampered with, but just the other day the sites pages was dropping in the G index, and when I go to take a look, the DB is not working right.

    Any Ideas of the fix,, the user and pass have remained the same, but it looks like this is a Password issue! Correct? I have tried to create a new user and grant priveleges to the db but that didnt help either.

    Any help is appreciated.
    Mill:confused:
     
    millst2, May 21, 2006 IP
  2. TheHoff

    TheHoff Peon

    Messages:
    1,530
    Likes Received:
    130
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I don't see a database error? Just the connection strings.
     
    TheHoff, May 21, 2006 IP
  3. millst2

    millst2 Guest

    Messages:
    292
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Not to familiar with that.

    where do i go to view the connection strings? or change them? or is that even something I could do myself, or would I have to contact the host?

    Thx in advance
    Mill
     
    millst2, May 21, 2006 IP
  4. GeorgeB.

    GeorgeB. Notable Member

    Messages:
    5,695
    Likes Received:
    288
    Best Answers:
    0
    Trophy Points:
    280
    #4
    You're not making a bit of sense (it's sense by the way not "since").

    Logged into what? your Cpanel account? WHM?

    Are you seeing these errors in your cpanel account or in your site's code?

    You need to describe your problem better.
     
    GeorgeB., May 21, 2006 IP
  5. millst2

    millst2 Guest

    Messages:
    292
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I logged into my Cpanel..

    Not in the sites code, when I click on the mysql db it is showing me this error.

    Oh yeah thanks for the english lesson, aint it funny what people read in someones post!

    Mill
     
    millst2, May 21, 2006 IP
  6. TheHoff

    TheHoff Peon

    Messages:
    1,530
    Likes Received:
    130
    Best Answers:
    0
    Trophy Points:
    0
    #6
    When you're logged into your CPanel and you click on the database, it is showing you the connection strings that you use to connect to the database. There is no error there.

    Have you clicked on the PhpMyAdmin link on that page? Maybe that is what you're looking for.
     
    TheHoff, May 21, 2006 IP
  7. millst2

    millst2 Guest

    Messages:
    292
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #7
    so I guess I may have the wrong issue then, i have a db full of maps, but if i go to the site and click on one of the maps, it says the page doesnt exist. So I guess being the php/sql newb I am I just figured it was that error when I view the mysql db's in cpanel.

    well i guess it is something else then. I have viewed the DB's and they do have the info in them, but I guess something else is screwed up since it is not pulling them up when the links are being clicked.

    Back to the drawing board. Process of elimination continues.

    Many Thanks
    Mill
     
    millst2, May 21, 2006 IP