Configuring mysql with apache windows

You need to specify the extensions required for Moodle. Find the 'Dynamic Extensions' section and change the following lines uncomment and add the correct path :. I had to change a file explorer setting to create. You should see a screen with masses of information and the PHP logo at the top. We will use the Git version control system for loading and updating the Moodle software. We need to install Git first Depending on your firewall situation one may work and the other not.

You are now ready to start the installation process in earnest. Click Execute to begin the installation process. Once the status of the installation status is labeled as Complete, you are ready to configure the MySQL database. Initiate the process by clicking Next. The first configuration option affects database availability. In this instance, we selected the classic, single server option. The Config Type option lets you choose between three server configuration types. Development Computer , Server Computer , and Dedicated Computer define whether the server is dedicated solely to running your MySQL database or is going to share the underlying system with other applications.

The default setting is port number and can be changed to suit your needs. By checking the Show Advanced and Logging Option box, you can set additional logging options at a later stage.

It is possible to choose between two authentication methods, the recommended Strong Password Encryption , and the Legacy Authentication Method. Select the recommended Use Strong Password Authentication option. You are now prompted to enter a password for your MySQL root user. You can also create additional roles for various users and purposes.

If you decide to start MySQL as an executable application, you would need to configure it manually. Logging options let you select the types of logs you want to activate and define the log directories. These settings are only available if you have checked the Show Advanced Options box in the Type and Networking tab. An overview of the configurations steps appears on the screen.

Click Execute to apply the configuration. The system informs once the configuration process is completed. Select Next to continue the installation process. After clicking Next , you are given the option to copy the installation process log to the Windows Clipboard. The path in this command is the default installation folder. Individual committers may provide binary packages as a convenience, but it is not a release deliverable.

If you cannot compile the Apache HTTP Server yourself, you can obtain a binary package from numerous binary distributions available on the Internet. Apache is configured by the files in the conf subdirectory. These are the same files used to configure the Unix version, but there are a few different directives for Apache on Windows.

See the directive index for all the available directives. Because Apache for Windows is multithreaded, it does not use a separate process for each request, as Apache can on Unix.

Instead there are usually only two Apache processes running: a parent process, and a child which handles the requests. Within the child process each request is handled by a separate thread. MaxConnectionsPerChild : Like the Unix directive, this controls how many connections a single child process will serve before exiting.

However, unlike on Unix, a replacement process is not instantly available. Use the default MaxConnectionsPerChild 0 , unless instructed to change the behavior to overcome a memory leak in third party modules or in-process applications. ThreadsPerChild : This directive is new. It tells the server how many threads it should use. This is the maximum number of connections the server can handle at once, so be sure to set this number high enough for your site if you get a lot of hits.

The recommended default is ThreadsPerChild , but this must be adjusted to reflect the greatest anticipated number of simultaneous connections to accept. The directives that accept filenames as arguments must use Windows filenames instead of Unix ones. However, because Apache may interpret backslashes as an "escape character" sequence, you should consistently use forward slashes in path names, not backslashes.

While filenames are generally case-insensitive on Windows, URLs are still treated internally as case-sensitive before they are mapped to the filesystem. If you wish to assure that only lowercase is used in URLs, you can use something like:. When running, Apache needs write access only to the logs directory and any configured cache directory tree. Due to the issue of case insensitive and short 8. This means that each directory which Apache evaluates, from the drive root up to the directory leaf, must have read, list and traverse directory permissions.

If Apache2. Apache for Windows contains the ability to load modules at runtime, without recompiling the server. To activate these or other modules, the LoadModule directive must be used.

For example, to activate the status module, use the following in addition to the status-activating directives in access. Information on creating loadable modules is also available. More information is available. When running CGI scripts, the method Apache uses to find the interpreter for the script is configurable using the ScriptInterpreterSource directive. Since it is often difficult to manage files with names like.

This mechanism acts as a backup for those situations where Apache is not yet prepared to use the error. Apache comes with a utility called the Apache Service Monitor. With it you can see and manage the state of all installed Apache services on any machine on your network. To be able to manage an Apache service with the monitor, you have to first install the service either automatically via the installation or manually.

You can install Apache as a Windows NT service as follows from the command prompt at the Apache bin subdirectory:. If you need to specify the name of the service you want to install, use the following command.

You have to do this if you have several different service installations of Apache on your computer. If you specify a name during the install, you have to also specify it during any other -k operation.

If you need to have specifically named configuration files for different services, you must use this:.

If you use the first command without any special parameters except -k install , the service will be called Apache2. Before starting Apache as a service by any means, you should test the service's configuration file by using:.