MySQL Queries to Change WordPress HTTP to HTTPS

So, we will be using WordPress MySQL database from Command Line, like the guide How to Export WordPress MySQL Database on Rackspace Deployment. SSH to your Database server as root and login to MySQL as Root :

ssh root@112.153.29.178
 # change the IP 
mysql -u root -p
 # provide mysql root admin's password
 # mysql interactive mode
 # mysql >
 # if you commit error, it will become
 # mysql > 
         -> 
 # this is asking values due to your error
 # type \c and hit enter to get back to
 # mysql >

1

2

3

4

5

6

7

8

9

10

11

12

ssh root@112.153.29.178

# change the IP

mysql -u root -p

# provide mysql root admin's password

# mysql interactive mode

# mysql >

# if you commit error, it will become

# mysql >

->

# this is asking values due to your error

# type \c and hit enter to get back to

# mysql >

First, take a backup. This is important. Then,

show databases;

1	show databases;

Output :

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| your-wordpress     |
+--------------------+

1

2

3

4

5

6

7

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| your-wordpress |

+--------------------+

Select your database :

use your-wordpress;
 # database changed will be the output

1 2	use your-wordpress; # database changed will be the output

Optionally, see the tables :

show tables;

1	show tables;

This command changes all http to https in wp_options :

UPDATE wp_options SET option_value = replace(option_value, 'http://thecustomizewindows.com', 'https://thecustomizewindows.com') WHERE option_name = 'home' OR option_name = 'site url';

1	UPDATE wp_options SET option_value = replace(option_value, 'http://thecustomizewindows.com', 'https://thecustomizewindows.com') WHERE option_name = 'home' OR option_name = 'site url';

Change http://thecustomizewindows.com, https://thecustomizewindows.com. You only need to see for Errors in output. Other two parameters are not needed to observe.

We are changing the POST GUID :

UPDATE wp_posts SET guid = replace(guid, 'http://thecustomizewindows.com','https://thecustomizewindows.com');

1	UPDATE wp_posts SET guid = replace(guid, 'http://thecustomizewindows.com','https://thecustomizewindows.com');

Now, this is for Post Content (including images)

UPDATE wp_posts SET post_content = replace(post_content, 'http://thecustomizewindows.com', 'https://thecustomizewindows.com');

1	UPDATE wp_posts SET post_content = replace(post_content, 'http://thecustomizewindows.com', 'https://thecustomizewindows.com');

You should change the Post Meta Too :

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://thecustomizewindows.com','https://thecustomizewindows.com');

1	UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://thecustomizewindows.com','https://thecustomizewindows.com');

Clear Page Cache, Deactivate Page Cache; deactivate any WordPress Plugin which changes URLs to HTTPS or makes relative. On Chrome Browser’s developer tool’s console, you will see the Post Images are HTTPS now. This method is better than the Search and Replace Plugin. PHPMyAdmin is usually not used in high-end setup for better security. Why you will need PHPMyAdmin, you can see things from Command-Line.

Update on Changing WordPress HTTP to HTTPS

There are several other things which required to be mentioned as an update. You can update your WordPress site address and admin address from the option under Settings > General.

Open wp-config.php and add the following lines somewhere before where it says “That’s all, stop editing!” :

define('FORCE_SSL_ADMIN', true);

1	define('FORCE_SSL_ADMIN', true);

The above will force wp-login to be over SSL. If you are using some reverse proxy infront, then should add this logic on wp-config.php file below the above directive :

if (strpos($_SERVER['HTTP_X_FORWARDED_PROTO'], 'https') !== false)
$_SERVER['HTTPS']='on';

1 2	if (strpos($_SERVER['HTTP_X_FORWARDED_PROTO'], 'https') !== false) $_SERVER['HTTPS']='on';

We have guide to install Apache on Ubuntu 18.04 LTS with HTTPS, HSTS, HTTP/2. Also, you may read the optimization tips such as Cache Aware HTTP/2 Server Push, TLS false start for a faster WordPress with HTTPS.

Tagged With mysql replace https:// http:// wordpress , wordpress mysql replace http woth https post content , mysql replace http https all base , local wordpress installation mysql replace https with http , http to https mysql wordpress , database wordpress change http to https , changer http https wordpress database , change to https wordpress mysql , change http to https wordpress database , change http protocol in phpMyAdmin

MySQL Queries to Change WordPress HTTP to HTTPS