I changed the alias setting from canonical to redirect in the admin settings and now I can't get to my site because I get a redirect loop.
Hostname Example: mysite.temporary.whatever.com/myfolder
There is no trailing slash but the site is in a subdirectory so I have to have a slash after the domain.
How can I change the alias setting back to canonical if I can't get to the site at all now? SQL command maybe?