Access MySQL as user root

[plutus]

Hi,

I write an MBean DatabaseStatus that I'd like to manage with my JMX client. I wrote the following method:

public List showSlaveStatus(String rootPassword) throws BusinessException;

and I would like to make a mysql-connection to my DB as user root.

What are the steps I have to follow? I suppose it isn't very secure to define a datasource with user root and password in the deploy dir...?

<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>...</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>root</user-name>
rootPassword
</local-tx-datasource>

But what is a better solution?

[darranl]

This may help you: -

http://www.jboss.org/wiki/Wiki.jsp?page=EncryptingDataSourcePasswords

[plutus]

Sorry, doesn't really help. I don't want that other useres can access my "root datasource". I just want to make a "root sql session" _on demand_!

Isn't this possible in an elegant way?

[plutus]

no idea?