How to change the WordPress theme in CPanel (via the database)

Step 1 : Log into your cPanel interface (

Step 2 : Look for the Databases category and click on the phpMyadmin icon.

Go to PHPMyAdmin

Step 3 : Once inside the phpMyadmin look to the left hand sidebar and click on your specific WordPress database.

Select The Database

Step 4: From there, select the wp_options table.

Select The Options Table

Step 5 : Once the table is opened, look to the tab menu on the screen and click on the Browse tab option. This allows you to browse the columns broken down into pages. Click on the Show All option at the top so it will list all the columns on one page.

Select The Colomn

Step 6: Next, you will need to locate two rows on the page, the template and the stylesheet. Pick template and click on the Edit link.

Step 7: This will take you to the edit page where we will change the data for the option_value. In our example, the value is set for the alexandira template. Change this to the default theme name, twentythirteen and click on the Go button at the bottom of the page.

Step 8: Perform the same procedure on the stylesheet row. When you finish the stylesheet and return to the list, you should see the new theme in the value portion of the list for both. You can now visit your website and see that it is using the default theme. From here you should also be able to log into your wp-admin area.

How to set private name servers in

How to set private name servers in

  • Step 1 – Login to

Domain List

Step 2 – Goto Manage of your domain and click to the Advance DNS

Advance DNS in Namecheep

Step 3 – Go to Add name server button

Add Name Server

Step 4 – Select Ns1 from the list.

Select Ns1

Step 5 – Add IP address that given to you and click Done.

Add IP Address

Step 6 – Add Name server button again.

Add Name Server

Step 7 – Select Ns2, give the IP and click done.

Select Ns2

Step 8 – Go back to domain.

Goto Domain

Step 9 – Go to Name Server section and Select Custom Name servers and add ns1.yourdoamin and ns2.yourdomain that previously added.

Custom DNS

Step 10 – Select tick mark.

Step 11 – Done.




How to set private name servers in

  • Step 1 – Login to


  • Step 2 – Click Manage Domain for your domain


  • Step 3 – Click Host Names


  • Step 4 – Click Add


  • Step 5 – Enter your details. ns1 and IP address and click Save


  • Step 6 – Click Add Button again enter ns2 and ip. Then save.


  • Step 7 – Go back


  • Step 9 – Click change Under Nameservers.


  • Step 10 – Select Custom Option and Enter you name servers you added in previous steps. ns1.<yourdomain> and ns2.<yourdomain>. Then click ok.

Step 12 – Click Save Button

Step 13 – Done. You need to wait some time and refresh the page to see the newly added details.