Wordpress website URLs in admin need updating but locked out.

You are correct that an update to your MySQL database is needed to correct this and without phpmyadmin you will need to use the command line mysql client. The steps to update the default address are:

1.) Log into your droplet via ssh and get your root mysql password from the file /root/.my.cnf

cat /root/.my.cnf

2.) Use the following command to connect to your MySQL server from the command line client, entering the MySQL root password when prompted

mysql -uroot -p wordpress

3.) Now you can update your database with the correct url using the following queries, replacint [your ip] with your droplet’s IP address.

update wp_options set option_value = 'http://[your ip]' where option_name = 'siteurl';

update wp_options set option_value = 'http://[your ip]' where option_name = 'home';

Once you have done this your site should again be accessible.