Change WHMCS URL via SSH

[PSELFEXT 0]

I changed WHMCS URL via the browser from http to https and now I cannot access it. How do I change it back without using the browser. Please let me know the full procedure.  Than you.

[WHMCS SamP 12]

Hello @PSELFEXT

Log in to your WHMCS database management panel (i.e. phpMyAdmin) > Select your WHMCS database > and run this SQL query replacing `https://www.yourdomain.com/whmcs/` with the actual path to your URL

UPDATE tblconfiguration SET value='https://www.yourdomain.com/whmcs/' WHERE setting='SystemURL';