One user with access to multiple databases

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?)

multiple-databases single-user mysql

asked 28 Jun '12, 12:29

webtweakers
11●1●4
accept rate: 0%

2 Answers:

active answers oldest answers newest answers popular answers

0	Check out this related post about this same topic. permanent link answered 28 Jun '12, 14:05 timg ♦♦ 1.3k●4 accept rate: 30%

0	Actually the GRANT solution as provided in this question does work. permanent link answered 30 Jun '12, 08:03 webtweakers 11●1●4 accept rate: 0%

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

mysql ×168
multiple-databases ×3
single-user ×1

question asked: 28 Jun '12, 12:29

question was seen: 4,921 times

last updated: 30 Jun '12, 08:03

One user with access to multiple databases

Follow this question

Related questions