How to Install a New WordPress Theme via phpMyAdmin

Author:Mikkel Haldorsen
Updated:Apr 4, 2025

To change your WordPress theme via the database using phpMyAdmin, follow these organized steps:

  1. Access phpMyAdmin: Use your hosting provider's tools or contact them for credentials (hostname, username, password).

  2. Locate the wp_options Table: Once logged in, navigate to the desired database and select the wp_options table.

  3. Identify Relevant Fields:

    • Look for fields like 'template' or 'stylesheet'.
    • Verify if there's a 'theme' field; this might hold the active theme name.
  4. Determine the Current Theme: Check which row corresponds to the currently active theme, possibly by reviewing other options or knowing the theme's folder structure.

  5. Update Fields with New Theme Name:

    • Replace the value of 'template' and/or 'stylesheet' fields with your new theme's name (e.g., 'newtheme').
    • Ensure you're updating the correct fields to avoid functionality issues.
  6. Verify File Presence and Permissions:

    • Confirm that the new theme is uploaded to wp-content/themes.
    • Use FTP/SFTP to ensure files are accessible and permissions are set correctly.
  7. Consider Backup: Before making changes, consider exporting the database for backup to prevent data loss.

  8. Test Access: After updating, attempt to log in to the admin dashboard to check if the theme change is successful. Be aware that issues with the current theme might prevent this access.