Unable to setup mysql database connection with dreamfactory v2.2.0?

Connecting to SQL
1

Hello,

Last i used dreamfactory v2.1.2 but now i am using v2.2.0 version and facing issues while setting mysql database connectivity with its neweset version…
Can anyone tell me how to establish connection, any link with proper guide ?

Thanks.

1 Like
2

Hello @aamirk,

Can you answer the following questions so I can get more information in order to help troubleshoot this issue?

  • Are you using ‘localhost’ or ‘127.0.0.1’ in your host config?
  • Can you Telnet the database?
  • What is the error message you are receiving?

Any other details would help.

Thanks,
@AlexBowen

3

I am getting SQLSTATE[HY000] [2002] Connection timed out error.
You can see the screenshots for more details.

c.png960×541 22 KB

dd.png958×539 14.8 KB

Thanks @AlexBowen for your response.

1 Like
4

Ok, i got what i am doing wrong i.e, in “Host” i mentioned “mysql:host=localhost”.But it should be only “localhost”,

Now, i am getting new error “SQLSTATE[HY000] [1045] Access denied for user ‘df_admin’@‘localhost’ (using password: YES)”.

Please tell me how to resolve this error.
Thanks in advance.

1 Like
5

Hey @aamirk,

Can you confirm that your config db server has access rules set for you to access it?

Thanks,
@AlexBowen

6

Hey @AlexBowen

Yes, i gave all the privileges and access permission but still showing access denied using password yes.

Thanks,
@aamirk

7

Hey @AlexBowen

It was “127.0.0.1” instead of “localhost” In ‘Host’ feild.

Now, everything is working fine.

Thanks a lot for your help.

1 Like
8

I am glad to hear that you figured it out @aamirk! Thanks for also posting about how you resolved the issue.

Thanks,
@AlexBowen