mysql held needed

[bensd]

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!

Thanks in advance.

-Ben

 

[Paullas]

i would post this on the mysql dedicated forums as you will get free help there

 

[bensd]

Thanks Paul, i will try there.

 

[stender]

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?

 

[Skinner]

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.

 

[Admin]

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.

Agreed, 2 databases doesn't make much sense.

 

[bensd]

I don't know why it has two databases, it's not my script!