WebFaction
Community site: login faq

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
1114
accept rate: 0%


Check out this related post about this same topic.

permanent link

answered 28 Jun '12, 14:05

timg ♦♦
1.3k4
accept rate: 30%

Actually the GRANT solution as provided in this question does work.

permanent link

answered 30 Jun '12, 08:03

webtweakers
1114
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×168
×3
×1

question asked: 28 Jun '12, 12:29

question was seen: 4,921 times

last updated: 30 Jun '12, 08:03

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM