Yes root directory only, Please share error which you are getting.
on command : php bin/magento setup:upgrade
I get the error :
<br />
<b>Parse error</b>: syntax error, unexpected '{' in <b>/homepages/46/d204221203/htdocs/shop1/bin/magento</b> on line <b>13</b><br />
A server can use different PHP versions for the command line and for webserver.
Please ensure you have the proper PHP versions for the command line.
You can do it by executing the php -v command from the Magento 2 root folder.
https://devdocs.magento.com/guides/v2.3/install-gde/system-requirements-tech.html
That's the solution I can suggest for now, change url in core_config_data which you already done. Clear cache and run all shared commands. these the solution only and it should also work. If this is not working then compare localhost and production server.
No nothing has to change in .htaccess. Did you added any local url? if not then no need to change
Please do changes in db table core_config_data to remove version from css:
insert into core_config_data (config_id, scope, scope_id, path, value) values (null, 'default', 0, 'dev/static/sign', 0);
and run below query:
php bin/magento setup:static-content:deploy -f php bin/magento cache:flush