I want to import an existing WordPress website and I want to keep using the wp-config.php file from the website for easier deploy. So I went ahead and renamed the database in Adminer which works, however I’m unable to change the user in any way without breaking the whole instance.
If I change the password of root, Adminer will break and I will have no access, even when I paste the right password. When I leave root as it is and try to add another user, it works, but the WordPress site will be unable to connect via mysql giving a Connection Refused response.
Is it meant to be this way? Do I have to use the wp-config.php from LocalWP, instead of the one from the live version? This is very inconvenient to be honest.