Mac OS X Designer.app

[Chan Kuan Leang]

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.

[Andrew]

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.

[Chan Kuan Leang]

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

Code: Select all

server=worldsoftllp.com;port=3306;database=worldso1_worldsoftstaging;user=worldso1_test;password=qaz123!@#;

[Chan Kuan Leang]

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?

Code: Select all

server=localhost;port=3306;database=worldso1_worldsoftstaging;user=worldso1_test;password=qaz123!@#;

[HighAley]

Hello, Chan.

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

Thank you.

[Chan Kuan Leang]

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

[HighAley]

Hello.

Yes, such connecting string works on our testing machines.

Thank you.

[Chan Kuan Leang]

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?

[HighAley]

Hello, Chan.

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

Thank you.

[Chan Kuan Leang]

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.