phpprobid auction script install trouble - mysql related

Discussion in 'MySQL' started by SVentures, Mar 8, 2008.

  1. #1
    I actually have a problem with phpprobid auction script install.

    I set up the MySQL database in my CPanel ->
    created the database: items
    listed as: fashiona_items
    added the user to it: fashiona_derek
    password: derek

    Now I get the message when I put the stuff into the online database setup:
    The connection to the database server was established successfully.
    Error: Could not connect to the database items.

    Why can't I connect using the install included with the product and what could be wrong? I know the password is right. Am I filling out the install form wrong?
     
    SVentures, Mar 8, 2008 IP
  2. malek256

    malek256 Peon

    Messages:
    90
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Most CPanel based systems prefix your db name with your user account. So hack the config file to point to fashiona_items instead and you should be good to go. I built up a heavily customied PHP Pro Bid before, linked it to VBulletin, etc. about 2 years ago.

    Careful - there are a number of bugs you may find, especially with browser versions for the guys adding listings. Good luck.

    And now - PLEASE IMMEDIATELY change your db user and db password - and make the password something tough to guess, NEVER a name or single word!
     
    malek256, Mar 8, 2008 IP
  3. SVentures

    SVentures Active Member

    Messages:
    194
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    78
    #3
    But...I need to be able to enter the correct database settings on this install page attached before the site will work, so it will set up properly (a clean install). How exactly do I type it in, given the username, database name and password above?

    [​IMG]
     
    SVentures, Mar 8, 2008 IP
  4. malek256

    malek256 Peon

    Messages:
    90
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Things to check:

    Tables Prefix may need to be 'fashiona_'

    Did you set db user permissions? Just creating a user is not sufficient.
     
    malek256, Mar 18, 2008 IP