Create WordPress Website in Azure App Service and GoDaddy MySQL Database

Microsoft Azure App Service provides an easy way to install Wordpress. Just follow the article Create a WordPress web app in Azure App Service   and a wordpress website can be setup with minutes.

The only problem is that Azure Bizpark account can not be sued with MySQL database. And the 3rd party mysql service (ClearDB) is quite expensive.  Therefore I would create a default webapp and install Wordpress manually.

First I will create an empty App service. 



1. Create deployment credentials for your app in the Azure Portal. To do this, in your app's blade, click Settings > Deployment Credentials.

2. After you have configured deployment credentials, obtain the FTP connection information by going to Settings > Properties, and then copying the values for FTP/Development User, FTP Host Name, and FTPS Host Name.

3. From your FTP client, use the connection information you gathered to connect to your app.

4. Copy your files and their respective directory structure to the /site/wwwroot directory in Azure (or the /Data/Jobs directory for WebJobs).

5. Browse to your app's URL to verify the app is running properly.

After above step the ftp account and login information will be available through the App Services essentials tab. Use FileZilla to enter the login information. You can now upload your Wordpress installation

The last step is to configure your domain name following this article: https://azure.microsoft.com/en-us/documentation/articles/web-sites-custom-domain-name/ . It took me quite time to figure out that since I my using the Cloudflare as my name server, the domain binding can not recognize my domain CName and A record. After I switch the domain name server back to the default GoDaddy name server, everything works fine.

After the domain binding works fine, we can now download and upload the wordpress installation to the app service.

Wordpress can be downloaded from here: https://wordpress.org/download/. After uploading the wordpress files to the Site/wwwroot folder, the wordpress is ready to be configured.

Now let's configure a MySQL database on GoDaddy. Following is the information required to be prepared to setup the MySQL Database.

Welcome to WordPress. Before getting started, we need some information on the database. You will need to know the following items before proceeding.
  1. Database name
  2. Database username
  3. Database password
  4. Database host
  5. Table prefix (if you want to run more than one WordPress in a single database)
We're going to use this information to create a wp-config.php file. If for any reason this automatic file creation doesn't work, don't worry. All this does is fill in the database information to a configuration file. You may also simply open wp-config-sample.php in a text editor, fill in your information, and save it as wp-config.php. Need more help? We got it.
In all likelihood, these items were supplied to you by your Web Host. If you don't have this information, then you will need to contact them before you can continue. If you're all ready…
After creating a GoDaddy MySQL database, just continue with the wordpress setup with the database information and the wordpress installed on Azure App Service will run with a MySQL Database from GoDaddy. 

An blank wordpress page will load in about 2 seconds following above approach. For most cases the speed should be OK.






Comments

Post a Comment

Popular posts from this blog

Javascript Hosted on Google Drive Not Working Reliably

Here is the story. I have been using Google Drive to host the javascript files and stylesheet files all the time. It works perfectly, until a few days ago when I noticed that if the web page contains javascript files hosted at Google Drive, it can not be viewed properly from the Facebook built in web browser.  I did some further investigation. The same thing happened when the page is opened in Wechat built in browser.  However, the page works fine when it is opened in most browsers, like IE, Chrome, Firefox. It took me several hours to figure why. And So far I have not find out the reason. I checked the mime type of the files. They are correctly recognized by Google Drive. But the solution is: moving the files out of Google Drive. Now it works perfectly, in browser and in App built in web browsers as well.
Read more

Newsmag Theme and External Featured Image

The  NewsMag  wordpress theme is a fast and simple.  It is excellent for a news, newspaper, magazine, publishing or review site. It also supports videos from YouTube and features a rating system. It uses the best clean SEO practices, and on top of that, it’s fast, simple, and easy to use. In addition, News mag supports responsive Google Ads and AdSense. The problem I had with this theme is that it does not work with  Nelio External Featured Image  by default. You can follow the steps in this article to make the theme and the plugin work with each other Nelio External Featured Image Not working with Newsmag theme Another useful information is here:  Solution fix thumn for theme Newsmag when using module Nelio External Featured Image Unfortunately whenever the theme is updated, the update to the theme will get lost. Therefore it is not a good idea to use the   Nelio External Featured Image  plugin. After some research, I found a...
Read more

Responsive Web Design

Google has an document about  How to Building Smartphone-Optimized Websites . In this document, responsive web design is the first suggestion. I have been looking for a easy to implement responsive css framework that can change my websites layout so that they can fit to smart phone device for quite a little while. However, most of them requires more than a css file.  After searching aroung, I found a good article that introducts 10 well adopted grid frameworks  10 Lightweight & Minimal Responsive Grid Frameworks Among them, the  Simple Grid  is very clean and simple. It does not work well on IE 7 or IE 8. Other than that, it works fine.  The  Proportional Grids  is also a quite stable and simple one. For a website that involves user input, I would recommend  Base Framework which is almost ready to use so that you do not have to worry about the user input formatting. It is very important to add following line to the he...
Read more