SQLSTATE[HY000] [1045] Access denied for user 'df_admin'@'localhost' (using password: YES)

Connecting to SQL
1

I created database ‘dreamfactory’ in mysql and connected it with dreamfactory platform but when i tried to fetch and upload tables in mysql db ,the access denied error occurred. Mysql running on port 3306 in my system .See some screenshot of connection and database. I am using Ubuntu Os.

1 Like
2

you did not include the referenced screenshot in the post

1 Like
3

Hey @aamir_rais, We’d love to help! Please upload your screen shot so we may reference it. Also, if you’ve figured it out or found a workaround, please post it for the community.

Thank you,
@AlexBowen

4

Sorry, i missed to upload screenshots.
Now, i uploaded it.

Screenshot from 2016-07-01 18:11:04.png958×538 13.8 KB

Also, i am confused in Password field, the password should mysql database password or something else.Actually, i am beginner so i am not able to make connection.

Thanks for your response.

5

ok, I resolved it very early but now describing now how it done. Basically, by changing in “Host” as “127.0.0.1”.

Thanks,
@aamir_rais

1 Like
6

Glad to hear you solved it @aamir_rais. Thanks for posting your answer!

Thanks,
@AlexBowen

7

HI AAMIR,
Im also confused with that please let me know what is the password to be given.
Thanks,

8

@Praveen_BM_Reddy the password in the screenshots shown above should be your SQL password.

9

If you’re experimenting with DreamFactory and would like to generate your first database-backed API, I suggest reading chapter 3 of our guide, “Getting Started with DreamFactory”:

https://guide.dreamfactory.com/docs/chapter03.html

This guide walks you through the database API generation process, and then presents a series of detailed examples demonstrating the many ways in which you can interact with the API. Also consider watching the videos over at DreamFactory Academy:

https://academy.dreamfactory.com/