Article

Multiple Azure Web Sites on a single MySQL instance

Currently in Azure you get 1 free MySQL database courtesy of ClearDB. To install a second WordPress blog you are forced to use the same database (or pay to create a new one) which is not unreasonable if you’re not requiring much space for each. When you try to open your brand new WordPress it fails with no HTML coming back to your browser. It is easy, though not intuitive, to fix. See below for an alternative way.

Select your fresh WordPress Web Site
Choose dashboard from the tabs across the top
Choose to “Download the publish profile” – skip this step if you already know your FTP credentials
1. open the file in your favorite text editor and locate “publishProfile profileName”
2. within that, locate
  1. publishUrl – this is the address your FTP client will want for the hostname
  2. userName – FTP user
  3. userPWD – FTP pass
fire up your FTP client and connect
1. navigate to /site/wwwroot if your client is not already there
retrieve and edit “wp-config.php”
1. inside that file, you’ll be looking for “$table_prefix =“
2. change it from “wp_” to something unique to your new WordPress install
post the file back to the server
using your browser, return to http://{yourwebsite}.azurewebsites.net/wp-admin/install.php
login and setup as desired

Notice: The free database will allow writes until you reach 20MB in size – then it’ll stop accepting INSERTs.

Alternative

Using WEBMATRIX, you can edit the wp-config.php file directly. Just edit as in step 5 above

Comments Closed.