mysql data source completely broken

the fix is available here:

http://remotedesktopmanager.com/download/Devolutions.RemoteDesktopManager.Bin.8.0.11.0.zip

Hi,

this fix doesn't work. it is the same behavior as before.

Kind regards,
Pyloor

I will have a look

@pyloor

Could you please direct message me with a screen shot of File->My Data Source Information.

Thanks

Are you connecting with root? If not, please connect with root, edit the other user, click ok (save). Now try connecting with that user. Did that fix it?

Hi there,

i have switched to xml file. the case can be closed. the datasource mysql is still not working and i need for my daily business a working datasource.

kind regards

I have the same problem with Mysql and version 8.0.11.0 Enterprise. I can't add a new entry, folder.. anything

@remsad

Are you connected with root? Is MySQL running on Windows or a Unix based system?

Could you please direct message me with a screen shot of File->My Data Source Information.

Can't wait to get this resolved once and for all.

@Stéfane Lavergne

Je suis connecté avec un compte non-root avec toutes les permissions sur la base de données. Je vois que RDM ajoute des données dans les tables mais je n'ai pas l'option "newEntry" de disponible.

@Stéfane Lavergne
Une information manquante, le serveur Mysql est comme ceci:

Server version: 5.1.57
Centos

@remsad

Was the user "rdm" created by manually or through the RDM admin screen?

Can you send me, via private message, the result of the following query, I suspect that the table is empty?

SELECT * FROM UserInfo;

If the result is indeed empty, change your data source connection to use the root user. Save, now got to the user admin screen (Administration -> Users), and add the user "rdm", make sure you mark it as "Administrator" this will populate the UserInfo table with the appropriate rights. Now change the data source to use the "rdm" user. All should be ok now.

@Stéfane Lavergne

The solution works for now. What is the difference between mysql user created by RDM and mine?

The only difference I can see is : "reload privilege" as global privilege

it has the access privileges/rights that govern RDM security settigs (add, edit, new...), hence the UserInfo table within the RDM schema.

As for the "reload privilege" it's needed since when you are admin of RDM you can create/delete users. When doing so reloading the privileges is required in some cases.