Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

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.

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

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

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.

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

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

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

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.