Enjoy unlimited access to all forum features for FREE! Optional upgrade available for extra perks.

mysql held needed

Discussion in 'Scripts and Coding' started by bensd, Oct 3, 2008.

Thread Status:
Not open for further replies.
  1. bensd United Kingdom

    bensd Well-Known Member

    Joined:
    Jan 2007
    Posts:
    5,103
    Likes Received:
    79
    I am trying to run a script that needs one user with two databases.

    My hosting company have told me that i need to create 2 databases and 1 stand-alone user in my hosting cp, then with phpmyadmin i need to grant access from the 2 databases to the stand-alone user.

    I have been reading through the mysql website for ages and trying lots of things that don't seem to be working.

    I am sure this would be a piece of pi** for someone who knows what they are doing! Is there anyone who could give me step by step instructions, or if they were feeling really generous i can give them access to the cp and they could do it for me! :p

    Thanks in advance.

    -Ben
     
  2. Domain Forum

    Acorn Domains Elite Member

    Joined:
    1999
    Messages:
    Many
    Likes Received:
    Lots
    IWA Meetup
     
  3. Paullas

    Paullas Super Moderator Staff Member

    Joined:
    Jul 2004
    Posts:
    5,761
    Likes Received:
    200
    i would post this on the mysql dedicated forums as you will get free help there :)
     
  4. bensd United Kingdom

    bensd Well-Known Member

    Joined:
    Jan 2007
    Posts:
    5,103
    Likes Received:
    79
    Thanks Paul, i will try there.
     
  5. stender United Kingdom

    stender Well-Known Member

    Joined:
    Nov 2005
    Posts:
    2,501
    Likes Received:
    30
    What bit are you stuck on? I know how to create db's and users and how to assign a user to a db. Is that what you need?
     
  6. Skinner

    Skinner Well-Known Member

    Joined:
    Jul 2008
    Posts:
    4,616
    Likes Received:
    140
    Why 2 databases ?

    Surely 2 tables is easier to manage ?

    Switching databases makes joins and such nasty and messy and slower than a slowpoke.

    You would be better asigning one user to one database and use 2 tables to handle it.
     
  7. Admin

    Admin Administrator Staff Member

    Joined:
    Jun 2004
    Posts:
    11,120
    Likes Received:
    464
    Agreed, 2 databases doesn't make much sense.
     
  8. bensd United Kingdom

    bensd Well-Known Member

    Joined:
    Jan 2007
    Posts:
    5,103
    Likes Received:
    79
    I don't know why it has two databases, it's not my script!
     
Thread Status:
Not open for further replies.