Hi, I'm still pretty new at this and have got myself in a bit of a bind.
I was trying to upload a locally hosted new website to replace an existing site at http://www.creativeloop.org. Following instructions at [ http://www.wpbeginner.com/wp-tutorials/moving-a-wordpress-installation-from-local-server-to-a-live-site/ ] I renamed the "WordPress Address" and "Site Address" in the general settings of the local site to match the live site (www.creativeloop.org).
This didn't go well, as I couldn't log in to either site.
I've restored access to my local site via phpMyAdmin, but I can't access my live site's dashboard. I've tried following instructions to add a new user in the SQL database [ http://www.wpbeginner.com/wp-tutorials/how-to-add-an-admin-user-to-the-wordpress-database-via-mysql/ ] but at [ creativeloop.org/wp-admin ] the new user isn't recognised and the original passwords for existing users 'do not match'. The reset password via email option isn't playing ball either.
So I'm locked out and I think I've exhausted options to regain access. Or have I?
If I was to delete all contents of my public_html folder via FTP would I just be able to do a fresh install of WP on my live server and upload my localsite and progress from there?
I'm not confident that it'll work, and my old-live site is still active and viewable.
Any help would be appreciated, I'm not sure how to progress.