Setup your own WAMP stack – Part III

In the previous two parts we have done with apache & php

Now we will be installing MySQL in our system

1. Download from https://dev.mysql.com/downloads community download page --> Windows downloads -- Without installer (zip file, unzip it in C:\mysql). I got it from Oracle.

2.Unzip the mysql-noinstall-5.x.xx-win32.zip to e.g. C:\ rename it to mysql

3. Uninstall any previous MySQL Windows service

Code:

mysqld.exe --remove

4. Copy one of the MySQL\*.ini files (usually my-large.ini) to MySQL\my.ini

5. Edit my.ini and change any parameters for your site.

5a. Sometimes it is possible that my.ini is not present. In that case search C:\Windows\my.ini or c:\Windows\my.cnf or c:\my.ini or c:\my.cnf. The system searches the my.ini file in these locations.  If nowhere it is found we have to create our own my.ini file in the directory c:\mysql, where we place all our mysql sub folders.

5b. Edit my.ini file (it is also a text file), it must contain the basedir and datadir to specify the location of mysql subfoldars and data location.

In my case it is:

#Path to installation directory. All paths are usually resolved relative to this.

#basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

basedir="C:/mysql/"

 

#Path to the database root

#datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"

datadir="C:/apache24/mydata/data/"

6. You can install mysqld.exe as a Windows service with

(see also : http://dev.mysql.com/doc/refman/5.6/en/windows-start-service.html )

Code:

To install the mysql service write in command line:

C:\mysql\bin>mysqld.exe –installß

Now do:

C:\mysql\bin>mysqld –initializeß

This may take some time. Please keep patience. After that the system database variable like root and temporary password and other will be initialized.

Secure the initial MySQL accounts MySQL access controls. Be aware that default both root and the anonymous account are set up with no password, so anyone can connect to the MySQL server as root.

In the data directory as mentioned in the my.ini file we will get a file with .err extension which will contain the temporary password for the root user of mysql.

We have to change this password in the following way:

C:\mysql\bin>mysql -l localhost -u root -p ß

Enter password: ***********

We will get the below message:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 22

Server version: 8.0.20 MySQL Community Server - GPL

 

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql>

Note: Common Error: C:\Apache24>mysql

If we type the above without username & password, we will get the following error:

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

We have to enter the temporary password we got from the said err file.

Now change the password for the user root@localhost in the following way:

mysql> ALTER USER 'root'@localhost IDENTIFIED WITH mysql_native_password BY 'abcdef';

Query OK, 0 rows affected (0.18 sec)

 

Optional:

7. Download phpmyadmin which is a good interface over your browser to manage mysql.

You can download phpMyAdmin from the page https://www.phpmyadmin.net/ from any web browser.

8a. unzip it to C:\Apache2\htdocs\ and rename it to phpMyAdmin

8b. You must put the folder phpMyAdmin inside the htdocs folder of Apache.

9. Now you should have access over http://localhost/phpmyadmin/

[Note: To make Apache able to run phpMyAdmin, the phpMyAdmin folder should be located inside document root folder of Apache. So, in this case it should be htdocs folder of apache root directory.]

Setup Apache-PHP-MySQL (All in short)

Finally, it is done.

From cli(Command Line Interface) I did.

1. apache 2.4 was previously installed from apache lounge

2. then after setting up httpd.conf file in c:\apache24\conf folder & setting the httpd-ssl.conf file in c:\apache24\conf\extra folder

a. I installed service by httpd --install

b. from windows services.msc ( to be ran from windows+R) windows apache can be started/restarted/stopped

c. from cli restart apache with c:\apache24\bin>httpd -k restart

d. all documents in browser are referenced from htdocs folder in c:\apache24 (as I set c:\apache24 as my root directory)

 

3.downloaded zip for php7, unpacked it, kept it in c:\php7 folder copied php.ini.production/php.ini.development to php.ini, done necessary modifications;

a. in c:\apache24\conf\httpd.conf file, made the necessary modifications for inclusion of php, include module fcgid if it is not there.

b. modify c:\apache24\conf\httpd.conf for securing ssl/tls

 

4. download mysql as zip from oracle

a. unpacked it in c:\mysqlxx.xx, renamed the folder as c:\mysql

b. install the service in services.msc window(seen on windows+r=>services.msc) from cli, by typing: mysqld --install(cant remember one or two hiphen), before that set the path for for mysql in env variables

c. there was no my.ini file in the system, created one in c:\mysql, specified the basedir and datadir there, specified some more options. saved it

d. created the folders as specified in my.in

e. from cli type:mysqld --initialize

f. it will take some time

g. after that check the data folder as mentioned in the datadir in my.ini(in my case c:\apache24\mydata\data), there must be an .err file. for me it was LAPTOP-419.....err. there will be the temporary password for root user

h. now start the mysql service from services.msc

i. now in cli type: mysql -h localhost -u root -p

j. it will ask for password

k. put that one from step g.

l. mysql prompt will come, change the password with alter user statement.

m. after that create new user, database, tables ,insert few data into table

n. now do the script php connect with data base with statement mysqli_connect(host, user, password, dbname, port)

o. it is successful

5. the last problem i faced that ' server authentication method unknown to the client' solved it this way:

 

C:\mysql>mysql -h localhost -u root -p

Enter password: ***************************************

The display Output:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 14

Server version: 8.0.20 MySQL Community Server - GPL

 

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> ALTER USER 'root'@localhost IDENTIFIED WITH mysql_native_password BY 'abcdef';

Query OK, 0 rows affected (0.18 sec)

 

Changing the password for another mysql user::

mysql> ALTER USER 'subhra'@localhost IDENTIFIED WITH mysql_native_password BY 'xyzmnopq';

Query OK, 0 rows affected (0.19 sec)

To exit mysql write \q at the mysql prompt.

mysql> \q

Bye

Now we can test our first web page on any browser. For this we have to create a web page test.html and put the following code in this html file. We can use Notepad++ as the editor.

<html>

          <head>

                   <title>This is a test Page</title>

          </head>

          <body>

                   <div>

                             <h1>Hello World!</h1>

                             <h2>Meet the New Idea</h2>

                   </div>

          </body>

</html>

Now open any web browser(like google chrome, Firefox, Internet Explorer etc.) and in the address bar write http://localhost/test1.html and press <-- [enter]

We will see the below test page on our browser:

Now we can make our desired web pages with html and php scripts with the help of mySql database. We can test our web pages in our local browsers and after completion we could upload out scripts to our desired domain server.

 

Setup your own WAMP stack – Part II

In our previous post “Setup you own WAMP stack – Part I”, we installed and setup Apache server in our Windows 10 PC.

We already know what is the WAMP stack. Now we will put (install & setup) PHP in the stack.

Download and extract PHP

Step1:

Now download PHP 7.x from http://windows.php.net/download/; you need this file: VC15 x64 Non Thread Safe

(related to the latest stable version number).

Please download the VC11/14 x86/x64 ‘Non Thread’ Safe OR VC11/VC14/VC15 x86/x64 Thread Safe if you need to run PHP as module.

I downloaded the php non thread safe zip file. As a ‘non thread’ safe php increases the performance a lot while a thread safe php uses much memory in synchronizing the thread.

Step 2:

Extract the contents of this zip file and move the contents to where you intend to use PHP such as C:\php7.

Step 3:

Now navigate the folder C:\php7 and find the php.ini-production file. It is a pure text file. Open it with editor like Notepad++ for ease. Find there the extension_dir directive and change it so that it can properly locate full path.

extension_dir = "C:\php7\ext"

To enable the mysqli change the following extensions by removing the comment character.

extension=php_mysqli

extension=mbstring

extension=pdo_mysql

 

Now enable the opcache:

zend_extension=php_opcache.dll

Now search for opcache:

opcache.enable=On

opcache.cli_enable=On

To hide php from Apache response header:

expose_php = Off

Search the pathinfo inside the script:

cgi.fix_pathinfo=1

To set your timezone. Find your zone at http://php.net/date.timezone:

date.timezone = “Asia/Kolkata"

Now check whether all of the modules have loaded properly:

At the command prompt, write: >php – m

It will display all the modules loaded.

save this file as php.ini.

Step 4:

Go back to C:\Apache24\conf and open httpd.conf text file.

Now, to be able to access the php, change the httpd.conf file inside the C:\Apache24\conf directory.  The httpd.conf file is also a pure text file. Open it with Notepad++ for ease. There, make sure it contains the code block mod_fcgid. (mod_fcgid is an additional download).

First, uncomment the following LoadModule:

LoadModule fcgid_module modules/mod_fcgid.so

Now add the following fcgid module. If it is already present inside the httpd.conf file modify it accordingly[uncomment it].

The mod_fcgid code is as following:

<IfModule fcgid_module>    FcgidMaxProcesses 300       FcgidMaxProcessesPerClass 300       FcgidOutputBufferSize 65536       FcgidConnectTimeout 10       FcgidProcessLifeTime 0       FcgidMaxRequestsPerProcess 0       FcgidMinProcessesPerClass 0       FcgidFixPathinfo 0       FcgidProcessLifeTime 0       FcgidZombieScanInterval 20       FcgidMaxRequestLen 536870912       FcgidIOTimeout 120       FcgidTimeScore 3       FcgidPassHeader Authorization    FcgidInitialEnv PHPRC "C:\\php7"    FcgidInitialEnv PATH "C:\\php7;C:\\WINDOWS\\system32;C:\\WINDOWS;C:\\WINDOWS\\System32\\Wbem;"    FcgidInitialEnv SystemRoot "C:\\Windows"    FcgidInitialEnv SystemDrive "C:"      FcgidInitialEnv TEMP "C:\\WINDOWS\\TEMP"    FcgidInitialEnv TMP "C:\\WINDOWS\\TEMP"    FcgidInitialEnv windir "C:\\WINDOWS"    <Files ~ "\.php$">             Options Indexes FollowSymLinks ExecCGI             AddHandler fcgid-script .php             FcgidWrapper "C:/php7/php-cgi.exe" .php    </Files> </IfModule>

 

Now save the httpd.conf file

Step 5:

Now install Apache service in your system. To do that:

C:\Apache24\bin>httpd -k install ß[Enter]

This will install the Apache service in our system.

We can check this in services window from the search box in the status bar(for Windows 10).

To restart Apache, we need to give the following command:

C:\Apache24\bin>httpd -k restart ß [Enter]

Window 10 automatically sets the path for php7. For Windows 2000, XP, vista, we need to restart the computer.

 (Apache for Windows contains the ability to load modules at runtime, without recompiling the server. If Apache is compiled normally, it will install a number of optional modules in the \Apache2.4\modules directory. 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.conf)

For example: LoadModule status_module "modules/mod_status.so"  

To stop the Apache serviece we need to write the following at the command prompt: C:\Apache24\bin>httpd -k shutdown ß [Enter]

Rather doing a shutdown we should do a restart whenever we make a change in the httpd.conf  configuration file. So, we need to do: C:\Apache24\bin>httpd -k restartß [Enter]

This will restart the apache services.

 

 Know about Web Server & Wamp Stack in brief

 

Setup your own WAMP stack – Part I

Though a distinct module for wamp server is available over the internet and one can download and install it as a package, wamp stack components can be installed separately (manually). Here we have shown how to install and setup wamp stack components separately (manually). 

Significance:

It is very essential for a Windows user who wants to establish his/her own dynamic web presence. A WAMP stack will enable you to test your own web pages on your own server on your own windows pc.  Once successful, you can easily put your web pages and server code into the actual domain server.

What is WAMP stack?

It is a stack to set up your own server on your Windows PC. First you need Windows environment (the OS), then you need to install Apache server, after that you need to install PHP and then setup your MYSQL database. In short it is Windows-Apache-MySQL-PHP stack. PHP is needed for your server-side coding.

For users of other environments like linux, they need to setup their LAMP stack which is Linux-Apache-MySQL-PHP stack. There are other stacks like MAMP – the Mac-Apache-MySQL-PHP stack etc.

Start:

As a Windows user we already have windows installed in our pc. I have Windows 10 installed in my pc. Now I need to install and setup Apache.

Before that we need to disable IIS in our Windows PC, if it is enabled. To disable IIS, follow the steps below:

1. Go to Services window by typing services in search bar at the bottom left; from there disable IIS admin service.

2. Now open "Turn Windows features on or off" in the same way.

3. Go to Internet Information Services

4. Click the square next to it so that it becomes empty.

5. Click OK and reboot the PC.

Start with Apache:

We need to start apache as a service in our Windows Pc. Apache can be downloaded from any of its official sites. (it an open source software).

Before downloading and installing Apache we need to uninstall Apache if it is previously installed anytime. The code to uninstall Apache is >httpd-k uninstall

[Note: httpd is available in bin folder of the root directory. If apache is installed in c:\Apache24 then the command will be available in c:\Apache24\bin> folder.

Again, the command prompt( dos prompt) should be opened with administrative privileges.

It is necessary to restart the apache server each time.]

To check whether Apache is running in our system we need to check the services running in our system. For windows 10 users we need to write services in the search box in the status bar.

v

On hitting enterß the services window will open. In this window we will get all the services running in our system. As I have Apace 2.4 already installed in my system the Apache service is seen to be running in my system. Below is the figure:

 

So, if apache is installed in our system, we need to uninstall it first. To do that first we need to check where Apache was installed in our system. Mostly it is in the C:\Apache directory. For me it is C:\Apache24 directory. And the httpd is in the C:\Apache24\bin directory. So, we need to go to C:\Apache24\bin> and then >httpd -k uninstall ß

If you don’t have Apache installed in your system You can start with next step:

Step 1:

Install the Microsoft VC++ Redistributable. We can do this from http://www.apachelounge.com/download. And look for 2.4.x VC11/14/VC15/VC1 link for windows 32 bit or 64 bit processor. In my case, my pc was Windows10 64 bits.

Be sure you installed latest 14.25.28508.3 Visual C++ Redistributable for Visual Studio 2015-2019 : vc_redist_x64 or vc_redist_x86 see Redistributable

Step 2:

Now download the zip file httpd-2.4.x-win64-VS16.zip from http://www.apachelounge.com/download/ for Apache 2.4.

Unzip the zip file, then rename the unzipped folder to anything suitable. I renamed it as Apache24. Put the folder in C:\ directory. So, my Apache is now at C:\Apache24.

Step 3:

Now get the file httpd.conf located at C:\Apache24\conf directory. It is a text file.

Open it with a suitable editor. I used Notepad++ for ease.

Specify the ServerRoot in this file: change it accordingly[ we have to uncomment and change these lines accordingly]

Define SRVROOT "c:/Apache24"

ServerRoot "${SRVROOT}"

Now specify the document root as in the following way: [We have to uncomment and change these lines accordingly]

DocumentRoot "${SRVROOT}/htdocs"

<Directory "${SRVROOT}/htdocs">

      ……………

       …………..

</Directory>

Step 4:

Now, at the command prompt, go to the bin folder of Apache24 i.e. C:\Apache24\bin>. Put there httpdß. This will will start apache services in your system.

Always remember to get the Command Prompt with Administrative privilege.

To check whether apache properly started in your system or not, you need to go to your internet browser and type in the address bar: http://localhost. Press Enter. If the browser shows “It Works”, it ensures that Apache is working successfully.

Actually, the Apache server executes the index.html or index.php file stored in the document root; This file is preinstalled when Apache is installed.

Now, again at the command prompt window, press CTRL + Cß. this will stop Apache and command prompt will come back again.

Note: whenever there is any change in apache system ie. httpd.conf or any allied files, you need the restart apache.

We can restart Apache with the following command:

>httpd -k restart

httpd command path should be accessible from the document root & remember to put command prompt in administrative mode.