Change a WordPress theme with SSH

Generic selectors
Exact matches only
Search in title
Search in content
Filter by Categories
Account Management Help
add photos, video and audio
Add-on features and social media
Advanced
Advanced campaign settings
All about analytics
All about images
Basic steps
Calendar
Configure the Web Application Firewall (WAF)
Connect my Calendar and Online Storage to Workspace
contact support
copy files to my site
Create my email address
Customize campaign
Discover domains
discover linux hosting with cPanel
Discover Microsoft 365
Discover Online Storage
Discover Workspace Email
edit content
Email Marketing demo
expand your site with sections and pages
Explore email add-ons
Explore my account
Find server and port settings (IMAP/POP)
fine tune my website
get social
Get started with SSL certificates
Get the most out of Microsoft 365
help my site get found and monitor my metrics
Hosting & Servers
keep my account secure
Keep my email secure
know your privacy rights
Legacy
Manage your SSL certificate
Managed WordPress
Manual email configuration
Migrate and export my emails
My email account isn’t working (troubleshooting)
nameservers and DNS
online store
organize
parking, forwarding and monetizing
privacy and protection
publish my site
Quick Shopping Cart
Renew my products and services
renewals
Security
Set up a campaign
Set up email on my devices
set up my payment methods
Set up my Workspace Email account
start with the basics
Stay productive anywhere with Office apps
Streamline email tasks to help my business
transfer between accounts
transfer between registrars
Troubleshoot email and email setup
Troubleshooting
troubleshooting
Uncategorized
Upgrade and renewal options for email
Web & Classic Hosting
Website backups
Website Builder 7
Website Builder version 6
Website Security and Backups
Websites
work with databases
work with delegates
working with blogs

You can change the currently active theme from within SSH. This is a more advanced method, but can be more efficient for developers who manage multiple WordPress sites.

Warning: The information in this article is advanced material we make available as a courtesy. Please be advised that you are responsible for properly following the procedures below. Customer Support can’t assist with these topics.

  1. You should always backup your site before performing any changes.
  2. Connect to your server or shared hosting account with SSH
  3. Connect to MySQL using the following command:
mysql -u username -h host database -P port -p

Enter the database information from your database as follows:

  • username is your database username
  • host is your database hostname or IP address
  • database is the database name
  • port is the port MySQL is running on (by default this is 3306)

4. When prompted, enter the password for that MySQL user.
5. Once connected, enter the following command to check your current theme and child theme:

select * from wp_options where option_name = 'template' or option_name = 'stylesheet';

Update the command as follows:

  • themeName is the name of the new theme

7. To change the stylesheet, enter the following command

type update wp_options set option_value = 'themeName2' where option_name = 'stylesheet';

Update the command as follows:

  • themeName2 is the name of the new theme or child theme

8. After changing the template and stylesheet, type exit; to close out of SSH.

Warning: If your WordPress database uses custom table prefixes, then you must replace wp_ in each command with the prefix listed in your wp-config.php file.

More info