My IP address redirects automatically to wordpress doman name

Hi

Connect to the DB using phpmyadmin or via mysql CLI and change these two rows in table wp_options:

select * from wp_options where option_name in ('siteurl','home');

+-----------+-------------+-----------------------+----------+
| option_id | option_name | option_value          | autoload |
+-----------+-------------+-----------------------+----------+
|        37 | home        | https://cachoid.com/blog | yes      |
|         1 | siteurl     | http://cachoid.com/blog | yes      |
+-----------+-------------+-----------------------+----------+

Replace the domain name with your IP and that should do it.

Cheers

FYI, @unixynet is correct. You can change this with the following MySQL queries:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

Ofcourse, change the “www.newurl” to the IP you would like to use.

Try the following steps by using the root console of your droplet.

1. Open a text editor so you can alter the configuration file of your site.

vim /etc/apache2/sites-enabled/000-default.conf

2. Set the following attribute to off:

UseCanonicalName Off

Don’t forget to turn it back on again when in production.