So picture a regular Hostgator or similar account: everything done through Cpanel, a normal shared hosting website. There are static pages on the site, as well as an application (say Wordpress for instance) that relies on a mysql database.
Is there a way to move that website to a different host while keeping the same mysql users, and thus not breaking the application?
I mean, I can move the files via FTP, I can backup the database using phpMyAdmin and restore to the other server, but if it's assumed that I don't have access to whatever the original mysql user's password is, how can I switch hosts without breaking the application?
All the best!