Wordpress Site / Address URL, set it and forget

Great practice will be to install Wordpress at the begging from the end user address (URL).

For local use:
1) create some DNS record for example http://wp.pro
2) use http://wp.pro to install wordpress
3) install means this wizard:

At the end it looks like this:

Scenario 2. The internet scenario:
1) NAT Wordpress address
2) Go to http://xxxxxxxxxxxx.sn.mynetname.net
3) Install from there :)

At the end it looks like:

It will be a bad idea to change this setting when I have made already do some media uploads cause it will be assigned with this url.

These are some command how I identified some messed up post records:

mysql -uroot -ppassword
use wordpress;
show tables;
describe wp_posts;
select guid from wp_posts;

Related:
https://codex.wordpress.org/Changing_The_Site_URL