MySQL data source not allowing changes

Hi,

My issue is the same as discussed in http://forum.devolutions.net/topic2419-mysql-data-source-completely-broken.aspx although the suggestion solution won't work in my case.

I started using MySQL for storing session information in versions of RDM previous to the release that required the schema update (providing multiple users with different roles). The database and database user were created on the server (not using RDM), appropriate permissions given (pretty much everything but GRANT). I configured RDM to use the database as a data source successfully, imported all my sessions and all was good. :-)

When I upgraded to the version requiring the schema update all seemed to be working fine. However I have discovered that RDM does not consider my only database user as an administrator and therefore I'm locked out of many functions. Currently the UserInfo table is indeed empty.

The solution of connecting to the database as root will not work as the MySQL server that I'm connecting to runs several production databases... connecting as the root user from an application isn't going to happen. Does RDM manager rely on the "root" user name to be able to initially populate the UserInfo table or can any user name with appropriate permissions on the server for the RDM database work? I haven't been able to get it to work so far.

Is there any other way I can populate the UserInfo table with my RDM user and give it appropriate admin permissions so I can use the RDM administration features to manage RDM users? A SQL script would be great. I just do not know what values to put in the appropriate tables.

Ideally when doing an upgrade to the schema adding support for multiple RDM users, it would be nice to be given the option to make the current user configured in the data source the administrator user in the database.

I can direct message the database source info if it helps.

Cheers.