Multiple Azure Web Sites on a single MySQL instance
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
open the file in your favorite text editor and locate “publishProfile profileName”
within that, locate
publishUrl – this is the address your FTP client will want for the hostname
userName – FTP user
userPWD – FTP pass
fire up your FTP client and connect
navigate to /site/wwwroot if your client is not already there
retrieve and edit “wp-config.php”
inside that file, you’ll be looking for “$table_prefix =“
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