I made a site on one server, and I'm trying to transfer it to another server.
But I'm having issues with the database and the database users.
I can't name the users the same thing because the different webhosts have their own systems/prefixes for databases and db users, and I can't alter them.
I don't know how to get the new server to import the old database! When I import the SQL file in phpMyAdmin I get the error:
#1044 - Access denied for user 'newuser'@'localhost' to database 'olduser_wrdp1'