Creating reports and dashboards | Stimulsoft community forum

I have try the new version of the designer.app for Mac OSX,

Currently I am facing with this problem using my local database in my mac.
The tables does not load even though my connection to mysql is successful.

Dear Chan,

We are trying to reproduce the error but still canot do this. Perhaps you have additional information on this issue.

We will immediately let you know when we have additional information.
Thank you.

Can you try this, once you have done with it, I will disable this user right.

Very interesting.. It is working now for that server.
But localhost, it is not working.

For connection to localhost, the below code is correct right?

Hello, Chan.

Sorry, but we have no access to your database.
Please, check the access privilege on your MySQL server.

Thank you.

Sorry, I am referring to format for connecting to local database.

Hello.

Yes, such connecting string works on our testing machines.

Thank you.

I think I found the reason why i cannot connect to my localhost. After some testing, I think it is because i am using an user account (I am using root account in my MariaDB) that can access to multiple databases in my MariaDB.

Once I create an user account that can only access to single database, I can access to my local database already.
Is this a bug? Or is it meant to be this way?

Hello, Chan.

I seems that you should refer to MariaDB settings.
Please, check the privileges of your user.

Thank you.

I have no idea. Cos when I use a user with multiple database access (example Database A, B, C, D), my tables not able to load. The loading gif keeps on moving endlessly..
But, when I use a user that have only 1 database access (example Database B only), the tables was loaded instantly.

As least it works for me this way at this moment.