Set up the database on my host
Create it, connect to it, and keep the password out of the code.
My app is built with <stack> and hosted on <host>. It needs a <database type> database. Walk me through it on this host: - Creating the database and a user with only the permissions the app needs. Not an admin account. - Where the connection details go, outside the web root. - Connecting from my code, with a clear error if it fails. - Creating the tables from a script I keep in the repo, so I can rebuild them anywhere. - How to take a backup and restore it, and how to test that. Show me the connection code and the table script.
Give the app its own database user with limited rights. If the app is ever compromised, that's the difference between leaking a table and losing the lot.