|
|
Posted by David on 11/21/06 19:48
Hi All,
I'm having trouble accessing multiple databases using a single user.
Basically, I have 2 databases, db1 and db2 and 2 users, user1 and user2.
Originally these were setup so that user1 would only access db1 and user2
would only access db2. However, now I want user1 to access both db1 & db2.
I've used cPanel to declare user1 as a user of db2. However, whenever I try
to access db2 from user1, I get permission problems.
I've tried various combinations of mysql_db_select(), mysql_query("USE
db2Name", $db1link) or just referencing the appropriate table as
'db2Name.tableName' in my SELECT querys but everytime I get a permission
denied response.
Any ideas?. It looks like a cPanel problem to me as it appears that user1 is
simply not being granted access to db2 despite telling cPanel to do so.
Ta in advance,
Dave
Navigation:
[Reply to this message]
|