I have received an email regarding the WordPress installation with different SERVER i.e WordPress files on one SERVER and DATABASE on another SERVER.
For installing the WordPress, please visit the blog – WordPress installation Guide
WordPress and Database on different SERVER
For installing the wordpress with different DATABASE server,You need to do the settings on the WordPress files as well as MYSQL configuration files.Now by default,it has the localhost, but now you need to change it.
Follow the some easy steps.
i ) – Open the file : wp-config.php : and fillup the required information.
// ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'db_example'); /** MySQL database username */ define('DB_USER', 'db_user'); /** MySQL database password */ define('DB_PASSWORD','db_password'); /** MySQL hostname : Change- localhost to ip (xx.xx.xx.xx) of another SERVER ***/ define('DB_HOST', 'xx.xx.xx.xx');
You need to provide the -Database Name,UserName,password and HostName of another Server where you need to install Database.
ii): Login the MYSQL SERVER database and done the Setting of – BIND ADDRESS : of file : my.cnf : with location –
Path : /etc/mysql/my.cnf
Here is the screenshots.
For binding address
You need to change the bind address.
Change : 127.0.1.1 : to : 0.0.0.0 : for available/access to all IP.
If you need any difficulties then please share with me.