How To Install Mysql Server On Windows Server 2012

Installing WordPress, PHP, and MySQL on Windows Server 2012 R2

Microsoft's Web Platform Installer (Web PI) makes installing applications a breeze. In a recent blog post I covered just how easy installing IIS has become using Web PI. In this walkthrough I'm going to cover installing WordPress, PHP, and MySQL using Web PI.  I call back the days when installing these applications was a manual process. Depending on your level of expertise information technology was quite a challenge to get everything working properly. If you lot've ever tried to uninstall and so reinstall MySQL you lot know what I mean.  Now cheers to Web PI with just a few clicks of your mouse you lot can have WordPress, PHP, and MySQL installed on Windows Server 2012 R2 in a few short minutes.

Setting up Your Site

On my examination server I have a new installation of Windows Server 2012 R2 with IIS 8. Using the default site you'll see the familiar IIS 8 welcome folio chosen IISStart.htm. This page is automatically created for the default site when yous install IIS. Be certain to delete it once you deploy your files.

Launching Web Platform Installer

Later installing the IIS role on your server you'll be able to launch Spider web PI directly from IIS Manager by clicking on Become New Web Platform Components . The real power and ease of using Web PI to install WordPress, PHP, and MySQL is axiomatic subsequently y'all cull WordPress and Click Install. Web PI will automatically select the other application dependencies and include them in the installation.

Choosing MySQL Root Countersign

Spider web PI volition prompt y'all to cull a countersign for the root administrator user for MySQL. Be sure to make a annotation of this password considering it will be needed after and resetting the MySQL root countersign manually tin can be claiming.

Click Have. The installation volition start running.

Web PI will download and install all the necessary applications. It volition complete within a few minutes.

Configuring the site for IIS

At this phase of the installation Spider web PI will prompt you to choose a few settings for the IIS configuration. You can either install WordPress on an existing site or select New Web Site. I am going to install WordPress into the root of my site and then I am using "/" for the application name. If you plan on running WordPress from a subfolder then enter a proper name for the application. Once the required parameters have been entered you will be able to click Continue.

Y'all will be prompted to enter a few unique phrases to strengthen the password security.

Once Web PI completes the installation process your new MySQL Database Proper noun, Database User Proper name, and Database Password will be displayed on the screen. Brand a notation of these settings. You will need them afterward to log into the database.

Installing WordPress

In one case Spider web PI completes its installation process the WordPress installer volition be launched. This concluding stride of installing WordPress completes quite quickly. Enter the Site Title, the admin username and password, and your email address. Click Install WordPress to terminate setting it up.

WordPress is at present ready for utilise. Click Log In to go to the WordPress Dashboard.

Securing WordPress

Whatsoever serious web programmer or server admin knows how of import it is to secure your spider web site.  So afterward I install WordPress the very adjacent matter I do is secure it. In that location's a corking WordPress plugin called Limit Login Attempts which can help block automated brute force attacks to your login page.  If y'all wanted to take information technology a step further yous could even use Url Rewrite to block requests except for your own IP which I chose to do when my site was once targeted past brute force attacks. One other plugin yous may desire to consider is called Bad Behavior. This is a great plugin for mitigating link spam and the robots that deliver it. Combined with Akismet your site's web log post comments will be spam free.

Summary

WordPress is one of the nigh widely used free CMS products. Installing WordPress on Windows Server 2012 R2 also requires PHP and MySQL. Now cheers to Web PI installing WordPress, PHP, and MySQl has never been easier. Your site will exist up and running in mere minutes. Later on installation accept some extra time to secure the login page and prevent annotate spam. Cheers for reading.

Source: https://blogs.iis.net/peterviola/installing-wordpress-php-and-mysql-on-windows-server-2012-r2

Posted by: oharewhouse.blogspot.com

Share this post