faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

11 of 17 people (65%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

Database:MySql: GUI: PHPMyAdmin: Where to download and how install PHPMyAdmin for Microsoft Windows?

May 6th, 2005 04:23
Knud van Eeden,


----------------------------------------------------------------------
--- Knud van Eeden --- 06 April 2005 - 04:48 pm ----------------------

Database:MySql: GUI: PHPMyAdmin: Where to download and how install 
PHPMyAdmin for Microsoft Windows?

---

Steps: Overview:

 1. -Goto the official PHPMyAdmin site

      http://www.phpmyadmin.net

 2. -Select from menu option 'Downloads'

 3. -Download it to your computer

     1. Select the version e.g.

        1. -Click on the link

             phpMyAdmin-2.6.2-rc1.zip

            1. -Select one of the available
                download sites

                1. -Click on the icon at the '2282 Kbyte' link

     -- or --

     1. Download the file directly at e.g.

         
http://easynews.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-
2.6.2-rc1.zip

 4. -Unzip the file to the web server directory on your harddisk

     1. -Unzip it to the following directory

         1. If Apache, use the 'htdocs' directory

         2. If Microsoft Internet Information Server (IIS) use 
the 'inetpub' directory

     2. To unzip, e.g. use the MSDOS command line command
        (only if you are using pkzipc.exe)

            pkzipc.exe -extract -dir phpMyAdmin-2.6.2-
rc1.zip "c:\program files\Apache Group\Apache2\htdocs"

        1. This will unzip it to the directory

            c:\Program Files\Apache Group\Apache2\htdocs\phpMyAdmin-
2.6.2-rc1\

           1. To see the installation instructions,

              1. Open e.g. the file

                  documentation.html

                 in the PHPMyAdmin directory in your webbrowser

  5. Installation of PHPMyAdmin

     1. -Open your favorite editor

        1. -Open the file

              config.inc.php

            1. -Possibly change the values for (but this should not be
                necessary if you install it on your local computer,
                with MySql running on your local computer also)

                 -host (this means your MySQL server name or IP 
address)

                 -user

                 -password

                 -authentication mode

                 -$cfg['PmaAbsoluteUri'] directive must be set

                   e.g.

                    
http://www.your_web.net/path_to_your_phpMyAdmin_directory/

                    e.g. (do not forget the semi column)

                     $cfg['PmaAbsoluteUri'] 
= 'http://localhost/phpMyAdmin-2.6.2-rc1/';

  6. Start PHPMyAdmin

     1. Start your web browser

        1. Start Apache

        -- or --

        1. Start Microsoft Internet Information Server (IIS)

           1. You must have PHP enabled on this webbrowser

     2. Open the PHPMyAdmin start file

         1. -Type the URL

              localhost/<your phpMyAdmin subdirectory>/index.php

               e.g.

                localhost/phpMyAdmin-2.6.2-rc1/index.php

             in general type:

              <http://www.your-host.com>/<your-install-dir>/index.php

         2. You should now see the PHPMyAdmin main page

            or

            a possibly a login screen
            (type your known userid + password in that case).

            1. -You should see the HTML page

                 'Welcome to phpMyAdmin'

                 'MySQL running'

                1. -Then in the left pane select your MySql
                    database from the list

                    1. -You can now start doing operations on this
                        database

                        1. -Create table

                        2. -Search

                        3. -...

---
---

Tested successfully on

Microsoft Windows XP Professional (service pack 2),

running

PHPMyAdmin v2.6.2

MySql v4.1

PHP v5

Apache v2

---
---

Internet: see also:

---

Database: MySql: GUI: PHPMyAdmin: Link: Overview: Can you give an 
overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35971/fid/1806

---

Database: Relational: MySql: Link: Overview: Can you give an overview 
of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/35331/fid/52

----------------------------------------------------------------------