How to fix insecure urls in wordpress database without using phpmyadmin


Some webmasters are new in this area and they don’t know what does phpmyadmin or sql mean.So I would like to write this guide just to help the newbeas.

Lets start to this article with an example: I have a secured wordpress site with embedded videos but all videos are embedded via http like the below sample code:

<iframe src="http://www.sourcesite.com/embed/Jodbdj52Vc0" width="560" height="315" frameborder="0" allowfullscreen="allowfullscreen"></iframe>

Qestion: The above iframe is blank and I have thousend of posts so, my videos are not visible because my site is secured.Is there any solution without using sql commands?

Answer: Yes there is a perfect and free wordpress tool called Better Search & Replace

  •  Get a database backup, download plugin, install and activate on your site.
  •  Jump to the Dashboard> Tools > Better Search Replace Tab where you will see all the fields.
  • Field 1: Search for (paste here http:// or anyother value),
  • Click on Run Search/Replace button and you are done.

Note: Please get a database backup before using this tool.