MySQL Forums
Forum List  »  Router & Proxy

Choosing backend based on username
Posted by: Arnold Daniels
Date: December 03, 2007 03:53PM

Hi,

I would like to choose a backend server based on the connecting user.

I have an SSH sandbox which serves as shell environment for several servers. On these servers the MySQL database is on localhost. People are surprised when a script doesn't working in the SSH environment where is does work using HTTP, which happens when using localhost as db hostname. I want to use MySQL Proxy to solve this problem.

The backend MySQL server can be decided based on the username, however this seems to be out of sequence. Function read_auth is called after connect_server.

How can I retrieve the username before connecting to the server?

Options: ReplyQuote


Subject
Views
Written By
Posted
Choosing backend based on username
3154
December 03, 2007 03:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.