I have the old classic "Error Establishing a Database connection" problem with the wordpress installation. I have already set up one blog with complete success using WordPress, then found when I tried to set up another using the same hosting company I encountered the "Error Establishing a Database connection" problem. After much searching on forums and speaking to my hosting company I have established the problem is that the "Client does not support authentication protocol", please see:
this is also referred to in resolved thread:
My problem is that I am a complete amateur and have never used MySQL, etc. Can anyone post an example copy of how the wp-config.php file should look in this circumstance and if there is anything I need to do other than amend this file?
Any help much appreciated.