Changing Port number in WordPress blog

Question

First of all I installed wamp server on port 8081 (Because there was IIS on 80). the word process was installed successfully and blog was running smoothly. Now I stopped the IIS and set the apache port to 80. But the application is redirecting to port 8081. (Also I copid the wordpress folder to my live domain, in there also it is redirecting to port 8081.) In which file, I need to change the port number? (I have already changed the port number in httpd.conf.)

Thank You in Advance. :)

Answer 1

I found same problem but I'm using xampp.

Scenario I have setup another new server using xampp in a different port (8090), then I transferred the existing WordPress to the new server but it was still keeping redirection to the original port.

Solutions Updated the option_value in the table wp_options in mysql to the new port. Here is an example updated query.

UPDATE `wordpress`.`wp_options`
SET
`option_value` = 'http://localhost:8090/wordpress'
WHERE `option_id` = 1 or `option_id` = 2;

Answer 2

I had an issue where the original port I had specified when I installed WP was changed. I couldn't log into wp-admin because WP kept redirecting to the old port. I used phpMyAdmin to edit the wp_options table. Both the siteurl and home records used the old port. With phpMyAdmin, you can edit cells directly without having to export/import. I thought I'd add this as an answer just in case it helps someone else down the road.

Or use a SQL like this:

update wp_options SET option_value = 'http://your-domain/wordpress:new-port' where option_id = 1 and option_name = 'siteurl';

update wp_options SET option_value = 'http://your-domain:new-port/wordpress' where option_id = 2 and option_name = 'home';