Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Trouble with multiple mysql databases
November 21, 2006, 7:48 pm
rate this thread
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
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,
Re: Trouble with multiple mysql databases
You may get better answers on the MySQL newsgroup comp.databases.mysql as it
seems to be entirely about MySQL permissions - or some sort of cPanel support
The brute-force method to fix it would probably be something like:
GRANT ALL PRIVILEGES ON db2.* to 'user1@%';
... from a suitably privileged MySQL connection.
Andy Hassall :: firstname.lastname@example.org :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum