Monthly Archives: July 2012

IIS 7: Install phpMyAdmin on Windows 7

Introduction

 

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.

 

You can download phpMyadmin at http://www.phpmyadmin.net/home_page/downloads.php You can choose from ‘All Languages’ or ‘English’ versions

The latest version (currently 3.2.5) is found at the top of the page.

It may be downloaded in various compression formats, being .7z or .tar.bz2 or .tar.gz or .zip

In this guide we will download the English zip file, which can be easily extracted on a Windows 7 machine without additional downloads.

 

Once you have doenloaded the zip file and turned off any antivirus or firewall you are ready to start

 

STEP 1

 

Open the folder you downloaded to and right click and click Extract All…

 

 

 

Step 2

Select a destination folder.

I have used the default folder which is the same folder the zip file was downloaded to

Click on Extract

 

 

 

Step 3

Screen shot below shows file being extracted by Windows 7

 

 

STEP 4

 

Open the location where you extracted the file

Open the folder phpMyAdmin-X.X.X-english (where X is the version number)

 

 

 

Step 5

The file you find in there will have the same file name.

You need to rename it phpmyadmin

 

 

 

Step 6

Right click the renamed file and Copy it to clipboard – right click and select Copy from list

 

 

STEP 7

 

Navigate to your web server root (C:\Inetpub\wwwroot) and paste the file there

 

 

 

Step 8

Open the phpmyadmin folder you pasted and create a new folder and name it config

Now close all open folders

 

 

 

Step 9

Open your Browser and type http://localhost/phpmyadmin/setup/index.php

This opens the configuration page

Ignore the security warnings as they are intended for server administrators installing phpMyAdmin on an internet server

On the bottom of the page click on New Server

 

 

STEP 10

 

You are required to set up the php configuration for your computer as follows

Check the following settins, some of which are entered by default

Server hostname: localhost

Connection Type: tcp

PHP extension to use: mysql

Authentication type: config

User for config auth: root

Password for config auth: Your MySQL root password

 

Scroll down and click Save

 

 

 

Step 11

The phpMyAdmin Overview page opens

 

Ignore any warnings

 

Under Servers ensure localhost appears under Name

 

Now close browser

 

 

 

Step 12

Navigate to your phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin)

Open the config folder

 

 

Step 13

Right click and copy the file config.inc

 

 

 

Step 14

Paste the config file to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin)

 

The official instructions instruct you to delete the config folder, however this is not necessary in a local testing environment

 

 

Step 15

Close all folders

Open Web Browser and type in http://localhost/phpmyadmin/ to start setting up your databases

 

Congratulations! – you have now created a PHP development environment.

 

NOTES: If you can not connect to MySQL and receive an error message from http://localhost/phpmyadmin/ it is more than likely an error in config.php file

Click here to download a very basic text file example

Go to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) and open config file & compare to downloaded sample

The only modification required is changing the password in file & save to phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) with file name config.php as a text file

It would be prudent to first rename the existing config file configOLD.php prior to saving file, just in case you need it later.

There is a more detailed sample file already in your phpmyadmin folder (C:\Inetpub\wwwroot\phpmyadmin) that can also be used called config.sample.inc.php (just rename config.inc.php)

 

 

Related Articles

 

Change Control Panel View on Windows 7

 

Disable User Account Control (UAC) on Windows 7

 

Install and Configure IIS 7.5 & PHP & FastCGI on Windows 7

 

Windows_7_Install_mcrypt_extension_and_libmcrypt_dll_for_PHP

 

Install MySQL on IIS 7.5 on Windows 7

Advertisements
Categories: កូនជាទីស្រលាញ់ | Leave a comment

Share Files and Printers between Windows 7 and XP

Share Files and Printers between Windows 7 and XP

If you have a home network and are running Windows 7 and have XP on other PC(s) you might want to share files between them.  Today we will look at the steps to share files and hardware devices like a printer.

Sharing Files In Windows 7 and XP

Sharing folders between two Windows 7 machines with the new HomeGroup feature is an easy process, but the HomeGroup feature is not compatible with Vista or XP.  For this tutorial we are using Windows 7 x64 RC1 and XP Professional SP3 connected through a basic Linksys home wireless router.

First make sure both machines are members of the same Workgroup which by default is named Workgroup.

workgroup

On the Windows 7 machine go into Control Panel \ All Control Panel Items \ Network and Sharing Center then click on Change advanced sharing settings.

network and sharing

advanced

You will want to verify the following settings under Advanced Sharing Settings for the Home or Work and Public profile.

home or work settings

If you want any user to have access the public shares turn off password protection.  This is located in Advanced Sharing Settings toward the bottom of the list.

turn off pw

If you want to keep it enabled make sure there is a log in account for the other XP machines and they have a password.

create pw

Now if you go into Network in Windows 7 you should see your XP machine and the Windows 7 as well which in this case is Mysticgeek-PC.

Explorer

To share the printer on the Windows 7 machine go into Devices and Printers from the Start menu and double click on the printer icon.

devices

Next double click on “Customize your printer”.

1 Printer

In the Properties screen click on the Sharing Tab and check the box to share the printer and type in its share name.

2 printer share

If your XP machine is an x86 OS you can install Additional Drivers before setting up the XP machine.

3 Printer add drivers

To find the shared folders and devices double click on the Windows 7 machine icon under Network.  Here you can see the printer connected to my Windows 7 machine is shared and also the Users Folder.

shared device and users

Continue into the Users folder and Public to see the shared folders, here I also created a folder called XP Share just to keep everything in central location.

xpshare

Over on your XP machine open up My Network Places to find the Windows 7 (mysticgeek-pc) shared folder.

My Network Places

Double click on the Share folder to find a list of shared folders in the Public folder on Windows 7.  If you have password protection enabled you will need to type in the username and password of the user account on the Windows 7 machine first.

folders

Setup XP With Shared Printer

To set up the shared printer in XP you will need to go into Printers and Faxes from the Start menu and kick off the Add Printer Wizard.

add Printer

Now select “A network printer, or a printer attached to another computer” then hit Next.

network option

Next select “Connect to this printer…” and type in the path for the printer connected to the Windows 7 machine and click next.  

print

Now click Yes to the confirmation message.

confirm msg

Then click Finish the printer to install and complete the Wizard.

Complete

In some cases you will need to install the x86 XP drivers for the shared printer because the Windows 7 drivers are not compatible with XP.  When everything is installed open up Printers and Faxes to find the shared printer.

in explorer

This should help you get started with sharing your files and other devices with your Windows 7 machine.  When I first started I was able to see the printer on XP right away because I had a HomeGroup set up, but once I deleted it I needed to share the printer like you would for a workgroup.  You might also have to do a couple restarts of the XP machine for it to see the shared resources on Windows 7.  If you have had any experiences with sharing between Windows 7 and XP leave us a comment!

Categories: កូនជាទីស្រលាញ់ | Leave a comment

Share Files and Printers between Windows 7 and XP

Share Files and Printers between Windows 7 and XP

If you have a home network and are running Windows 7 and have XP on other PC(s) you might want to share files between them.  Today we will look at the steps to share files and hardware devices like a printer.

Sharing Files In Windows 7 and XP

Sharing folders between two Windows 7 machines with the new HomeGroup feature is an easy process, but the HomeGroup feature is not compatible with Vista or XP.  For this tutorial we are using Windows 7 x64 RC1 and XP Professional SP3 connected through a basic Linksys home wireless router.

First make sure both machines are members of the same Workgroup which by default is named Workgroup.

workgroup

On the Windows 7 machine go into Control Panel \ All Control Panel Items \ Network and Sharing Center then click on Change advanced sharing settings.

network and sharing

advanced

You will want to verify the following settings under Advanced Sharing Settings for the Home or Work and Public profile.

home or work settings

If you want any user to have access the public shares turn off password protection.  This is located in Advanced Sharing Settings toward the bottom of the list.

turn off pw

If you want to keep it enabled make sure there is a log in account for the other XP machines and they have a password.

create pw

Now if you go into Network in Windows 7 you should see your XP machine and the Windows 7 as well which in this case is Mysticgeek-PC.

Explorer

To share the printer on the Windows 7 machine go into Devices and Printers from the Start menu and double click on the printer icon.

devices

Next double click on “Customize your printer”.

1 Printer

In the Properties screen click on the Sharing Tab and check the box to share the printer and type in its share name.

2 printer share

If your XP machine is an x86 OS you can install Additional Drivers before setting up the XP machine.

3 Printer add drivers

To find the shared folders and devices double click on the Windows 7 machine icon under Network.  Here you can see the printer connected to my Windows 7 machine is shared and also the Users Folder.

shared device and users

Continue into the Users folder and Public to see the shared folders, here I also created a folder called XP Share just to keep everything in central location.

xpshare

Over on your XP machine open up My Network Places to find the Windows 7 (mysticgeek-pc) shared folder.

My Network Places

Double click on the Share folder to find a list of shared folders in the Public folder on Windows 7.  If you have password protection enabled you will need to type in the username and password of the user account on the Windows 7 machine first.

folders

Setup XP With Shared Printer

To set up the shared printer in XP you will need to go into Printers and Faxes from the Start menu and kick off the Add Printer Wizard.

add Printer

Now select “A network printer, or a printer attached to another computer” then hit Next.

network option

Next select “Connect to this printer…” and type in the path for the printer connected to the Windows 7 machine and click next.  

print

Now click Yes to the confirmation message.

confirm msg

Then click Finish the printer to install and complete the Wizard.

Complete

In some cases you will need to install the x86 XP drivers for the shared printer because the Windows 7 drivers are not compatible with XP.  When everything is installed open up Printers and Faxes to find the shared printer.

in explorer

This should help you get started with sharing your files and other devices with your Windows 7 machine.  When I first started I was able to see the printer on XP right away because I had a HomeGroup set up, but once I deleted it I needed to share the printer like you would for a workgroup.  You might also have to do a couple restarts of the XP machine for it to see the shared resources on Windows 7.  If you have had any experiences with sharing between Windows 7 and XP leave us a comment!

Categories: កូនជាទីស្រលាញ់ | Leave a comment

Create a free website or blog at WordPress.com.