I have an application that uses 3 databases and queries that span multiple databases. For this to work I require that a single db-user has access to all 3 databases. But when I create a database through Webfaction's control panel, it automatically creates a user that has access to only that newly created database and there seems no way to grant the user access to the other db's. Is there an easy way to fix this? I've tried to use MySQL's grant, but of course that doesn't work (need root user). Am I correct to understand that I will need to compile my own MySQL server for this to work? (And if so, what would be the best way to do this?) asked 28 Jun '12, 12:29 webtweakers |
Check out this related post about this same topic. answered 28 Jun '12, 14:05 timg ♦♦ |
Actually the GRANT solution as provided in this question does work. answered 30 Jun '12, 08:03 webtweakers |