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 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';