By brianfreeze
I am using a Droplet, Ubuntu Wordpress Single Install
Install goes great, change my WP admin log in without issues. I have a domain registered through Google, that correctly points my domain to the droplet server IP address.
I can navigate my site, however any site other then the home page changes the url to http://ipaddress/page instead of Http://domain/page.
When I go to change both URL sites in the WP settings to the http//domain (instead of http://ipaddress. I lose the ability to log into the WP site as an administrator.
I have tried to use the VNC access to log in via phpmyadmin, or via the mysql server however i do not know the mysql root password, and since i did a WP install i can not find it in my message of the day. I can log in as a root into the ubuntu version, creat and add new users in the sudo group but never acess the mysql root
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
I have a related problem. I changed my wordpress address URL to be different from my Site Address URL. Now both links don’t work and I can’t access the site in anyway
I can log into my server via ssh root however I need to know how to make the change through the command terminal.
If you first ran through the WordPress installer after visiting via the IP address, you’ll need to update your WordPress settings to use the domain. Visit http://your.ip.address/wp-admin/options-general.php and update the values for WordPress Address (URL) and Site Address (URL)

If you need to access the root MySql user, the password is stored in /root/.my.cnf
Hello,
Another way fo chaning your site and home URLs is by editing your wp-config.php file and adding the following lines:
define( 'WP_HOME', 'https://example.com' );
define( 'WP_SITEURL', 'https://example.com' );
Best,
Bobby
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.