Search-Replace-DB -> script tries to log in to the DB on webserver
fl1tz opened this issue · 2 comments
After calling the script, the message appears that the user data are incorrect. - I'm working on the localhost, but the script tries to log in to the DB on the webserver.
I want to test Wordpress on the localhost. On the server I have WP 4.6.13 (I wish to update and test the update bevore) and PHP 7.0. On my localhost I have PHP 7.3.2.
Excuse me. A beginner mistake. Of course I had to change the wp-config.php. And to write in the new access data. I also had to empty the .htaccess.
By the way, I found another solution here:
A small sql script from Neil Gee to run in the database you wish to change.
`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');`
no worries, glad you solved!