first time installing wordpress manually instead of one-click
The host's one-click installer keeps failing so I'm doing it by hand: upload the files, create the database, run setup. Stuck at 'error establishing a database connection'. Which details usually trip people up in wp-config?
It's easier than it sounds. Create a database and a database user in your hosting panel and give that user all privileges on it, upload the WordPress files to the folder the domain points at, then visit the site in your browser and the installer asks for those database details and writes wp-config.php for you.
The part that catches people out afterwards is file ownership. If WordPress asks for FTP details every time you try to install a plugin or update, the files are owned by a different user than the one the web server runs as. Ask the host to fix ownership rather than setting everything to 777.