How to restore settings when a wrong domain name is set for WordPress users

When you set a wrong domain name in WordPress setting page, it is possible that your website may not be accessible and there is only one blank page in front of you. So what can we do? Reload WordPress? Absolutely not. Here is a method to solve the problem.

• Install phpmyAdmin

wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
rpm -ivh epel-release-6-8.noarch.rpm
yum -y update
yum install phpmyadmin

restart apache service

service httpd restart

Enter this URL to access phpmyAdmin : http://Your_IP/phpmyadmin

Then you should edit the "wordpress" database -> "wp_options sheet" -> "siteurl" & "home" and change the URL to http://Your_IP . And reset the domain name in WordPress setting page.

• Error: You don't have permission to access /phpmyadmin on this server.

nano /etc/httpd/conf.d/phpMyAdmin.conf 

Replace the "Require ip xxxx" and "Allow from xxxx" to "Require all granted" and "Allow from all",respectively.

  <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
      # Require ip 127.0.0.1
      # Require ip ::1
        Require all granted
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     #Deny from All
     #Allow from 127.0.0.1
     #Allow from ::1
      Allow from all
   </IfModule>

Restart the apache service:

service httpd restart