Help with mysql - 2 databases with 1 user
Posted: Fri Oct 03, 2008 1:36 pm
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 very easy 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
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 very easy 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