![]() How to install and setup PHP and MySql in windows 10 and 7 By installing WAMP server on your windows you can run Apache, PHP, and MySql under a single package. Run sample PHP and MySql script. Up-to-date documentation for the latest stable version of Moodle may be available here: Manual install on Windows 7 with Apache and MySQL. Main page Installation Manual install on Windows 7. Install and Configure MySQL for PHP Applications on IIS 7 • • 5 minutes to read • Contributors • • In this article by Introduction While Microsoft® SQL Server® 2008 is the recommended database to use when hosting PHP applications on an Internet Information Services 7 (IIS 7) and above Web server, you can also use MySQL as the database. Currently, many popular PHP applications use MySQL Server for data storage. Using MySQL requires hosting providers to include MySQL database support with the hosting packages. MySQL cannot currently be installed with the Microsoft® Web Platform Installer (Web PI). This article provides guidance for installing MySQL manually. Install MySQL Server on Windows Server 2008 or Windows Server 2008 R2 It is recommended that you install MySQL on a dedicated server rather than installing MySQL on the same server that is running IIS. The separation of database server and Web server makes overall installation more secure and manageable and avoids resource contentions between the database and Web server processes. We recommend downloading Windows® Installer. • Start Windows Installer, or extract all the files from the archive, and then start Setup.exe. • You can use a Typical Setup or customize the installation to suit your needs. • Once the installation wizard is completed, it is recommended that you leave the Configure the MySQL Server now check box selected. ![]() Configure a MySQL Instance • Run the MySQL Server Instance Configuration Wizard, and then choose the configurations options that most closely match your environment. For more information, see the. Best practice recommendations are as follows: • Click Next in the Instance Configuration Wizard. • Select Detailed Configuration, and then click Next. • Select a server type that best suits your environment. It is recommended to set up a separate MySQL server; when prompted to select a server type, select Dedicated MySQL Server Machine, and then click Next. • Select a database option, and then click Next. • Select either the Multifunctional Database or Transactional Database Only options if you are using the InnoDB storage engine or the high-speed MyISAM storage engine (for example, if the Web applications on your server require multi-statement transactions, advanced isolation levels and row-level locking, foreign key constraints, or atomic, consistent, isolated, and durable [ACID] features). These options provides fully ACID transactional capabilities, but at the cost of more aggressive usage of disk space and memory. • Otherwise, use the Non-Transactional Database Only option, which is optimized for high-performance SELECT operations. It has low overhead, in terms of memory usage and disk utilization, but at the cost of not supporting transactions. • Choose the option that sets the number of concurrent connections you need. Note Connections require memory; if the number you choose is too big, your server may not have enough memory. • You may adjust networking settings to suit your environment or accept defaults, and then click Next. • Select the default character set that best suits you, and then click Next. • We recommend enabling both Windows options here. Select both check boxes, and then click Next. • Type the password you want to use for the root account, and then click Next. • Click Execute to apply your settings.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2018
Categories |