Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress Local WordPress Development Local WordPress Development Migrating WordPress from Local to Live Server

JUSANG YOU
JUSANG YOU
7,857 Points
Posted by JUSANG YOU
JUSANG YOU
7,857 Points

Error establishing a database connection

After I caught and follow up this lesson, I am not able to log on my live site and Browser prints "Error establishing a database connection" msg. Could anyone tell me checkelists to fix this problem? I changed the name of the database ,username for live sercer correct and added database Collate types. I checked these twice repeating these lessons. This is so desperate.

Mark Filter
Mark Filter
32,718 Points

What hosting service are you using? What are you using for FTP? Are you accessing your database and making edits using PHPMyAdmin?

Mark Filter
Mark Filter
32,718 Points

Also, have you made the required edits to the wp_config.php file for updating your server information and directed your home URL?

JUSANG YOU
JUSANG YOU
7,857 Points
JUSANG YOU
JUSANG YOU
7,857 Points

I am using Go daddy hosting service and FileZilla. Yes, I did same as video I made edits using phpMyadmin and also update my server information for database,username and WP_HOME,WP_SITEURL in wp-config.php in FTP. I also believe there is something wrong informationsat wp-config.php.But, really have no idea which information I have to check and try again.

Mark Filter
Mark Filter
32,718 Points

If you are using GoDaddy, you will need to connect using SFTP. The process will also differ depending on if you are using a standard shared hosting plan or a Managed WordPress hosting plan. I think that your issue is with the encryption that GoDaddy uses to establish secure FTP. There should be a file that you will need to download and then install into Filezilla to establish the correct secure connection. Then, your SFTP should work properly. It is a bit of a headache for sure! Hopefully the link below will help you.

https://support.godaddy.com/help/article/104/connecting-to-your-hosting-account-with-filezilla-ftp?locale=en

JUSANG YOU
JUSANG YOU
7,857 Points
JUSANG YOU
JUSANG YOU
7,857 Points

Thanks, Mark! Your kind and thoughtful answer was really helpful to fix my problem. I appreciate it. !

Mark Filter
Mark Filter
32,718 Points

That's what its all about. I am glad you were able to get it figured out. (-; Document the problem and the solution so that you have a reference for it in the future. You never know, you might bump into it again if you ever work for a client or for a company.

JUSANG YOU
JUSANG YOU
7,857 Points
JUSANG YOU
JUSANG YOU
7,857 Points

Omg, I've really met master at World of web. I really want you to be my Master, Mark. I never thought about Documentize my trial and error before. That's a really good habit to be a solid developer. As a beginner, It is a really good advice. Thank you, so much.! Hope to see you again with another problem, soon.