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
----------------------------------------------------------------------