Comment on WordPress CloudFlare Flexible SSL – Making It Work by Ivan Arnaudov.
Just got into that trouble myself (changing site URL from WP admin panel…). Didn’t need to get into the database, but had to open wp-config.php and paste these two lines:
define(‘WP_HOME’,’http://www.mywebsite.com’);
define(‘WP_SITEURL’,’http://www.mywebsite.com’);
Thanks for the great tutorial.